首页 > > 网络编程 > Mysql >

EasyUI中datagrid实现显示、增加、 删除、 修改…

2018-06-17 19:46:29来源：未知 阅读 ()

新老客户大回馈,云服务器低至5折

   菜鸟进入，高手请绕道！

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

一、数据的显示

 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]
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

特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有 

			   


               

                   
上一篇：C#操作XML的完整例子——XmlDocument篇 

                   
下一篇：ASP.NET登录控件延伸(个性化) 

               

               

                   

                       相关文章
                   

                   

                       

                           
                       

                   

               

           

            

			
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
			
			
程序设计：
			
			Java技术
			
			C/C++
			
			VB
			
			delphi
			
			
网络知识：
			
			网络协议
			
			网络安全
			
			网络管理
			
			组网方案
			
			Cisco技术
			
			
操作系统：
			
			Win2000
			
			WinXP
			
			Win2003
			
			Mac OS
			
			Linux
			
			FreeBSD
			
			

			

        

        

              

                
            

            

                
热门词条

                

				
				

            

            

                
最新资讯

                

                    
                

            

            

                
热门关注

                

                    
                

            

            

                
热门标签