Example #1
0
 private void ShowInfo(int UserID)
 {
     Maticsoft.BLL.sys_User   bll   = new Maticsoft.BLL.sys_User();
     Maticsoft.Model.sys_User model = bll.GetModel(UserID);
     this.lblUserID.Text            = model.UserID.ToString();
     this.txtU_LoginName.Text       = model.U_LoginName;
     this.txtU_Password.Text        = model.U_Password;
     this.txtU_CName.Text           = model.U_CName;
     this.txtU_EName.Text           = model.U_EName;
     this.txtU_GroupID.Text         = model.U_GroupID.ToString();
     this.txtU_Email.Text           = model.U_Email;
     this.txtU_Type.Text            = model.U_Type.ToString();
     this.txtU_Status.Text          = model.U_Status.ToString();
     this.txtU_Licence.Text         = model.U_Licence;
     this.txtU_Mac.Text             = model.U_Mac;
     this.txtU_Remark.Text          = model.U_Remark;
     this.txtU_IDCard.Text          = model.U_IDCard;
     this.txtU_Sex.Text             = model.U_Sex.ToString();
     this.txtU_BirthDay.Text        = model.U_BirthDay.ToString();
     this.txtU_MobileNo.Text        = model.U_MobileNo;
     this.txtU_UserNO.Text          = model.U_UserNO;
     this.txtU_WorkStartDate.Text   = model.U_WorkStartDate.ToString();
     this.txtU_WorkEndDate.Text     = model.U_WorkEndDate.ToString();
     this.txtU_CompanyMail.Text     = model.U_CompanyMail;
     this.txtU_Title.Text           = model.U_Title.ToString();
     this.txtU_Extension.Text       = model.U_Extension;
     this.txtU_HomeTel.Text         = model.U_HomeTel;
     this.txtU_PhotoUrl.Text        = model.U_PhotoUrl;
     this.txtU_DateTime.Text        = model.U_DateTime.ToString();
     this.txtU_LastIP.Text          = model.U_LastIP;
     this.txtU_LastDateTime.Text    = model.U_LastDateTime.ToString();
     this.txtU_ExtendField.Text     = model.U_ExtendField;
     this.txtU_LoginType.Text       = model.U_LoginType;
     this.txtU_HospitalGroupID.Text = model.U_HospitalGroupID.ToString();
 }
Example #2
0
        /// <summary>
        /// 在编辑的时候将对应的值绑定到Label上
        /// </summary>
        private void InputData()
        {
            //这两句和73、75作用一样
            Maticsoft.BLL.supervision_Info   bll   = new Maticsoft.BLL.supervision_Info();
            Maticsoft.Model.supervision_Info model = bll.GetModel(InfoID);

            //以下几行需要更改
            this.I_FindDate.Text      = this.I_FindDate_Txt.Text = model.I_FindDate.ToShortDateString();
            this.I_Type.SelectedValue = model.I_Type + "";
            this.I_Type_Txt.Text      = getSuperisionNameByType(model.I_Type);
            this.I_Content.Text       = this.I_Content_Txt.Text = model.I_Content;
            this.I_ReportDate.Text    = this.I_ReportDate.Text = model.I_ReportDate.ToShortDateString();
            Maticsoft.BLL.sys_User   user_bll   = new Maticsoft.BLL.sys_User();
            Maticsoft.Model.sys_User user_model = user_bll.GetModel(model.I_ReportUserID);
            this.I_ReportUserID.Value        = user_model.UserID + "";
            this.I_ReportUserID_TextBox.Text = user_model.U_CName;
        }
Example #3
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Maticsoft.Model.sys_User GetModel(int UserID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 UserID,U_LoginName,U_Password,U_CName,U_EName,U_GroupID,U_Email,U_Type,U_Status,U_Licence,U_Mac,U_Remark,U_IDCard,U_Sex,U_BirthDay,U_MobileNo,U_UserNO,U_WorkStartDate,U_WorkEndDate,U_CompanyMail,U_Title,U_Extension,U_HomeTel,U_PhotoUrl,U_DateTime,U_LastIP,U_LastDateTime,U_ExtendField,U_LoginType,U_HospitalGroupID from sys_User ");
            strSql.Append(" where UserID=@UserID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@UserID", SqlDbType.Int, 4)
            };
            parameters[0].Value = UserID;

            Maticsoft.Model.sys_User model = new Maticsoft.Model.sys_User();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Example #4
0
        public void btnSave_Click(object sender, EventArgs e)
        {
            string strErr = "";

            if (this.txtU_LoginName.Text.Trim().Length == 0)
            {
                strErr += "登陆名不能为空!\\n";
            }
            if (this.txtU_Password.Text.Trim().Length == 0)
            {
                strErr += "密码md5加密字符不能为空!\\n";
            }
            if (this.txtU_CName.Text.Trim().Length == 0)
            {
                strErr += "中文姓名不能为空!\\n";
            }
            if (this.txtU_EName.Text.Trim().Length == 0)
            {
                strErr += "英文名不能为空!\\n";
            }
            if (!PageValidate.IsNumber(txtU_GroupID.Text))
            {
                strErr += "部门ID号与sys_Group表中GroupID关联格式错误!\\n";
            }
            if (this.txtU_Email.Text.Trim().Length == 0)
            {
                strErr += "电子邮件不能为空!\\n";
            }
            if (!PageValidate.IsNumber(txtU_Type.Text))
            {
                strErr += "用户类型0:超级用户1:普通用格式错误!\\n";
            }
            if (!PageValidate.IsNumber(txtU_Status.Text))
            {
                strErr += "当前状态0:正常 1:禁止登陆格式错误!\\n";
            }
            if (this.txtU_Licence.Text.Trim().Length == 0)
            {
                strErr += "用户序列号不能为空!\\n";
            }
            if (this.txtU_Mac.Text.Trim().Length == 0)
            {
                strErr += "锁定机器硬件地址不能为空!\\n";
            }
            if (this.txtU_Remark.Text.Trim().Length == 0)
            {
                strErr += "备注说明不能为空!\\n";
            }
            if (this.txtU_IDCard.Text.Trim().Length == 0)
            {
                strErr += "身份证号码不能为空!\\n";
            }
            if (!PageValidate.IsNumber(txtU_Sex.Text))
            {
                strErr += "性别1:男0:女格式错误!\\n";
            }
            if (!PageValidate.IsDateTime(txtU_BirthDay.Text))
            {
                strErr += "出生日期格式错误!\\n";
            }
            if (this.txtU_MobileNo.Text.Trim().Length == 0)
            {
                strErr += "手机号不能为空!\\n";
            }
            if (this.txtU_UserNO.Text.Trim().Length == 0)
            {
                strErr += "员工编号不能为空!\\n";
            }
            if (!PageValidate.IsDateTime(txtU_WorkStartDate.Text))
            {
                strErr += "到职日期格式错误!\\n";
            }
            if (!PageValidate.IsDateTime(txtU_WorkEndDate.Text))
            {
                strErr += "离职日期格式错误!\\n";
            }
            if (this.txtU_CompanyMail.Text.Trim().Length == 0)
            {
                strErr += "公司邮件地址不能为空!\\n";
            }
            if (!PageValidate.IsNumber(txtU_Title.Text))
            {
                strErr += "职称与应用字段关联格式错误!\\n";
            }
            if (this.txtU_Extension.Text.Trim().Length == 0)
            {
                strErr += "分机号不能为空!\\n";
            }
            if (this.txtU_HomeTel.Text.Trim().Length == 0)
            {
                strErr += "家中电话不能为空!\\n";
            }
            if (this.txtU_PhotoUrl.Text.Trim().Length == 0)
            {
                strErr += "用户照片网址不能为空!\\n";
            }
            if (!PageValidate.IsDateTime(txtU_DateTime.Text))
            {
                strErr += "操作时间格式错误!\\n";
            }
            if (this.txtU_LastIP.Text.Trim().Length == 0)
            {
                strErr += "最后访问IP不能为空!\\n";
            }
            if (!PageValidate.IsDateTime(txtU_LastDateTime.Text))
            {
                strErr += "最后访问时间格式错误!\\n";
            }
            if (this.txtU_ExtendField.Text.Trim().Length == 0)
            {
                strErr += "扩展字段不能为空!\\n";
            }
            if (this.txtU_LoginType.Text.Trim().Length == 0)
            {
                strErr += "登入类型(为空系统认证,其它值不能为空!\\n";
            }
            if (!PageValidate.IsNumber(txtU_HospitalGroupID.Text))
            {
                strErr += "医院部门ID号与sys_Group表中GroupID关联格式错误!\\n";
            }

            if (strErr != "")
            {
                MessageBox.Show(this, strErr);
                return;
            }
            int      UserID            = int.Parse(this.lblUserID.Text);
            string   U_LoginName       = this.txtU_LoginName.Text;
            string   U_Password        = this.txtU_Password.Text;
            string   U_CName           = this.txtU_CName.Text;
            string   U_EName           = this.txtU_EName.Text;
            int      U_GroupID         = int.Parse(this.txtU_GroupID.Text);
            string   U_Email           = this.txtU_Email.Text;
            int      U_Type            = int.Parse(this.txtU_Type.Text);
            int      U_Status          = int.Parse(this.txtU_Status.Text);
            string   U_Licence         = this.txtU_Licence.Text;
            string   U_Mac             = this.txtU_Mac.Text;
            string   U_Remark          = this.txtU_Remark.Text;
            string   U_IDCard          = this.txtU_IDCard.Text;
            int      U_Sex             = int.Parse(this.txtU_Sex.Text);
            DateTime U_BirthDay        = DateTime.Parse(this.txtU_BirthDay.Text);
            string   U_MobileNo        = this.txtU_MobileNo.Text;
            string   U_UserNO          = this.txtU_UserNO.Text;
            DateTime U_WorkStartDate   = DateTime.Parse(this.txtU_WorkStartDate.Text);
            DateTime U_WorkEndDate     = DateTime.Parse(this.txtU_WorkEndDate.Text);
            string   U_CompanyMail     = this.txtU_CompanyMail.Text;
            int      U_Title           = int.Parse(this.txtU_Title.Text);
            string   U_Extension       = this.txtU_Extension.Text;
            string   U_HomeTel         = this.txtU_HomeTel.Text;
            string   U_PhotoUrl        = this.txtU_PhotoUrl.Text;
            DateTime U_DateTime        = DateTime.Parse(this.txtU_DateTime.Text);
            string   U_LastIP          = this.txtU_LastIP.Text;
            DateTime U_LastDateTime    = DateTime.Parse(this.txtU_LastDateTime.Text);
            string   U_ExtendField     = this.txtU_ExtendField.Text;
            string   U_LoginType       = this.txtU_LoginType.Text;
            int      U_HospitalGroupID = int.Parse(this.txtU_HospitalGroupID.Text);


            Maticsoft.Model.sys_User model = new Maticsoft.Model.sys_User();
            model.UserID            = UserID;
            model.U_LoginName       = U_LoginName;
            model.U_Password        = U_Password;
            model.U_CName           = U_CName;
            model.U_EName           = U_EName;
            model.U_GroupID         = U_GroupID;
            model.U_Email           = U_Email;
            model.U_Type            = U_Type;
            model.U_Status          = U_Status;
            model.U_Licence         = U_Licence;
            model.U_Mac             = U_Mac;
            model.U_Remark          = U_Remark;
            model.U_IDCard          = U_IDCard;
            model.U_Sex             = U_Sex;
            model.U_BirthDay        = U_BirthDay;
            model.U_MobileNo        = U_MobileNo;
            model.U_UserNO          = U_UserNO;
            model.U_WorkStartDate   = U_WorkStartDate;
            model.U_WorkEndDate     = U_WorkEndDate;
            model.U_CompanyMail     = U_CompanyMail;
            model.U_Title           = U_Title;
            model.U_Extension       = U_Extension;
            model.U_HomeTel         = U_HomeTel;
            model.U_PhotoUrl        = U_PhotoUrl;
            model.U_DateTime        = U_DateTime;
            model.U_LastIP          = U_LastIP;
            model.U_LastDateTime    = U_LastDateTime;
            model.U_ExtendField     = U_ExtendField;
            model.U_LoginType       = U_LoginType;
            model.U_HospitalGroupID = U_HospitalGroupID;

            Maticsoft.BLL.sys_User bll = new Maticsoft.BLL.sys_User();
            bll.Update(model);
            Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx");
        }
Example #5
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Maticsoft.Model.sys_User GetModel(int UserID)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select  top 1 UserID,U_LoginName,U_Password,U_CName,U_EName,U_GroupID,U_Email,U_Type,U_Status,U_Licence,U_Mac,U_Remark,U_IDCard,U_Sex,U_BirthDay,U_MobileNo,U_UserNO,U_WorkStartDate,U_WorkEndDate,U_CompanyMail,U_Title,U_Extension,U_HomeTel,U_PhotoUrl,U_DateTime,U_LastIP,U_LastDateTime,U_ExtendField,U_LoginType,U_HospitalGroupID,U_AccessToken from sys_User ");
            strSql.Append(" where UserID=@UserID");
            SqlParameter[] parameters = {
                    new SqlParameter("@UserID", SqlDbType.Int,4)
            };
            parameters[0].Value = UserID;

            Maticsoft.Model.sys_User model=new Maticsoft.Model.sys_User();
            DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
            if(ds.Tables[0].Rows.Count>0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }
Example #6
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Maticsoft.Model.sys_User DataRowToModel(DataRow row)
 {
     Maticsoft.Model.sys_User model=new Maticsoft.Model.sys_User();
     if (row != null)
     {
         if(row["UserID"]!=null && row["UserID"].ToString()!="")
         {
             model.UserID=int.Parse(row["UserID"].ToString());
         }
         if(row["U_LoginName"]!=null)
         {
             model.U_LoginName=row["U_LoginName"].ToString();
         }
         if(row["U_Password"]!=null)
         {
             model.U_Password=row["U_Password"].ToString();
         }
         if(row["U_CName"]!=null)
         {
             model.U_CName=row["U_CName"].ToString();
         }
         if(row["U_EName"]!=null)
         {
             model.U_EName=row["U_EName"].ToString();
         }
         if(row["U_GroupID"]!=null && row["U_GroupID"].ToString()!="")
         {
             model.U_GroupID=int.Parse(row["U_GroupID"].ToString());
         }
         if(row["U_Email"]!=null)
         {
             model.U_Email=row["U_Email"].ToString();
         }
         if(row["U_Type"]!=null && row["U_Type"].ToString()!="")
         {
             model.U_Type=int.Parse(row["U_Type"].ToString());
         }
         if(row["U_Status"]!=null && row["U_Status"].ToString()!="")
         {
             model.U_Status=int.Parse(row["U_Status"].ToString());
         }
         if(row["U_Licence"]!=null)
         {
             model.U_Licence=row["U_Licence"].ToString();
         }
         if(row["U_Mac"]!=null)
         {
             model.U_Mac=row["U_Mac"].ToString();
         }
         if(row["U_Remark"]!=null)
         {
             model.U_Remark=row["U_Remark"].ToString();
         }
         if(row["U_IDCard"]!=null)
         {
             model.U_IDCard=row["U_IDCard"].ToString();
         }
         if(row["U_Sex"]!=null && row["U_Sex"].ToString()!="")
         {
             model.U_Sex=int.Parse(row["U_Sex"].ToString());
         }
         if(row["U_BirthDay"]!=null && row["U_BirthDay"].ToString()!="")
         {
             model.U_BirthDay=DateTime.Parse(row["U_BirthDay"].ToString());
         }
         if(row["U_MobileNo"]!=null)
         {
             model.U_MobileNo=row["U_MobileNo"].ToString();
         }
         if(row["U_UserNO"]!=null)
         {
             model.U_UserNO=row["U_UserNO"].ToString();
         }
         if(row["U_WorkStartDate"]!=null && row["U_WorkStartDate"].ToString()!="")
         {
             model.U_WorkStartDate=DateTime.Parse(row["U_WorkStartDate"].ToString());
         }
         if(row["U_WorkEndDate"]!=null && row["U_WorkEndDate"].ToString()!="")
         {
             model.U_WorkEndDate=DateTime.Parse(row["U_WorkEndDate"].ToString());
         }
         if(row["U_CompanyMail"]!=null)
         {
             model.U_CompanyMail=row["U_CompanyMail"].ToString();
         }
         if(row["U_Title"]!=null && row["U_Title"].ToString()!="")
         {
             model.U_Title=int.Parse(row["U_Title"].ToString());
         }
         if(row["U_Extension"]!=null)
         {
             model.U_Extension=row["U_Extension"].ToString();
         }
         if(row["U_HomeTel"]!=null)
         {
             model.U_HomeTel=row["U_HomeTel"].ToString();
         }
         if(row["U_PhotoUrl"]!=null)
         {
             model.U_PhotoUrl=row["U_PhotoUrl"].ToString();
         }
         if(row["U_DateTime"]!=null && row["U_DateTime"].ToString()!="")
         {
             model.U_DateTime=DateTime.Parse(row["U_DateTime"].ToString());
         }
         if(row["U_LastIP"]!=null)
         {
             model.U_LastIP=row["U_LastIP"].ToString();
         }
         if(row["U_LastDateTime"]!=null && row["U_LastDateTime"].ToString()!="")
         {
             model.U_LastDateTime=DateTime.Parse(row["U_LastDateTime"].ToString());
         }
         if(row["U_ExtendField"]!=null)
         {
             model.U_ExtendField=row["U_ExtendField"].ToString();
         }
         if(row["U_LoginType"]!=null)
         {
             model.U_LoginType=row["U_LoginType"].ToString();
         }
         if(row["U_HospitalGroupID"]!=null && row["U_HospitalGroupID"].ToString()!="")
         {
             model.U_HospitalGroupID=int.Parse(row["U_HospitalGroupID"].ToString());
         }
         if(row["U_AccessToken"]!=null)
         {
             model.U_AccessToken=row["U_AccessToken"].ToString();
         }
     }
     return model;
 }
Example #7
0
        /// <summary>
        /// 点击确定按钮执行的方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Button1_Click(object sender, EventArgs e)
        {
            Maticsoft.BLL.sys_User sysUser_bll = new Maticsoft.BLL.sys_User();
            Maticsoft.Model.sys_User sysUser_model = sysUser_bll.GetModel(UserID);

            Maticsoft.BLL.record_UserBaseInfo record_UserBaseInfo_bll = new Maticsoft.BLL.record_UserBaseInfo();
            Maticsoft.Model.record_UserBaseInfo record_UserBaseInfo_model = record_UserBaseInfo_bll.GetModel(UserID);
            if (sysUser_model == null)
            {
                sysUser_model = new Maticsoft.Model.sys_User();
            }
            if (record_UserBaseInfo_model == null)
            {
                record_UserBaseInfo_model = new Maticsoft.Model.record_UserBaseInfo();
            }

            sysUser_model.U_IDCard = (string)Common.sink(this.U_IDCard.UniqueID, MethodType.Post, 0, 0, DataType.Str);
            sysUser_model.U_CName = (string)Common.sink(this.U_CName.UniqueID, MethodType.Post, 0, 0, DataType.Str);
            record_UserBaseInfo_model.U_Hometown = (string)Common.sink(this.U_Hometown.UniqueID, MethodType.Post, 0, 0, DataType.Str);
            record_UserBaseInfo_model.U_CurrentAddress = (string)Common.sink(this.U_CurrentAddress.UniqueID, MethodType.Post, 0, 0, DataType.Str);
            sysUser_model.U_Sex = Convert.ToInt32(this.U_Sex.SelectedValue);
            record_UserBaseInfo_model.U_NationID = Convert.ToInt32(this.U_NationID.SelectedValue);
            record_UserBaseInfo_model.U_MarriageStatus = Convert.ToInt32(this.U_MarriageStatus.SelectedValue);
            record_UserBaseInfo_model.U_BloodType = Convert.ToInt32(this.U_BloodType.SelectedValue);
            sysUser_model.U_MobileNo = (string)Common.sink(this.U_MobileNo.UniqueID, MethodType.Post, 0, 0, DataType.Str);
            record_UserBaseInfo_model.U_Committee = Convert.ToInt32(Common.sink(this.U_Committee.UniqueID, MethodType.Post, 0, 0, DataType.Str));
            record_UserBaseInfo_model.U_PermanentType = Convert.ToInt32(this.U_PermanentType.SelectedValue);
            record_UserBaseInfo_model.U_Education = Convert.ToInt32(this.U_Education.SelectedValue);
            record_UserBaseInfo_model.U_WorkingUnits = (string)Common.sink(this.U_WorkingUnits.UniqueID, MethodType.Post, 0, 0, DataType.Str);
            record_UserBaseInfo_model.U_WorkingContactName = (string)Common.sink(this.U_WorkingContactName.UniqueID, MethodType.Post, 0, 0, DataType.Str);
            record_UserBaseInfo_model.U_WorkingContactTel = (string)Common.sink(this.U_WorkingContactTel.UniqueID, MethodType.Post, 0, 0, DataType.Str);
            record_UserBaseInfo_model.U_PaymentType = this.U_PaymentType.SelectedValue;  //这里要改为多选
            record_UserBaseInfo_model.U_SocialNO = (string)Common.sink(this.U_SocialNO.UniqueID, MethodType.Post, 0, 0, DataType.Str);
            record_UserBaseInfo_model.U_MedicalNO = (string)Common.sink(this.U_MedicalNO.UniqueID, MethodType.Post, 0, 0, DataType.Str);
            record_UserBaseInfo_model.U_FamilyCode = (string)Common.sink(this.U_FamilyCode.UniqueID, MethodType.Post, 0, 0, DataType.Str);
            record_UserBaseInfo_model.U_RelationShip = Convert.ToInt32(this.U_RelationShip.SelectedValue);
            record_UserBaseInfo_model.U_ResponsibilityUserID = Convert.ToInt32(Common.sink(this.U_ResponsibilityUserID.UniqueID, MethodType.Post, 0, 0, DataType.Str));
            record_UserBaseInfo_model.U_AuditStatus = Convert.ToInt32(this.U_AuditStatus.SelectedValue);
            record_UserBaseInfo_model.U_FilingUnits = Convert.ToInt32(Common.sink(this.U_FilingUnits.UniqueID, MethodType.Post, 0, 0, DataType.Str));
            record_UserBaseInfo_model.U_FilingUserID = Convert.ToInt32(Common.sink(this.U_FilingUserID.UniqueID, MethodType.Post, 0, 0, DataType.Str));

            switch (CMD)
            {
                case "New":
                    CMD_Txt = "增加";
                    //如果是增加操作,就调用Add方法
                    if (!sysUser_bll.isExist(sysUser_model))
                    {
                        sysUser_model.U_Password = Common.md5(sysUser_model.U_IDCard, 32);  //初始密码为身份证号
                        string year = sysUser_model.U_IDCard.Substring(6, 4);
                        string month = sysUser_model.U_IDCard.Substring(10, 2);
                        string date = sysUser_model.U_IDCard.Substring(12, 2);
                        string result = year + "-" + month + "-" + date;
                        sysUser_model.U_LoginName = sysUser_model.U_IDCard;
                        sysUser_model.U_BirthDay = Convert.ToDateTime(result);
                        sysUser_model.U_DateTime = sysUser_model.U_LastDateTime = sysUser_model.U_WorkStartDate = sysUser_model.U_WorkEndDate = DateTime.Now;
                        sysUser_model.U_LastIP = Common.GetIPAddress();
                        sysUser_model.U_Type = 1;
                        sysUser_model.U_Status = 0;
                        record_UserBaseInfo_model.UserID = sysUser_bll.Add(sysUser_model);
                        record_UserBaseInfo_model.U_FlingTime = DateTime.Now;
                        record_UserBaseInfo_bll.Add(record_UserBaseInfo_model);
                        Maticsoft.BLL.sys_UserRoles sys_UserRoles_bll = new Maticsoft.BLL.sys_UserRoles();
                        Maticsoft.Model.sys_UserRoles sys_UserRoles_model = new Maticsoft.Model.sys_UserRoles();
                        sys_UserRoles_model.R_UserID = record_UserBaseInfo_model.UserID;
                        sys_UserRoles_model.R_RoleID = 1; //初始为普通用户
                    }
                    else
                    {
                        EventMessage.MessageBox(1, "操作失败", string.Format("个人健康档案号{0}已存在!", sysUser_model.U_IDCard), Icon_Type.Alert, Common.GetHomeBaseUrl("InfoManager.aspx?CMD=New"));
                    }
                    break;
                case "Edit":
                    CMD_Txt = "修改";
                    sysUser_bll.Update(sysUser_model);
                    record_UserBaseInfo_bll.Update(record_UserBaseInfo_model);
                    break;
            }
            All_Title_Txt = CMD_Txt + App_Txt;
                EventMessage.MessageBox(1, "操作成功", string.Format("{1}ID({0})成功!", UserID, All_Title_Txt), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx"));
        }
Example #8
0
 /// <summary>
 /// 通过用户id得到用户信息
 /// </summary>
 /// <param name="userID"></param>
 /// <returns></returns>
 public Maticsoft.Model.sys_User getUserNameById(int userID)
 {
     Maticsoft.BLL.sys_User   bll   = new Maticsoft.BLL.sys_User();
     Maticsoft.Model.sys_User model = bll.GetModel(userID);
     return(model);
 }
Example #9
0
        public void btnSave_Click(object sender, EventArgs e)
        {
            string strErr="";
            if(this.txtU_LoginName.Text.Trim().Length==0)
            {
                strErr+="登陆名不能为空!\\n";
            }
            if(this.txtU_Password.Text.Trim().Length==0)
            {
                strErr+="密码md5加密字符不能为空!\\n";
            }
            if(this.txtU_CName.Text.Trim().Length==0)
            {
                strErr+="中文姓名不能为空!\\n";
            }
            if(this.txtU_EName.Text.Trim().Length==0)
            {
                strErr+="英文名不能为空!\\n";
            }
            if(!PageValidate.IsNumber(txtU_GroupID.Text))
            {
                strErr+="部门ID号与sys_Group表中GroupID关联格式错误!\\n";
            }
            if(this.txtU_Email.Text.Trim().Length==0)
            {
                strErr+="电子邮件不能为空!\\n";
            }
            if(!PageValidate.IsNumber(txtU_Type.Text))
            {
                strErr+="用户类型0:超级用户1:普通用格式错误!\\n";
            }
            if(!PageValidate.IsNumber(txtU_Status.Text))
            {
                strErr+="当前状态0:正常 1:禁止登陆格式错误!\\n";
            }
            if(this.txtU_Licence.Text.Trim().Length==0)
            {
                strErr+="用户序列号不能为空!\\n";
            }
            if(this.txtU_Mac.Text.Trim().Length==0)
            {
                strErr+="锁定机器硬件地址不能为空!\\n";
            }
            if(this.txtU_Remark.Text.Trim().Length==0)
            {
                strErr+="备注说明不能为空!\\n";
            }
            if(this.txtU_IDCard.Text.Trim().Length==0)
            {
                strErr+="身份证号码不能为空!\\n";
            }
            if(!PageValidate.IsNumber(txtU_Sex.Text))
            {
                strErr+="性别1:男0:女格式错误!\\n";
            }
            if(!PageValidate.IsDateTime(txtU_BirthDay.Text))
            {
                strErr+="出生日期格式错误!\\n";
            }
            if(this.txtU_MobileNo.Text.Trim().Length==0)
            {
                strErr+="手机号不能为空!\\n";
            }
            if(this.txtU_UserNO.Text.Trim().Length==0)
            {
                strErr+="员工编号不能为空!\\n";
            }
            if(!PageValidate.IsDateTime(txtU_WorkStartDate.Text))
            {
                strErr+="到职日期格式错误!\\n";
            }
            if(!PageValidate.IsDateTime(txtU_WorkEndDate.Text))
            {
                strErr+="离职日期格式错误!\\n";
            }
            if(this.txtU_CompanyMail.Text.Trim().Length==0)
            {
                strErr+="公司邮件地址不能为空!\\n";
            }
            if(!PageValidate.IsNumber(txtU_Title.Text))
            {
                strErr+="职称与应用字段关联格式错误!\\n";
            }
            if(this.txtU_Extension.Text.Trim().Length==0)
            {
                strErr+="分机号不能为空!\\n";
            }
            if(this.txtU_HomeTel.Text.Trim().Length==0)
            {
                strErr+="家中电话不能为空!\\n";
            }
            if(this.txtU_PhotoUrl.Text.Trim().Length==0)
            {
                strErr+="用户照片网址不能为空!\\n";
            }
            if(!PageValidate.IsDateTime(txtU_DateTime.Text))
            {
                strErr+="操作时间格式错误!\\n";
            }
            if(this.txtU_LastIP.Text.Trim().Length==0)
            {
                strErr+="最后访问IP不能为空!\\n";
            }
            if(!PageValidate.IsDateTime(txtU_LastDateTime.Text))
            {
                strErr+="最后访问时间格式错误!\\n";
            }
            if(this.txtU_ExtendField.Text.Trim().Length==0)
            {
                strErr+="扩展字段不能为空!\\n";
            }
            if(this.txtU_LoginType.Text.Trim().Length==0)
            {
                strErr+="登入类型(为空系统认证,其它值不能为空!\\n";
            }
            if(!PageValidate.IsNumber(txtU_HospitalGroupID.Text))
            {
                strErr+="医院部门ID号与sys_Group表中GroupID关联格式错误!\\n";
            }

            if(strErr!="")
            {
                MessageBox.Show(this,strErr);
                return;
            }
            int UserID=int.Parse(this.lblUserID.Text);
            string U_LoginName=this.txtU_LoginName.Text;
            string U_Password=this.txtU_Password.Text;
            string U_CName=this.txtU_CName.Text;
            string U_EName=this.txtU_EName.Text;
            int U_GroupID=int.Parse(this.txtU_GroupID.Text);
            string U_Email=this.txtU_Email.Text;
            int U_Type=int.Parse(this.txtU_Type.Text);
            int U_Status=int.Parse(this.txtU_Status.Text);
            string U_Licence=this.txtU_Licence.Text;
            string U_Mac=this.txtU_Mac.Text;
            string U_Remark=this.txtU_Remark.Text;
            string U_IDCard=this.txtU_IDCard.Text;
            int U_Sex=int.Parse(this.txtU_Sex.Text);
            DateTime U_BirthDay=DateTime.Parse(this.txtU_BirthDay.Text);
            string U_MobileNo=this.txtU_MobileNo.Text;
            string U_UserNO=this.txtU_UserNO.Text;
            DateTime U_WorkStartDate=DateTime.Parse(this.txtU_WorkStartDate.Text);
            DateTime U_WorkEndDate=DateTime.Parse(this.txtU_WorkEndDate.Text);
            string U_CompanyMail=this.txtU_CompanyMail.Text;
            int U_Title=int.Parse(this.txtU_Title.Text);
            string U_Extension=this.txtU_Extension.Text;
            string U_HomeTel=this.txtU_HomeTel.Text;
            string U_PhotoUrl=this.txtU_PhotoUrl.Text;
            DateTime U_DateTime=DateTime.Parse(this.txtU_DateTime.Text);
            string U_LastIP=this.txtU_LastIP.Text;
            DateTime U_LastDateTime=DateTime.Parse(this.txtU_LastDateTime.Text);
            string U_ExtendField=this.txtU_ExtendField.Text;
            string U_LoginType=this.txtU_LoginType.Text;
            int U_HospitalGroupID=int.Parse(this.txtU_HospitalGroupID.Text);

            Maticsoft.Model.sys_User model=new Maticsoft.Model.sys_User();
            model.UserID=UserID;
            model.U_LoginName=U_LoginName;
            model.U_Password=U_Password;
            model.U_CName=U_CName;
            model.U_EName=U_EName;
            model.U_GroupID=U_GroupID;
            model.U_Email=U_Email;
            model.U_Type=U_Type;
            model.U_Status=U_Status;
            model.U_Licence=U_Licence;
            model.U_Mac=U_Mac;
            model.U_Remark=U_Remark;
            model.U_IDCard=U_IDCard;
            model.U_Sex=U_Sex;
            model.U_BirthDay=U_BirthDay;
            model.U_MobileNo=U_MobileNo;
            model.U_UserNO=U_UserNO;
            model.U_WorkStartDate=U_WorkStartDate;
            model.U_WorkEndDate=U_WorkEndDate;
            model.U_CompanyMail=U_CompanyMail;
            model.U_Title=U_Title;
            model.U_Extension=U_Extension;
            model.U_HomeTel=U_HomeTel;
            model.U_PhotoUrl=U_PhotoUrl;
            model.U_DateTime=U_DateTime;
            model.U_LastIP=U_LastIP;
            model.U_LastDateTime=U_LastDateTime;
            model.U_ExtendField=U_ExtendField;
            model.U_LoginType=U_LoginType;
            model.U_HospitalGroupID=U_HospitalGroupID;

            Maticsoft.BLL.sys_User bll=new Maticsoft.BLL.sys_User();
            bll.Update(model);
            Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","list.aspx");
        }
Example #10
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.sys_User model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into sys_User(");
            strSql.Append("U_LoginName,U_Password,U_CName,U_EName,U_GroupID,U_Email,U_Type,U_Status,U_Licence,U_Mac,U_Remark,U_IDCard,U_Sex,U_BirthDay,U_MobileNo,U_UserNO,U_WorkStartDate,U_WorkEndDate,U_CompanyMail,U_Title,U_Extension,U_HomeTel,U_PhotoUrl,U_DateTime,U_LastIP,U_LastDateTime,U_ExtendField,U_LoginType,U_HospitalGroupID)");
            strSql.Append(" values (");
            strSql.Append("@U_LoginName,@U_Password,@U_CName,@U_EName,@U_GroupID,@U_Email,@U_Type,@U_Status,@U_Licence,@U_Mac,@U_Remark,@U_IDCard,@U_Sex,@U_BirthDay,@U_MobileNo,@U_UserNO,@U_WorkStartDate,@U_WorkEndDate,@U_CompanyMail,@U_Title,@U_Extension,@U_HomeTel,@U_PhotoUrl,@U_DateTime,@U_LastIP,@U_LastDateTime,@U_ExtendField,@U_LoginType,@U_HospitalGroupID)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@U_LoginName",       SqlDbType.NVarChar,   20),
                new SqlParameter("@U_Password",        SqlDbType.VarChar,    32),
                new SqlParameter("@U_CName",           SqlDbType.NVarChar,   20),
                new SqlParameter("@U_EName",           SqlDbType.VarChar,    50),
                new SqlParameter("@U_GroupID",         SqlDbType.Int,         4),
                new SqlParameter("@U_Email",           SqlDbType.VarChar,   100),
                new SqlParameter("@U_Type",            SqlDbType.TinyInt,     1),
                new SqlParameter("@U_Status",          SqlDbType.TinyInt,     1),
                new SqlParameter("@U_Licence",         SqlDbType.VarChar,    30),
                new SqlParameter("@U_Mac",             SqlDbType.VarChar,    50),
                new SqlParameter("@U_Remark",          SqlDbType.NVarChar,  200),
                new SqlParameter("@U_IDCard",          SqlDbType.VarChar,    30),
                new SqlParameter("@U_Sex",             SqlDbType.TinyInt,     1),
                new SqlParameter("@U_BirthDay",        SqlDbType.DateTime),
                new SqlParameter("@U_MobileNo",        SqlDbType.VarChar,    15),
                new SqlParameter("@U_UserNO",          SqlDbType.VarChar,    20),
                new SqlParameter("@U_WorkStartDate",   SqlDbType.DateTime),
                new SqlParameter("@U_WorkEndDate",     SqlDbType.DateTime),
                new SqlParameter("@U_CompanyMail",     SqlDbType.VarChar,   255),
                new SqlParameter("@U_Title",           SqlDbType.Int,         4),
                new SqlParameter("@U_Extension",       SqlDbType.VarChar,    10),
                new SqlParameter("@U_HomeTel",         SqlDbType.VarChar,    20),
                new SqlParameter("@U_PhotoUrl",        SqlDbType.NVarChar,  255),
                new SqlParameter("@U_DateTime",        SqlDbType.DateTime),
                new SqlParameter("@U_LastIP",          SqlDbType.VarChar,    15),
                new SqlParameter("@U_LastDateTime",    SqlDbType.DateTime),
                new SqlParameter("@U_ExtendField",     SqlDbType.NText),
                new SqlParameter("@U_LoginType",       SqlDbType.VarChar,   255),
                new SqlParameter("@U_HospitalGroupID", SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.U_LoginName;
            parameters[1].Value  = model.U_Password;
            parameters[2].Value  = model.U_CName;
            parameters[3].Value  = model.U_EName;
            parameters[4].Value  = model.U_GroupID;
            parameters[5].Value  = model.U_Email;
            parameters[6].Value  = model.U_Type;
            parameters[7].Value  = model.U_Status;
            parameters[8].Value  = model.U_Licence;
            parameters[9].Value  = model.U_Mac;
            parameters[10].Value = model.U_Remark;
            parameters[11].Value = model.U_IDCard;
            parameters[12].Value = model.U_Sex;
            parameters[13].Value = model.U_BirthDay;
            parameters[14].Value = model.U_MobileNo;
            parameters[15].Value = model.U_UserNO;
            parameters[16].Value = model.U_WorkStartDate;
            parameters[17].Value = model.U_WorkEndDate;
            parameters[18].Value = model.U_CompanyMail;
            parameters[19].Value = model.U_Title;
            parameters[20].Value = model.U_Extension;
            parameters[21].Value = model.U_HomeTel;
            parameters[22].Value = model.U_PhotoUrl;
            parameters[23].Value = model.U_DateTime;
            parameters[24].Value = model.U_LastIP;
            parameters[25].Value = model.U_LastDateTime;
            parameters[26].Value = model.U_ExtendField;
            parameters[27].Value = model.U_LoginType;
            parameters[28].Value = model.U_HospitalGroupID;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Example #11
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Maticsoft.Model.sys_User DataRowToModel(DataRow row)
 {
     Maticsoft.Model.sys_User model = new Maticsoft.Model.sys_User();
     if (row != null)
     {
         if (row["UserID"] != null && row["UserID"].ToString() != "")
         {
             model.UserID = int.Parse(row["UserID"].ToString());
         }
         if (row["U_LoginName"] != null)
         {
             model.U_LoginName = row["U_LoginName"].ToString();
         }
         if (row["U_Password"] != null)
         {
             model.U_Password = row["U_Password"].ToString();
         }
         if (row["U_CName"] != null)
         {
             model.U_CName = row["U_CName"].ToString();
         }
         if (row["U_EName"] != null)
         {
             model.U_EName = row["U_EName"].ToString();
         }
         if (row["U_GroupID"] != null && row["U_GroupID"].ToString() != "")
         {
             model.U_GroupID = int.Parse(row["U_GroupID"].ToString());
         }
         if (row["U_Email"] != null)
         {
             model.U_Email = row["U_Email"].ToString();
         }
         if (row["U_Type"] != null && row["U_Type"].ToString() != "")
         {
             model.U_Type = int.Parse(row["U_Type"].ToString());
         }
         if (row["U_Status"] != null && row["U_Status"].ToString() != "")
         {
             model.U_Status = int.Parse(row["U_Status"].ToString());
         }
         if (row["U_Licence"] != null)
         {
             model.U_Licence = row["U_Licence"].ToString();
         }
         if (row["U_Mac"] != null)
         {
             model.U_Mac = row["U_Mac"].ToString();
         }
         if (row["U_Remark"] != null)
         {
             model.U_Remark = row["U_Remark"].ToString();
         }
         if (row["U_IDCard"] != null)
         {
             model.U_IDCard = row["U_IDCard"].ToString();
         }
         if (row["U_Sex"] != null && row["U_Sex"].ToString() != "")
         {
             model.U_Sex = int.Parse(row["U_Sex"].ToString());
         }
         if (row["U_BirthDay"] != null && row["U_BirthDay"].ToString() != "")
         {
             model.U_BirthDay = DateTime.Parse(row["U_BirthDay"].ToString());
         }
         if (row["U_MobileNo"] != null)
         {
             model.U_MobileNo = row["U_MobileNo"].ToString();
         }
         if (row["U_UserNO"] != null)
         {
             model.U_UserNO = row["U_UserNO"].ToString();
         }
         if (row["U_WorkStartDate"] != null && row["U_WorkStartDate"].ToString() != "")
         {
             model.U_WorkStartDate = DateTime.Parse(row["U_WorkStartDate"].ToString());
         }
         if (row["U_WorkEndDate"] != null && row["U_WorkEndDate"].ToString() != "")
         {
             model.U_WorkEndDate = DateTime.Parse(row["U_WorkEndDate"].ToString());
         }
         if (row["U_CompanyMail"] != null)
         {
             model.U_CompanyMail = row["U_CompanyMail"].ToString();
         }
         if (row["U_Title"] != null && row["U_Title"].ToString() != "")
         {
             model.U_Title = int.Parse(row["U_Title"].ToString());
         }
         if (row["U_Extension"] != null)
         {
             model.U_Extension = row["U_Extension"].ToString();
         }
         if (row["U_HomeTel"] != null)
         {
             model.U_HomeTel = row["U_HomeTel"].ToString();
         }
         if (row["U_PhotoUrl"] != null)
         {
             model.U_PhotoUrl = row["U_PhotoUrl"].ToString();
         }
         if (row["U_DateTime"] != null && row["U_DateTime"].ToString() != "")
         {
             model.U_DateTime = DateTime.Parse(row["U_DateTime"].ToString());
         }
         if (row["U_LastIP"] != null)
         {
             model.U_LastIP = row["U_LastIP"].ToString();
         }
         if (row["U_LastDateTime"] != null && row["U_LastDateTime"].ToString() != "")
         {
             model.U_LastDateTime = DateTime.Parse(row["U_LastDateTime"].ToString());
         }
         if (row["U_ExtendField"] != null)
         {
             model.U_ExtendField = row["U_ExtendField"].ToString();
         }
         if (row["U_LoginType"] != null)
         {
             model.U_LoginType = row["U_LoginType"].ToString();
         }
         if (row["U_HospitalGroupID"] != null && row["U_HospitalGroupID"].ToString() != "")
         {
             model.U_HospitalGroupID = int.Parse(row["U_HospitalGroupID"].ToString());
         }
     }
     return(model);
 }
Example #12
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Maticsoft.Model.sys_User model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update sys_User set ");
            strSql.Append("U_LoginName=@U_LoginName,");
            strSql.Append("U_Password=@U_Password,");
            strSql.Append("U_CName=@U_CName,");
            strSql.Append("U_EName=@U_EName,");
            strSql.Append("U_GroupID=@U_GroupID,");
            strSql.Append("U_Email=@U_Email,");
            strSql.Append("U_Type=@U_Type,");
            strSql.Append("U_Status=@U_Status,");
            strSql.Append("U_Licence=@U_Licence,");
            strSql.Append("U_Mac=@U_Mac,");
            strSql.Append("U_Remark=@U_Remark,");
            strSql.Append("U_IDCard=@U_IDCard,");
            strSql.Append("U_Sex=@U_Sex,");
            strSql.Append("U_BirthDay=@U_BirthDay,");
            strSql.Append("U_MobileNo=@U_MobileNo,");
            strSql.Append("U_UserNO=@U_UserNO,");
            strSql.Append("U_WorkStartDate=@U_WorkStartDate,");
            strSql.Append("U_WorkEndDate=@U_WorkEndDate,");
            strSql.Append("U_CompanyMail=@U_CompanyMail,");
            strSql.Append("U_Title=@U_Title,");
            strSql.Append("U_Extension=@U_Extension,");
            strSql.Append("U_HomeTel=@U_HomeTel,");
            strSql.Append("U_PhotoUrl=@U_PhotoUrl,");
            strSql.Append("U_DateTime=@U_DateTime,");
            strSql.Append("U_LastIP=@U_LastIP,");
            strSql.Append("U_LastDateTime=@U_LastDateTime,");
            strSql.Append("U_ExtendField=@U_ExtendField,");
            strSql.Append("U_LoginType=@U_LoginType,");
            strSql.Append("U_HospitalGroupID=@U_HospitalGroupID");
            strSql.Append(" where UserID=@UserID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@U_LoginName",       SqlDbType.NVarChar,   20),
                new SqlParameter("@U_Password",        SqlDbType.VarChar,    32),
                new SqlParameter("@U_CName",           SqlDbType.NVarChar,   20),
                new SqlParameter("@U_EName",           SqlDbType.VarChar,    50),
                new SqlParameter("@U_GroupID",         SqlDbType.Int,         4),
                new SqlParameter("@U_Email",           SqlDbType.VarChar,   100),
                new SqlParameter("@U_Type",            SqlDbType.TinyInt,     1),
                new SqlParameter("@U_Status",          SqlDbType.TinyInt,     1),
                new SqlParameter("@U_Licence",         SqlDbType.VarChar,    30),
                new SqlParameter("@U_Mac",             SqlDbType.VarChar,    50),
                new SqlParameter("@U_Remark",          SqlDbType.NVarChar,  200),
                new SqlParameter("@U_IDCard",          SqlDbType.VarChar,    30),
                new SqlParameter("@U_Sex",             SqlDbType.TinyInt,     1),
                new SqlParameter("@U_BirthDay",        SqlDbType.DateTime),
                new SqlParameter("@U_MobileNo",        SqlDbType.VarChar,    15),
                new SqlParameter("@U_UserNO",          SqlDbType.VarChar,    20),
                new SqlParameter("@U_WorkStartDate",   SqlDbType.DateTime),
                new SqlParameter("@U_WorkEndDate",     SqlDbType.DateTime),
                new SqlParameter("@U_CompanyMail",     SqlDbType.VarChar,   255),
                new SqlParameter("@U_Title",           SqlDbType.Int,         4),
                new SqlParameter("@U_Extension",       SqlDbType.VarChar,    10),
                new SqlParameter("@U_HomeTel",         SqlDbType.VarChar,    20),
                new SqlParameter("@U_PhotoUrl",        SqlDbType.NVarChar,  255),
                new SqlParameter("@U_DateTime",        SqlDbType.DateTime),
                new SqlParameter("@U_LastIP",          SqlDbType.VarChar,    15),
                new SqlParameter("@U_LastDateTime",    SqlDbType.DateTime),
                new SqlParameter("@U_ExtendField",     SqlDbType.NText),
                new SqlParameter("@U_LoginType",       SqlDbType.VarChar,   255),
                new SqlParameter("@U_HospitalGroupID", SqlDbType.Int,         4),
                new SqlParameter("@UserID",            SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.U_LoginName;
            parameters[1].Value  = model.U_Password;
            parameters[2].Value  = model.U_CName;
            parameters[3].Value  = model.U_EName;
            parameters[4].Value  = model.U_GroupID;
            parameters[5].Value  = model.U_Email;
            parameters[6].Value  = model.U_Type;
            parameters[7].Value  = model.U_Status;
            parameters[8].Value  = model.U_Licence;
            parameters[9].Value  = model.U_Mac;
            parameters[10].Value = model.U_Remark;
            parameters[11].Value = model.U_IDCard;
            parameters[12].Value = model.U_Sex;
            parameters[13].Value = model.U_BirthDay;
            parameters[14].Value = model.U_MobileNo;
            parameters[15].Value = model.U_UserNO;
            parameters[16].Value = model.U_WorkStartDate;
            parameters[17].Value = model.U_WorkEndDate;
            parameters[18].Value = model.U_CompanyMail;
            parameters[19].Value = model.U_Title;
            parameters[20].Value = model.U_Extension;
            parameters[21].Value = model.U_HomeTel;
            parameters[22].Value = model.U_PhotoUrl;
            parameters[23].Value = model.U_DateTime;
            parameters[24].Value = model.U_LastIP;
            parameters[25].Value = model.U_LastDateTime;
            parameters[26].Value = model.U_ExtendField;
            parameters[27].Value = model.U_LoginType;
            parameters[28].Value = model.U_HospitalGroupID;
            parameters[29].Value = model.UserID;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }