首页 > 代码库 > EasyUI中datagrid实现显示、增加、 删除、 修改、 查询操作(后台代码C#)
EasyUI中datagrid实现显示、增加、 删除、 修改、 查询操作(后台代码C#)
菜鸟进入，高手请绕道！
+++++++++++++++++++++++++++++++++++++++
一、数据的显示
1新建HtmlPage2.html页面，引入相关文件。如下所示
<script src="http://www.mamicode.com/easyui/js/jquery-1.8.2.min.js"></script> <script src="http://www.mamicode.com/easyui/js/jquery.easyui.min.js"></script> <link href="http://www.mamicode.com/easyui/css/themes/default/easyui.css" rel="stylesheet" /> <link href="http://www.mamicode.com/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 =http://www.mamicode.com/= 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"> 性别：<input required="true" id="SearchSex"> <a href=http://www.mamicode.com/"#" class="easyui-linkbutton" id="search">查询</a> <a href=http://www.mamicode.com/"#" class="easyui-linkbutton" id="add">新增</a> <a href=http://www.mamicode.com/"#" class="easyui-linkbutton" id="delete">删除</a> <a href=http://www.mamicode.com/"#" class="easyui-linkbutton" id="edit">编辑</a> </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 =http://www.mamicode.com/= 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=http://www.mamicode.com/"保存" 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
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。