EasyUI中datagrid实现显示、增加、 删除、 修改…
2018-06-23 22:24:03来源：未知 阅读 ()
菜鸟进入，高手请绕道！
+++++++++++++++++++++++++++++++++++++++
一、数据的显示
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"> 性别：<input required="true" id="SearchSex"> <a href="#" class="easyui-linkbutton" id="search">查询</a> <a href="#" class="easyui-linkbutton" id="add">新增</a> <a href="#" class="easyui-linkbutton" id="delete">删除</a> <a href="#" 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 == 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] GO SET ANSI_PADDING OFF GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC 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' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户帐户表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo' GO 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'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
标签：
版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有
相关文章
- position: sticky实现导航栏下滑吸顶效果 2020-05-30
- Vue 结合html2canvas和jsPDF实现html页面转pdf 2020-04-25
- 10.布局:两栏和主区域在后的三栏布局，实现侧边栏和主区域伪 2020-04-12
- 5.通过定位实现二级菜单 2020-04-10
- HTML + CSS 布局实现全屏布局 2020-04-10
IDC资讯： 主机资讯 注册资讯 托管资讯 vps资讯 网站建设
网站运营： 建站经验 策划盈利 搜索优化 网站推广 免费资源
网络编程： Asp.Net编程 Asp编程 Php编程 Xml编程 Access Mssql Mysql 其它
服务器技术： Web服务器 Ftp服务器 Mail服务器 Dns服务器 安全防护
软件技巧： 其它软件 Word Excel Powerpoint Ghost Vista QQ空间 QQ FlashGet 迅雷
网页制作： FrontPages Dreamweaver Javascript css photoshop fireworks Flash
热门词条
最新资讯
热门关注
热门标签