EasyUI中datagrid实现显示、增加、删除、修改、查询操作(后台代码C#)

菜鸟进入，高手请绕道！

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

一、数据的显示

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) {returnvalue ==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代码：

usingSystem.Data.SqlClient;usingSystem.Data;usingSystem.Text;///<summary>///HtmlPage2 的摘要说明///</summary>publicclassHtmlPage2 : IHttpHandler

{publicvoidPRocessRequest(HttpContext context)

{

context.Response.ContentType="text/html";intpage =int.Parse(context.Request.Form["page"]);//页码introws =int.Parse(context.Request.Form["rows"])；//页容量InitData(context,page,rows);}privatevoidInitData(HttpContext context,intpageindex,intpagesize)

{inttotal;stringsql =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=newDataSet();

DataTable dt=newDataTable();

StringBuilder sb=newStringBuilder();using(SqlConnection con =newSqlConnection("server=.;database=RM_DB;uid=sa;pwd=sa"))

{

con.Open();

SqlDataAdapter da=newSqlDataAdapter(sql, con);

da.Fill(ds);

dt= ds.Tables[0];

SqlCommand cmd=newSqlCommand("select count(*) from Base_UserInfo", con);//总行数

total=(int) cmd.ExecuteScalar();

con.Close();

}

sb.Append("{\"total\":"+total);

sb.Append(",");

sb.Append("\"rows\":[");

//转化为Json格式foreach(DataRow rowindt.Rows)

{

sb.Append("{");foreach(DataColumn columnindt.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中添加如下代码。

<divclass="easyui-accordion"style="width: 1066px; height: auto;">

<div title="操作栏"data-options=""style="overflow: auto; padding: 10px;">

<ulclass="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) {returnvalue ==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代码

usingSystem.Data.SqlClient;usingSystem.Data;usingSystem.Text;///<summary>///HtmlPage2 的摘要说明///</summary>publicclassHtmlPage2 : IHttpHandler

{publicvoidProcessRequest(HttpContext context)

{

context.Response.ContentType="text/html";intpage =int.Parse(context.Request.Form["page"]);introws =int.Parse(context.Request.Form["rows"]);ChaxunData(context,page,rows);

}

privatevoidChaxunData(HttpContext context,intpageindex,intpagesize)

{inttotal;stringsql ="select * from (select *,ROW_NUMBER() over (order by user_id) as id from Base_UserInfo) as tmp where 1=1";stringtsql =string.Empty;stringUserName = context.Request.Form["UserName"];stringsex = 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))

{ints = (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=newDataSet();

DataTable dt=newDataTable();

StringBuilder sb=newStringBuilder();using(SqlConnection con =newSqlConnection("server=.;database=RM_DB;uid=sa;pwd=sa"))

{

con.Open();

SqlDataAdapter da=newSqlDataAdapter(sql, con);

da.Fill(ds);

dt= ds.Tables[0];

SqlCommand cmd=newSqlCommand("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 rowindt.Rows)

{

sb.Append("{");foreach(DataColumn columnindt.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());

}

}

查询结果举例：支持查询结果的分页

三、新增、修改

varisEdit=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() {varform = $("#from1").serialize();

form+="&type=add";

$.post("/operator.ashx",//代码附后form,

function (js) {

$('#CommonWin').window("close");

$("#dg").datagrid("reload");

})

}

function SaveEdit() {varform = $("#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代码：

usingSystem.Data.SqlClient;usingSystem.Data;///<summary>///_operator 的摘要说明///</summary>publicclass_operator : IHttpHandler

{///<summary>///当前上下文对象///</summary>publicHttpRequest Request

{get{returnHttpContext.Current.Request;

}

}privateHttpResponse Response

{get{returnHttpContext.Current.Response; }

}publicvoidProcessRequest(HttpContext context)

{

context.Response.ContentType="text/html";stringtype=Request.Params["type"];switch(type)

{case"add": Add();

break;case"delete": Delete();

break;case"edit": Edit();

break;case"update": Update();

break;

}

}///<summary>///得到编辑的数据///</summary>privatevoidEdit()

{stringuserid = Request.QueryString["User_ID"];stringsql =string.Format("select * from Base_UserInfo where User_ID='{0}'", userid);

DataTable dt=newDataTable();

DataSet ds=newDataSet();using(SqlConnection con =newSqlConnection("server=.;database=RM_DB;uid=sa;pwd=sa"))

{

SqlDataAdapter da=newSqlDataAdapter(sql, con);

da.Fill(ds);

dt= ds.Tables[0];

}

MessageShow(1,"ww", dt);

}///<summary>///添加///</summary>privatevoidAdd()

{stringusername = Request.Form["username"];stringuserpwd = Request.Form["userpwd"];stringusersex = Request.Form["usersex"];inti = (usersex =="男") ?1:( usersex =="女")?0:1;stringuid =Guid.NewGuid().ToString();stringsql =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 =newSqlConnection("server=.;database=RM_DB;uid=sa;pwd=sa"))

{

con.Open();

SqlCommand cmd=newSqlCommand(sql, con);

cmd.ExecuteNonQuery();

con.Close();

MessageShow(1,"新增成功",null);

}

}///<summary>///删除操作///</summary>privatevoidDelete()

{stringUser_ID = Request.QueryString["User_ID"];//删除的主键stringsql="delete Base_UserInfo where User_ID=@User_ID";using(SqlConnection con=newSqlConnection("server=.;database=RM_DB;uid=sa;pwd=sa"))

{

con.Open();

SqlCommand cmd=newSqlCommand(sql,con);

SqlParameter p=newSqlParameter("@User_ID", User_ID);

cmd.Parameters.Add(p);

cmd.ExecuteNonQuery();

con.Close();

MessageShow(1,"删除成功",null);

}

}///<summary>///更新///</summary>privatevoidUpdate()

{

//todo();}///<summary>///统一返回浏览器消息///</summary>///<param name="s">状态</param>///<param name="m">消息提示</param>///<param name="d">数据</param>publicvoidMessageShow(ints,stringm,objectd)

{

MessageInfo min=newMessageInfo(s,m,d);

System.Web.Script.Serialization.javaScriptSerializer js=newSystem.Web.Script.Serialization.JavascriptSerializer();stringToJson =js.Serialize(min);

Response.Write(ToJson);

}publicboolIsReusable

{get{returnfalse;

}

}

}

四 删除：

前端代码 后台代码见上

//删除$("#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]CREATETABLE[dbo].[Base_UserInfo]([User_ID][dbo].[Name(50)]NOTNULL,[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]PRIMARYKEYNONCLUSTERED([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]GOSETANSI_PADDINGOFFGOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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'GOEXECsys.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(0x0000A355013CE2E9ASDateTime),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(0x0000A355013F70E8ASDateTime),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(0x0000A19400C4E4B0ASDateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理员(system)',CAST(0x0000A1B10157D004ASDateTime), 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(0x0000A19400C4E4B0ASDateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理员(system)',CAST(0x0000A1B10157D964ASDateTime), 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(0x0000A19400C4E4B0ASDateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理员(system)',CAST(0x0000A1B101580268ASDateTime), 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(0x0000A19400C4E4B0ASDateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理员(system)',CAST(0x0000A1B600B31B2BASDateTime), 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(0x0000A19400C4E4B0ASDateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理员(system)',CAST(0x0000A1B101581654ASDateTime), 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(0x0000A19400C4E4B0ASDateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理员(system)',CAST(0x0000A1B101583148ASDateTime), 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(0x0000A19400C4E4B0ASDateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理员(system)',CAST(0x0000A1B101583BD4ASDateTime), 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(0x0000A19400C4E4B0ASDateTime), 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(0x0000A1B10150A158ASDateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理员(system)',CAST(0x0000A1B801030761ASDateTime), N'48f3889c-af8d-401f-ada2-c383031af92d', N'管理员(system)', N'')/****** Object: Default [DF_Base_UserInfo_DeleteMark] Script Date: 06/25/2014 20:38:18 ******/ALTERTABLE[dbo].[Base_UserInfo]ADDCONSTRAINT[DF_Base_UserInfo_DeleteMark]DEFAULT((1))FOR[DeleteMark]GO/****** Object: Default [DF_Base_UserInfo_CreateDate] Script Date: 06/25/2014 20:38:18 ******/ALTERTABLE[dbo].[Base_UserInfo]ADDCONSTRAINT[DF_Base_UserInfo_CreateDate]DEFAULT(getdate())FOR[CreateDate]GO