EasyUI中datagrid實現顯示、增加、刪除、修改、查詢操作(后臺代碼C#)

2019-11-14 16:36:51

字體：大中小

來源：轉載

供稿：網友

菜鳥進入，高手請繞道！

+++++++++++++++++++++++++++++++++++++++

一、數據的顯示

1新建HtmlPage2.html頁面，引入相關文件。如下所示

   <script src="easyui/js/jquery-1.8.2.min.js"></script>    <script src="easyui/js/jquery.easyui.min.js"></script>    <link href="easyui/CSS/themes/default/easyui.css" rel="stylesheet" />    <link href="easyui/css/themes/icon.css" rel="stylesheet" />

2datagrid加載數據。代碼如下所示

 $(function () {            $('#dg').datagrid({                url: 'HtmlPage2.ashx',//請求數據的URL 代碼附后                columns: [[                    { field: 'User_Name', title: '用戶名', width: 100, align: 'center' }, //User_Name為數據庫表中的字段名稱 下同                    { field: 'User_Pwd', title: '密碼', width: 300, align: 'center' },                    { field: 'User_Sex', title: '性別', width: 100, align: 'center', formatter: function (value) { return value == 1 ? "男" : "女"; } },                     { field: 'User_Code', title: '員工號', width: 100, align: 'center' },                    { field: 'CreateUserName', title: '創建者', width: 100, align: 'center' },                    { field: 'Email', title: '電子郵件', width: 100, align: 'center' },                    { field: 'ModifyUserName', title: '修改者', width: 100, align: 'center' },                ]],                width: 1066,                rowStyler: function (index, row) { if (index % 2 == 0) { return 'background-color:#808080;'; } },                striped: true, pagination: true, rownumbers: true, singleSelect: true, pageNumber: 1, pageSize: 8, pageList: [1, 2, 4, 8, 16, 32], showFooter: true            });}
<dody>
  <table id="dg"></table> 
</body>
============================

HtmlPage2.ashx代碼：

    using System.Data.SqlClient;    using System.Data;    using System.Text;    /// <summary>    /// HtmlPage2 的摘要說明    /// </summary>    public class HtmlPage2 : IHttpHandler    {        public void PRocessRequest(HttpContext context)        {            context.Response.ContentType = "text/html";int page = int.Parse(context.Request.Form["page"]);//頁碼            int rows = int.Parse(context.Request.Form["rows"])；//頁容量            InitData(context,page,rows);        }        private void InitData(HttpContext context,int pageindex,int pagesize)        {            int total;            string sql =string.Format("select * from (select *,ROW_NUMBER() over (order by user_id) as id from Base_UserInfo) as tmp where tmp.id between {0}+1  and {1}",(pageindex-1)*pagesize,pagesize*pageindex);            DataSet ds = new DataSet();            DataTable dt = new DataTable();            StringBuilder sb = new StringBuilder();            using (SqlConnection con = new SqlConnection("server=.;database=RM_DB;uid=sa;pwd=sa"))            {                con.Open();                SqlDataAdapter da = new SqlDataAdapter(sql, con);                da.Fill(ds);                dt = ds.Tables[0];                SqlCommand cmd = new SqlCommand("select count(*) from Base_UserInfo", con);//總行數                total =(int) cmd.ExecuteScalar();                con.Close();            }            sb.Append("{/"total/":" + total);            sb.Append(",");            sb.Append("/"rows/":[");
           //轉化為Json格式            foreach (DataRow row in dt.Rows)            {                sb.Append("{");                foreach (DataColumn column in dt.Columns)                {                    sb.Append("/"" + column.ColumnName + "/":/"" + row[column.ColumnName].ToString() + "/",");                }                sb.Remove(sb.Length - 1, 1);                sb.Append("},");            }            sb.Remove(sb.Length - 1, 1);            sb.Append("]}");            context.Response.Write(sb.ToString());        }
}

3.效果如圖所示

二、查詢。在body中添加如下代碼。

 <div class="easyui-accordion" style="width: 1066px; height: auto;">                        <div title="操作欄" data-options="" style="overflow: auto; padding: 10px;">                            <ul class="easyui-tree">                                <div style="margin: 10px 0;">                                </div>                                用戶名：<input required="true" id="SearchUserName">&nbsp;                                 性別：<input required="true" id="SearchSex">&nbsp;                                 <a href="#" class="easyui-linkbutton" id="search">查詢</a>&nbsp;&nbsp;                                <a href="#" class="easyui-linkbutton" id="add">新增</a>&nbsp;&nbsp;                                <a href="#" class="easyui-linkbutton" id="delete">刪除</a>&nbsp;&nbsp;                                <a href="#" class="easyui-linkbutton" id="edit">編輯</a>&nbsp;&nbsp;                            </ul>                       </div></div>

效果圖如下：

查詢代碼：

$("#search").click(function () {                $('#dg').datagrid({                    url: '/HtmlPage3.ashx',//代碼附后                    loadMsg: '正在加載中',                    columns: [[                     { field: 'User_Name', title: '用戶名', width: 100 },                     { field: 'User_Pwd', title: '密碼', width: 100 },                     { field: 'User_Sex', title: '性別', width: 100, align: 'right', formatter: function (value) { return value == 1 ? "男" : "女"; } },                      { field: 'User_Code', title: '員工號', width: 100 },                     { field: 'CreateUserName', title: '創建者', width: 100 },                    ]], width: 1066,                    queryParams: {                        UserName: $("#SearchUserName").val(),                        sex: $("#SearchSex").val(),   //發送額外的參數                    },                    rowStyler: function (index, row) {                        if (index % 2 == 0) {                            return 'background-color:#6293BB;color:#fff;';                        }                    },                    striped: true, pagination: true, rownumbers: true, singleSelect: true, pageNumber: 1, pageSize: 8, pageList: [1, 2, 4, 8, 16, 32], showFooter: true                })            })
============

HtmlPage3.ashx代碼

using System.Data.SqlClient;    using System.Data;    using System.Text;    /// <summary>    /// HtmlPage2 的摘要說明    /// </summary>    public class HtmlPage2 : IHttpHandler    {        public void ProcessRequest(HttpContext context)        {            context.Response.ContentType = "text/html";int page = int.Parse(context.Request.Form["page"]);            int rows = int.Parse(context.Request.Form["rows"]);            ChaxunData(context,page,rows);        }

  private void ChaxunData(HttpContext context,int pageindex,int pagesize)        {            int total;            string sql = "select * from (select *,ROW_NUMBER() over (order by user_id) as id from Base_UserInfo) as tmp where 1=1  ";            string tsql = string.Empty;            string UserName = context.Request.Form["UserName"];            string sex = context.Request.Form["sex"];            if (!string.IsNullOrEmpty(UserName))            {                sql += string.Format(" and User_Name='{0}'", UserName) ;                tsql += string.Format(" and User_Name='{0}'", UserName);            }            if (!string.IsNullOrEmpty(sex))            {                int s = (sex == "男") ? 1 : 0;                sql += string.Format(" and User_Sex='{0}' ",s);                tsql += string.Format(" and User_Sex='{0}'", s);            }            sql += string.Format(" and  tmp.id between {0}+1  and {1}", (pageindex - 1) * pagesize, pagesize * pageindex);            DataSet ds = new DataSet();            DataTable dt = new DataTable();            StringBuilder sb = new StringBuilder();            using (SqlConnection con = new SqlConnection("server=.;database=RM_DB;uid=sa;pwd=sa"))            {                con.Open();                SqlDataAdapter da = new SqlDataAdapter(sql, con);                da.Fill(ds);                dt = ds.Tables[0];                SqlCommand cmd = new SqlCommand("select count(*) from Base_UserInfo  where 1=1 "+tsql, con);                total = (int)cmd.ExecuteScalar();                con.Close();            }            sb.Append("{/"total/":" + total);            sb.Append(",");            sb.Append("/"rows/":[");            foreach (DataRow row in dt.Rows)            {                sb.Append("{");                foreach (DataColumn column in dt.Columns)                {                    sb.Append("/"" + column.ColumnName + "/":/"" + row[column.ColumnName].ToString() + "/",");                }                sb.Remove(sb.Length - 1, 1);                sb.Append("},");            }            sb.Remove(sb.Length - 1, 1);            sb.Append("]}");            context.Response.Write(sb.ToString());        }
}

查詢結果舉例：支持查詢結果的分頁

三、新增、修改

  var isEdit=true;       //初始化操作窗體            $('#CommonWin').window({                width: 300,                height: 150,                modal: true,                minimizable: false,                maximizable: false,                draggable: false,                resizable: false,                collapsible: false,                title: '用戶操作',                left: 400,                top: 400            }).window("close");------點擊新增事件------ $("#add").click(function () {                isEdit = false;                $('#CommonWin').window("open");            })-------修改-------- $("#edit").click(function () {                isEdit = true;                var $selectRow = $("#dg").datagrid("getSelected");                if ($selectRow) {                    $.get("/Operator.ashx?type=edit&User_ID=" + $selectRow.User_ID,                        function (js) {                            alert(js.data.User_Name);                            $("#userid").val(js.data.User_ID);                            $("#username").val(js.data.User_Name);                            $("#userpwd").val(js.data.User_Pwd);                            $("#usersex").val(js.data.User_Sex==1?"男":"女");                            $('#CommonWin').window("open");                        });                }                else {                    $.messager.alert('提示', '請選擇要操作的行！', 'info');                }            })------保存----   function Save() {            if (isEdit) {                SaveEdit();            }            else {                SaveAdd();            }        }---------------------- function SaveAdd() {            var form = $("#from1").serialize();            form += "&type=add";            $.post(                "/operator.ashx",//代碼附后                form,                function (js) {                    $('#CommonWin').window("close");                    $("#dg").datagrid("reload");                })        } function SaveEdit() {            var form = $("#from1").serialize();            form += "&type=update";            $.post(                "/operator.ashx",                form,                function (js) {                    $('#CommonWin').window("close");                    $("#dg").datagrid("reload");                })        }-----------------------------body-----------<div id="CommonWin">    <form id="from1" >        <table border="0" cellspacing="0" cellpadding="0" width="100%">            <tr>                <td><input type="hidden" name="userid" id="userid" /></td>            </tr>            <tr>                <td>用戶名:<input type="text" name="username" id="username"></td>            </tr>            <tr>                <td>密  碼:<input type="text" name="userpwd" id="userpwd"></td>            </tr>            <tr>                <td>性  別:<input type="text" name="usersex" id="usersex"></td>            </tr>            <tr><td><input type="submit" value="保存"  onclick="Save()"/></td></tr>        </table>    </form></div>

operator.ashx代碼：

   using System.Data.SqlClient;    using System.Data;    /// <summary>    /// _operator 的摘要說明    /// </summary>    public class _operator : IHttpHandler    {        /// <summary>        /// 當前上下文對象        /// </summary>        public HttpRequest Request        {            get            {                return HttpContext.Current.Request;            }        }        private HttpResponse Response        {            get { return HttpContext.Current.Response; }        }        public void ProcessRequest(HttpContext context)        {            context.Response.ContentType = "text/html";           string type=Request.Params["type"];           switch (type)           {               case "add": Add(); break;               case "delete": Delete(); break;               case "edit": Edit(); break;               case "update": Update(); break;            }                   }        /// <summary>        /// 得到編輯的數據        /// </summary>        private void Edit()        {            string userid = Request.QueryString["User_ID"];            string sql = string.Format("select * from  Base_UserInfo where User_ID='{0}'", userid);            DataTable dt = new DataTable();            DataSet ds = new DataSet();            using (SqlConnection con = new SqlConnection("server=.;database=RM_DB;uid=sa;pwd=sa"))            {                SqlDataAdapter da = new SqlDataAdapter(sql, con);                da.Fill(ds);                dt = ds.Tables[0];            }            MessageShow(1, "ww", dt);        }        /// <summary>        /// 添加        /// </summary>        private void Add()        {            string username = Request.Form["username"];            string userpwd = Request.Form["userpwd"];            string usersex = Request.Form["usersex"];            int i = (usersex == "男") ? 1 :( usersex == "女" )? 0 : 1;            string uid = Guid.NewGuid().ToString();            string sql = string.Format("insert Base_UserInfo(User_ID,User_Name,User_Pwd,User_Sex)values('{0}','{1}','{2}',{3})", uid, username, userpwd,i);            using (SqlConnection con = new SqlConnection("server=.;database=RM_DB;uid=sa;pwd=sa"))            {                con.Open();                SqlCommand cmd = new SqlCommand(sql, con);                cmd.ExecuteNonQuery();                con.Close();                MessageShow(1, "新增成功", null);            }        }       /// <summary>       /// 刪除操作       /// </summary>        private void Delete()        {            string User_ID = Request.QueryString["User_ID"];//刪除的主鍵            string sql="delete Base_UserInfo where User_ID=@User_ID";            using(SqlConnection con=new SqlConnection("server=.;database=RM_DB;uid=sa;pwd=sa"))            {                con.Open();                SqlCommand cmd = new SqlCommand(sql,con);                SqlParameter p = new SqlParameter("@User_ID", User_ID);                cmd.Parameters.Add(p);                cmd.ExecuteNonQuery();                con.Close();                MessageShow(1, "刪除成功", null);            }        }        /// <summary>        /// 更新        /// </summary>        private void Update()        {          //todo();        }        /// <summary>        /// 統一返回瀏覽器消息        /// </summary>        /// <param name="s">狀態</param>        /// <param name="m">消息提示</param>        /// <param name="d">數據</param>        public void MessageShow(int s, string m, object d)        {            MessageInfo min = new MessageInfo(s,m,d);            System.Web.Script.Serialization.javaScriptSerializer js = new System.Web.Script.Serialization.JavascriptSerializer();            string ToJson = js.Serialize(min);            Response.Write(ToJson);        }        public bool IsReusable        {            get            {                return false;            }        }    }

四刪除：

前端代碼后臺代碼見上

   //刪除            $("#delete").click(function () {                var $selectRow = $("#dg").datagrid("getSelected");                if ($selectRow) {                    $.messager.confirm('確認對話框', '您確定要刪除么？', function (r) {                        if (r) {                            $.get("/operator.ashx?type=delete&User_ID=" + $selectRow.User_ID,                                function (js) { $("#dg").datagrid("reload"); });                        }                    });                }                else {                    $.messager.alert('提示', '請選擇要操作的行！', 'info');                }            });

注：數據庫代碼

USE [RM_DB]CREATE TABLE [dbo].[Base_UserInfo](    [User_ID] [dbo].[Name(50)] NOT NULL,    [User_Code] [dbo].[Name(50)] NULL,    [User_Account] [dbo].[Name(50)] NULL,    [User_Pwd] [dbo].[Name(50)] NULL,    [User_Name] [dbo].[Name(50)] NULL,    [User_Sex] [dbo].[ID] NULL,    [Title] [dbo].[Name(50)] NULL,    [Email] [dbo].[Name(20)] NULL,    [Theme] [dbo].[Name(50)] NULL,    [Question] [dbo].[Name(50)] NULL,    [AnswerQuestion] [dbo].[Name(50)] NULL,    [DeleteMark] [dbo].[ID] NULL,    [CreateDate] [Date] NULL,    [CreateUserId] [dbo].[Name(50)] NULL,    [CreateUserName] [dbo].[Name(50)] NULL,    [ModifyDate] [Date] NULL,    [ModifyUserId] [dbo].[Name(50)] NULL,    [ModifyUserName] [dbo].[Name(50)] NULL,    [User_Remark] [dbo].[Name(Max)] NULL, CONSTRAINT [PK_BASE_USERINFO] PRIMARY KEY NONCLUSTERED (    [User_ID] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用戶主鍵' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_ID'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'編號' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_Code'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用戶賬戶' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_Account'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用戶密碼' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_Pwd'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用戶姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_Name'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性別 1：男、0：女' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_Sex'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'職稱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'Title'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'電子郵件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'Email'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系統樣式選擇' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'Theme'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密碼提示問題' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'Question'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密碼提示答案' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'AnswerQuestion'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'刪除標記 1：正常，2：鎖定，0：刪除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建時間' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建用戶主鍵' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建用戶' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改時間' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'ModifyDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用戶主鍵' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'ModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用戶' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'ModifyUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'備注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_Remark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用戶帳戶表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo'GOINSERT [dbo].[Base_UserInfo] ([User_ID], [User_Code], [User_Account], [User_Pwd], [User_Name], [User_Sex], [Title], [Email], [Theme], [Question], [AnswerQuestion], [DeleteMark], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName], [User_Remark]) VALUES (N'4f6531ac-ae1b-40a3-8b3b-546e7f767c77', NULL, NULL, N'qwe', N'林', 1, NULL, NULL, NULL, NULL, NULL, 1, CAST(0x0000A355013CE2E9 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL)INSERT [dbo].[Base_UserInfo] ([User_ID], [User_Code], [User_Account], [User_Pwd], [User_Name], [User_Sex], [Title], [Email], [Theme], [Question], [AnswerQuestion], [DeleteMark], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName], [User_Remark]) VALUES (N'e987cb03-b62f-4c34-b899-15ffa0ee58e7', NULL, NULL, N'1', N'23', 1, NULL, NULL, NULL, NULL, NULL, 1, CAST(0x0000A355013F70E8 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL)INSERT [dbo].[Base_UserInfo] ([User_ID], [User_Code], [User_Account], [User_Pwd], [User_Name], [User_Sex], [Title], [Email], [Theme], [Question], [AnswerQuestion], [DeleteMark], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName], [User_Remark]) VALUES (N'094f85f8-bc53-4247-979c-09da591d51b0', N'000002', N'minmin', N'4A7D1ED414474E4033AC29CCB8653D9B', N'敏敏', 1, N'', N'', NULL, NULL, NULL, 1, CAST(0x0000A19400C4E4B0 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', CAST(0x0000A1B10157D004 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', N'')INSERT [dbo].[Base_UserInfo] ([User_ID], [User_Code], [User_Account], [User_Pwd], [User_Name], [User_Sex], [Title], [Email], [Theme], [Question], [AnswerQuestion], [DeleteMark], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName], [User_Remark]) VALUES (N'10476848-5b91-411a-a35e-c24a205e7365', N'000003', N'hz', N'4A7D1ED414474E4033AC29CCB8653D9B', N'華仔', 1, N'', N'', NULL, NULL, NULL, 1, CAST(0x0000A19400C4E4B0 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', CAST(0x0000A1B10157D964 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', N'')INSERT [dbo].[Base_UserInfo] ([User_ID], [User_Code], [User_Account], [User_Pwd], [User_Name], [User_Sex], [Title], [Email], [Theme], [Question], [AnswerQuestion], [DeleteMark], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName], [User_Remark]) VALUES (N'4158bc01-004b-4677-8b86-0e3e4c483f6e', N'000006', N'ln', N'4A7D1ED414474E4033AC29CCB8653D9B', N'李娜', 1, N'', N'', NULL, NULL, NULL, 1, CAST(0x0000A19400C4E4B0 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', CAST(0x0000A1B101580268 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', N'')INSERT [dbo].[Base_UserInfo] ([User_ID], [User_Code], [User_Account], [User_Pwd], [User_Name], [User_Sex], [Title], [Email], [Theme], [Question], [AnswerQuestion], [DeleteMark], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName], [User_Remark]) VALUES (N'4baa8438-930f-4b02-8fc1-d67bd43d2fb0', N'000007', N'lw', N'4A7D1ED414474E4033AC29CCB8653D9B', N'劉偉', 1, N'', N'', NULL, NULL, NULL, 1, CAST(0x0000A19400C4E4B0 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', CAST(0x0000A1B600B31B2B AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', N'dd')INSERT [dbo].[Base_UserInfo] ([User_ID], [User_Code], [User_Account], [User_Pwd], [User_Name], [User_Sex], [Title], [Email], [Theme], [Question], [AnswerQuestion], [DeleteMark], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName], [User_Remark]) VALUES (N'4ef78175-afc9-48e4-9b85-13f1e9a86a79', N'000008', N'zm', N'4A7D1ED414474E4033AC29CCB8653D9B', N'張敏', 1, N'', N'', NULL, NULL, NULL, 1, CAST(0x0000A19400C4E4B0 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', CAST(0x0000A1B101581654 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', N'')INSERT [dbo].[Base_UserInfo] ([User_ID], [User_Code], [User_Account], [User_Pwd], [User_Name], [User_Sex], [Title], [Email], [Theme], [Question], [AnswerQuestion], [DeleteMark], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName], [User_Remark]) VALUES (N'74f86691-537a-4c5c-a7e8-6f68bbe95788', N'000011', N'xe', N'4A7D1ED414474E4033AC29CCB8653D9B', N'雪兒', 1, N'', N'', NULL, NULL, NULL, 1, CAST(0x0000A19400C4E4B0 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', CAST(0x0000A1B101583148 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', N'')INSERT [dbo].[Base_UserInfo] ([User_ID], [User_Code], [User_Account], [User_Pwd], [User_Name], [User_Sex], [Title], [Email], [Theme], [Question], [AnswerQuestion], [DeleteMark], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName], [User_Remark]) VALUES (N'7510d804-cb83-41bb-94a7-1d35211d7814', N'000012', N'xe', N'4A7D1ED414474E4033AC29CCB8653D9B', N'瓶子', 1, N'', N'', NULL, NULL, NULL, 1, CAST(0x0000A19400C4E4B0 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', CAST(0x0000A1B101583BD4 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', N'')INSERT [dbo].[Base_UserInfo] ([User_ID], [User_Code], [User_Account], [User_Pwd], [User_Name], [User_Sex], [Title], [Email], [Theme], [Question], [AnswerQuestion], [DeleteMark], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName], [User_Remark]) VALUES (N'75e1f7a2-74ab-4d21-af74-a601f30f02ee', N'000013', N'wf', N'4A7D1ED414474E4033AC29CCB8653D9B', N'王芳', 1, NULL, NULL, NULL, NULL, NULL, 1, CAST(0x0000A19400C4E4B0 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', NULL, NULL, NULL, NULL)INSERT [dbo].[Base_UserInfo] ([User_ID], [User_Code], [User_Account], [User_Pwd], [User_Name], [User_Sex], [Title], [Email], [Theme], [Question], [AnswerQuestion], [DeleteMark], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName], [User_Remark]) VALUES (N'0ede986c-5a68-4e74-9198-3c1e5015e0d2', N'100023', N'test', N'4A7D1ED414474E4033AC29CCB8653D9B', N'測試員', 1, N'軟件工程師', N'', NULL, NULL, NULL, 1, CAST(0x0000A1B10150A158 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', CAST(0x0000A1B801030761 AS DateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理員(system)', N'')/****** Object:  Default [DF_Base_UserInfo_DeleteMark]    Script Date: 06/25/2014 20:38:18 ******/ALTER TABLE [dbo].[Base_UserInfo] ADD  CONSTRAINT [DF_Base_UserInfo_DeleteMark]  DEFAULT ((1)) FOR [DeleteMark]GO/****** Object:  Default [DF_Base_UserInfo_CreateDate]    Script Date: 06/25/2014 20:38:18 ******/ALTER TABLE [dbo].[Base_UserInfo] ADD  CONSTRAINT [DF_Base_UserInfo_CreateDate]  DEFAULT (getdate()) FOR [CreateDate]GO