/// <summary> /// 初始化窗体 /// </summary> private void InitForm() { ServerUtil.BindDropDLTDept(this.f_DepartIDComboBox); ServerUtil.BindDropDLTRoles(this.f_RoleIDComboBox); if (_id != 0) { this.Text = "用户修改"; label1.Visible = true; label2.Visible = true; f_RegTimeLabel1.Visible = true; f_LastInTimeLabel1.Visible = true; GSSBLL.Users bll = new GSSBLL.Users(); GSSModel.Users model = bll.GetModel(_id); f_UserIDTextBox.Text = model.F_UserID.ToString(); f_UserNameTextBox.Text = model.F_UserName; //f_PassWordTextBox.Text=model.F_PassWord ; textBoxPSWH.Text = model.F_PassWord; f_DepartIDComboBox.SelectedValue = model.F_DepartID; f_RoleIDComboBox.SelectedValue = model.F_RoleID; f_RealNameTextBox.Text = model.F_RealName; SexradioButton1.Checked = model.F_Sex == false ? false : true; SexradioButton2.Checked = !SexradioButton1.Checked; f_BirthdayDateTimePicker.Text = model.F_Birthday.ToString(); f_EmailTextBox.Text = model.F_Email; f_MobilePhoneTextBox.Text = model.F_MobilePhone; f_TelphoneTextBox.Text = model.F_Telphone; f_NoteTextBox.Text = model.F_Note; f_IsUsedCheckBox.Checked = model.F_IsUsed; f_RegTimeLabel1.Text = model.F_RegTime.ToString(); f_LastInTimeLabel1.Text = model.F_LastInTime.ToString(); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(GSSModel.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Users("); strSql.Append("F_UserName,F_PassWord,F_DepartID,F_RoleID,F_RealName,F_Sex,F_Birthday,F_Email,F_MobilePhone,F_Telphone,F_Note,F_RegTime,F_LastInTime,F_IsUsed)"); strSql.Append(" values ("); strSql.Append("@F_UserName,@F_PassWord,@F_DepartID,@F_RoleID,@F_RealName,@F_Sex,@F_Birthday,@F_Email,@F_MobilePhone,@F_Telphone,@F_Note,@F_RegTime,@F_LastInTime,@F_IsUsed)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@F_UserName", SqlDbType.NVarChar, 30), new SqlParameter("@F_PassWord", SqlDbType.Char, 32), new SqlParameter("@F_DepartID", SqlDbType.Int, 4), new SqlParameter("@F_RoleID", SqlDbType.Int, 4), new SqlParameter("@F_RealName", SqlDbType.NVarChar, 10), new SqlParameter("@F_Sex", SqlDbType.Bit, 1), new SqlParameter("@F_Birthday", SqlDbType.SmallDateTime), new SqlParameter("@F_Email", SqlDbType.NVarChar, 50), new SqlParameter("@F_MobilePhone", SqlDbType.NVarChar, 20), new SqlParameter("@F_Telphone", SqlDbType.NVarChar, 20), new SqlParameter("@F_Note", SqlDbType.NVarChar, 500), new SqlParameter("@F_RegTime", SqlDbType.SmallDateTime), new SqlParameter("@F_LastInTime", SqlDbType.SmallDateTime), new SqlParameter("@F_IsUsed", SqlDbType.Bit, 1) }; parameters[0].Value = model.F_UserName; parameters[1].Value = model.F_PassWord; parameters[2].Value = model.F_DepartID; parameters[3].Value = model.F_RoleID; parameters[4].Value = model.F_RealName; parameters[5].Value = model.F_Sex; parameters[6].Value = model.F_Birthday; parameters[7].Value = model.F_Email; parameters[8].Value = model.F_MobilePhone; parameters[9].Value = model.F_Telphone; parameters[10].Value = model.F_Note; parameters[11].Value = model.F_RegTime; parameters[12].Value = model.F_LastInTime; parameters[13].Value = model.F_IsUsed; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(GSSModel.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Users set "); strSql.Append("F_UserName=@F_UserName,"); strSql.Append("F_PassWord=@F_PassWord,"); strSql.Append("F_DepartID=@F_DepartID,"); strSql.Append("F_RoleID=@F_RoleID,"); strSql.Append("F_RealName=@F_RealName,"); strSql.Append("F_Sex=@F_Sex,"); strSql.Append("F_Birthday=@F_Birthday,"); strSql.Append("F_Email=@F_Email,"); strSql.Append("F_MobilePhone=@F_MobilePhone,"); strSql.Append("F_Telphone=@F_Telphone,"); strSql.Append("F_Note=@F_Note,"); strSql.Append("F_RegTime=@F_RegTime,"); strSql.Append("F_LastInTime=@F_LastInTime,"); strSql.Append("F_IsUsed=@F_IsUsed"); strSql.Append(" where F_UserID=@F_UserID"); SqlParameter[] parameters = { new SqlParameter("@F_UserName", SqlDbType.NVarChar, 30), new SqlParameter("@F_PassWord", SqlDbType.Char, 32), new SqlParameter("@F_DepartID", SqlDbType.Int, 4), new SqlParameter("@F_RoleID", SqlDbType.Int, 4), new SqlParameter("@F_RealName", SqlDbType.NVarChar, 10), new SqlParameter("@F_Sex", SqlDbType.Bit, 1), new SqlParameter("@F_Birthday", SqlDbType.SmallDateTime), new SqlParameter("@F_Email", SqlDbType.NVarChar, 50), new SqlParameter("@F_MobilePhone", SqlDbType.NVarChar, 20), new SqlParameter("@F_Telphone", SqlDbType.NVarChar, 20), new SqlParameter("@F_Note", SqlDbType.NVarChar, 500), new SqlParameter("@F_RegTime", SqlDbType.SmallDateTime), new SqlParameter("@F_LastInTime", SqlDbType.SmallDateTime), new SqlParameter("@F_IsUsed", SqlDbType.Bit, 1), new SqlParameter("@F_UserID", SqlDbType.Int, 4) }; parameters[0].Value = model.F_UserName; parameters[1].Value = model.F_PassWord; parameters[2].Value = model.F_DepartID; parameters[3].Value = model.F_RoleID; parameters[4].Value = model.F_RealName; parameters[5].Value = model.F_Sex; parameters[6].Value = model.F_Birthday; parameters[7].Value = model.F_Email; parameters[8].Value = model.F_MobilePhone; parameters[9].Value = model.F_Telphone; parameters[10].Value = model.F_Note; parameters[11].Value = model.F_RegTime; parameters[12].Value = model.F_LastInTime; parameters[13].Value = model.F_IsUsed; parameters[14].Value = model.F_UserID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public GSSModel.Users GetModel(int F_UserID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 F_UserID,F_UserName,F_PassWord,F_DepartID,F_RoleID,F_RealName,F_Sex,F_Birthday,F_Email,F_MobilePhone,F_Telphone,F_Note,F_RegTime,F_LastInTime,F_IsUsed from T_Users "); strSql.Append(" where F_UserID=@F_UserID"); SqlParameter[] parameters = { new SqlParameter("@F_UserID", SqlDbType.Int, 4) }; parameters[0].Value = F_UserID; GSSModel.Users model = new GSSModel.Users(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["F_UserID"].ToString() != "") { model.F_UserID = int.Parse(ds.Tables[0].Rows[0]["F_UserID"].ToString()); } if (ds.Tables[0].Rows[0]["F_UserName"] != null) { model.F_UserName = ds.Tables[0].Rows[0]["F_UserName"].ToString(); } if (ds.Tables[0].Rows[0]["F_PassWord"] != null) { model.F_PassWord = ds.Tables[0].Rows[0]["F_PassWord"].ToString(); } if (ds.Tables[0].Rows[0]["F_DepartID"].ToString() != "") { model.F_DepartID = int.Parse(ds.Tables[0].Rows[0]["F_DepartID"].ToString()); } if (ds.Tables[0].Rows[0]["F_RoleID"].ToString() != "") { model.F_RoleID = int.Parse(ds.Tables[0].Rows[0]["F_RoleID"].ToString()); } if (ds.Tables[0].Rows[0]["F_RealName"] != null) { model.F_RealName = ds.Tables[0].Rows[0]["F_RealName"].ToString(); } if (ds.Tables[0].Rows[0]["F_Sex"].ToString() != "") { if ((ds.Tables[0].Rows[0]["F_Sex"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_Sex"].ToString().ToLower() == "true")) { model.F_Sex = true; } else { model.F_Sex = false; } } if (ds.Tables[0].Rows[0]["F_Birthday"].ToString() != "") { model.F_Birthday = DateTime.Parse(ds.Tables[0].Rows[0]["F_Birthday"].ToString()); } if (ds.Tables[0].Rows[0]["F_Email"] != null) { model.F_Email = ds.Tables[0].Rows[0]["F_Email"].ToString(); } if (ds.Tables[0].Rows[0]["F_MobilePhone"] != null) { model.F_MobilePhone = ds.Tables[0].Rows[0]["F_MobilePhone"].ToString(); } if (ds.Tables[0].Rows[0]["F_Telphone"] != null) { model.F_Telphone = ds.Tables[0].Rows[0]["F_Telphone"].ToString(); } if (ds.Tables[0].Rows[0]["F_Note"] != null) { model.F_Note = ds.Tables[0].Rows[0]["F_Note"].ToString(); } if (ds.Tables[0].Rows[0]["F_RegTime"].ToString() != "") { model.F_RegTime = DateTime.Parse(ds.Tables[0].Rows[0]["F_RegTime"].ToString()); } if (ds.Tables[0].Rows[0]["F_LastInTime"].ToString() != "") { model.F_LastInTime = DateTime.Parse(ds.Tables[0].Rows[0]["F_LastInTime"].ToString()); } if (ds.Tables[0].Rows[0]["F_IsUsed"].ToString() != "") { if ((ds.Tables[0].Rows[0]["F_IsUsed"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsUsed"].ToString().ToLower() == "true")) { model.F_IsUsed = true; } else { model.F_IsUsed = false; } } return(model); } else { return(null); } }
/// <summary> /// 保存数据 /// </summary> private void SaveData() { //验证数据项 string msg = CheckData(); if (msg.Length > 0) { MessageBox.Show(msg, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (textBoxPSWH.Text.Trim().Length == 0 && f_PassWordTextBox.Text.Trim().Length == 0) { MessageBox.Show("请输入密码!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { textBoxPSWH.Text = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(f_PassWordTextBox.Text.Trim(), "MD5").ToLower(); } //数据准备 GSSModel.Users model = new GSSModel.Users(); model.F_UserName = f_UserNameTextBox.Text; model.F_PassWord = textBoxPSWH.Text; model.F_DepartID = Convert.ToInt32(f_DepartIDComboBox.SelectedValue); model.F_RoleID = Convert.ToInt32(f_RoleIDComboBox.SelectedValue); model.F_RealName = f_RealNameTextBox.Text; model.F_Sex = SexradioButton1.Checked; model.F_Birthday = Convert.ToDateTime(f_BirthdayDateTimePicker.Text); model.F_Email = f_EmailTextBox.Text; model.F_MobilePhone = f_MobilePhoneTextBox.Text; model.F_Telphone = f_TelphoneTextBox.Text; model.F_Note = f_NoteTextBox.Text; model.F_IsUsed = f_IsUsedCheckBox.Checked; //数据提交 GSSBLL.Users bll = new GSSBLL.Users(); bool isok = false; if (_id != 0) { model.F_UserID = int.Parse(f_UserIDTextBox.Text); model.F_LastInTime = DateTime.Now; isok = bll.Update(model); } else { model.F_RegTime = DateTime.Now; int num = bll.Add(model); if (num > 0) { isok = true; } } if (isok) { MessageBox.Show("数据保存成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("数据保存失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Error); } }