public MODELBASE_LOGIN GetMODELBASE_LOGIN(string strUserID) { DataTable dt = new DataTable(); MODELBASE_LOGIN MODELBASE_LOGIN = new MODELBASE_LOGIN(); StringBuilder str = new StringBuilder(); str.Append("SELECT * FROM BASE_LOGIN INNER JOIN BASE_POST ON BASE_LOGIN.POSTID=BASE_POST.POSTID WHERE LOGINID=@LOGINID"); SqlParameter[] para = { new SqlParameter("@LOGINID", SqlDbType.VarChar, 30) }; para[0].Value = strUserID; dt = DBUtility.DbHelperSQL.Query(str.ToString(), para).Tables[0]; if (dt.Rows.Count == 0) { return(null); } else { MODELBASE_LOGIN.LOGINNAME = dt.Rows[0]["LOGINNAME"].ToString(); if (dt.Rows[0]["USERNAME"] != null) { MODELBASE_LOGIN.USERNAME = dt.Rows[0]["USERNAME"].ToString(); } MODELBASE_LOGIN.LOGINPASSWORD = dt.Rows[0]["LOGINPASSWORD"].ToString(); MODELBASE_LOGIN.POSTID = dt.Rows[0]["POSTID"].ToString(); MODELBASE_LOGIN.DEPARTMENTID = dt.Rows[0]["DEPARTMENTID"].ToString(); if (dt.Rows[0]["MEMO"] != null) { MODELBASE_LOGIN.MEMO = dt.Rows[0]["MEMO"].ToString(); } MODELBASE_LOGIN.isMeterReader = dt.Rows[0]["isMeterReader"].ToString(); return(MODELBASE_LOGIN); } }
public bool InsertBASE_LOGIN(MODELBASE_LOGIN MODELBASE_LOGIN) { StringBuilder str = new StringBuilder(); str.Append("INSERT INTO BASE_LOGIN(LOGINID,LOGINNAME,workNO,USERNAME,LOGINPASSWORD,POSTID,DEPARTMENTID," + "MEMO,TELEPHONENO,isMeterReader,isCharger,groupID,generateDateTime,userstate,IsCashier,Password) "); str.Append("VALUES(@LOGINID,@LOGINNAME,@workNO,@USERNAME,@LOGINPASSWORD,@POSTID,@DEPARTMENTID," + "@MEMO,@TELEPHONENO,@isMeterReader,@isCharger,@groupID,@generateDateTime,@userstate,@IsCashier,@Password)"); SqlParameter[] para = { new SqlParameter("@LOGINID", SqlDbType.VarChar, 50), new SqlParameter("@LOGINNAME", SqlDbType.VarChar, 50), new SqlParameter("@workNO", SqlDbType.VarChar, 30), new SqlParameter("@USERNAME", SqlDbType.VarChar, 50), new SqlParameter("@LOGINPASSWORD", SqlDbType.VarChar, 200), new SqlParameter("@POSTID", SqlDbType.Int), new SqlParameter("@DEPARTMENTID", SqlDbType.VarChar, 30), new SqlParameter("@MEMO", SqlDbType.VarChar, 50), new SqlParameter("@TELEPHONENO", SqlDbType.VarChar, 50), new SqlParameter("@isMeterReader", SqlDbType.VarChar, 10), new SqlParameter("@isCharger", SqlDbType.VarChar, 10), new SqlParameter("@groupID", SqlDbType.VarChar, 10), new SqlParameter("@generateDateTime", SqlDbType.DateTime), new SqlParameter("@userstate", SqlDbType.VarChar, 10), new SqlParameter("@IsCashier", SqlDbType.VarChar, 10), new SqlParameter("@Password", SqlDbType.VarChar, 50) }; para[0].Value = MODELBASE_LOGIN.LOGINID; para[1].Value = MODELBASE_LOGIN.LOGINNAME; para[2].Value = MODELBASE_LOGIN.workNO; para[3].Value = MODELBASE_LOGIN.USERNAME; para[4].Value = MODELBASE_LOGIN.LOGINPASSWORD; para[5].Value = MODELBASE_LOGIN.POSTID; para[6].Value = MODELBASE_LOGIN.DEPARTMENTID; para[7].Value = MODELBASE_LOGIN.MEMO; para[8].Value = MODELBASE_LOGIN.TELEPHONENO; para[9].Value = MODELBASE_LOGIN.isMeterReader; para[10].Value = MODELBASE_LOGIN.isCharger; para[11].Value = MODELBASE_LOGIN.groupID; para[12].Value = MODELBASE_LOGIN.generateDateTime; para[13].Value = MODELBASE_LOGIN.userstate; para[14].Value = MODELBASE_LOGIN.IsCashier; para[15].Value = MODELBASE_LOGIN.LOGINPASSWORD; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
public bool UpdateUser(MODELBASE_LOGIN MODELBASE_LOGIN) { StringBuilder str = new StringBuilder(); str.Append("UPDATE BASE_LOGIN SET LOGINNAME=@LOGINNAME,workNO=@workNO,USERNAME=@USERNAME,POSTID=@POSTID," + "DEPARTMENTID=@DEPARTMENTID,MEMO=@MEMO,TELEPHONENO=@TELEPHONENO,isMeterReader=@isMeterReader,isCharger=@isCharger," + "groupID=@groupID,userstate=@userstate,IsCashier=@IsCashier "); str.Append("WHERE LOGINID=@LOGINID"); SqlParameter[] para = { new SqlParameter("@LOGINNAME", SqlDbType.VarChar, 30), new SqlParameter("@workNO", SqlDbType.VarChar, 50), new SqlParameter("@USERNAME", SqlDbType.VarChar, 50), new SqlParameter("@POSTID", SqlDbType.Int), new SqlParameter("@DEPARTMENTID", SqlDbType.VarChar, 30), new SqlParameter("@MEMO", SqlDbType.VarChar, 50), new SqlParameter("@TELEPHONENO", SqlDbType.VarChar, 50), new SqlParameter("@isMeterReader", SqlDbType.VarChar, 10), new SqlParameter("@isCharger", SqlDbType.VarChar, 10), new SqlParameter("@groupID", SqlDbType.VarChar, 10), new SqlParameter("@userstate", SqlDbType.VarChar, 10), new SqlParameter("@IsCashier", SqlDbType.VarChar, 10), new SqlParameter("@LOGINID", SqlDbType.VarChar, 50) }; para[0].Value = MODELBASE_LOGIN.LOGINNAME; para[1].Value = MODELBASE_LOGIN.workNO; para[2].Value = MODELBASE_LOGIN.USERNAME; para[3].Value = MODELBASE_LOGIN.POSTID; para[4].Value = MODELBASE_LOGIN.DEPARTMENTID; para[5].Value = MODELBASE_LOGIN.MEMO; para[6].Value = MODELBASE_LOGIN.TELEPHONENO; para[7].Value = MODELBASE_LOGIN.isMeterReader; para[8].Value = MODELBASE_LOGIN.isCharger; para[9].Value = MODELBASE_LOGIN.groupID; para[10].Value = MODELBASE_LOGIN.userstate; para[11].Value = MODELBASE_LOGIN.IsCashier; para[12].Value = MODELBASE_LOGIN.LOGINID; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
private void btOK_Click(object sender, EventArgs e) { if (txtOldPWD.Text.Trim() == "") { mes.Show("请输入原密码!"); txtOldPWD.Focus(); return; } if (txtPWD.Text.Trim() == "") { mes.Show("请输入新密码!"); txtOldPWD.Focus(); return; } if (txtPWD.Text != txtConfigPWD.Text) { mes.Show("新密码和确定密码不一致,请重新输入!"); txtConfigPWD.Focus(); return; } string strPWD = txtOldPWD.Text; //strPWD = DBUtility.DESEncrypt.Encrypt(strPWD); string strFliter = " AND LOGINID='" + AppDomain.CurrentDomain.GetData("LOGINID").ToString() + "' AND LOGINPASSWORD='******'"; DataTable dt = BLLBASE_LOGIN.QueryUser(strFliter); if (dt.Rows.Count > 0) { //strPWD = DBUtility.DESEncrypt.Encrypt(txtPWD.Text); strPWD = txtPWD.Text; MODELBASE_LOGIN MODELBASE_LOGIN = new MODELBASE_LOGIN(); MODELBASE_LOGIN.LOGINID = AppDomain.CurrentDomain.GetData("LOGINID").ToString(); MODELBASE_LOGIN.LOGINPASSWORD = strPWD; if (BLLBASE_LOGIN.UpdateUserPWD(MODELBASE_LOGIN.LOGINID, MODELBASE_LOGIN.LOGINPASSWORD)) { mes.Show("密码修改成功!"); return; } } else { mes.Show("原密码不正确,请重新输入!"); txtOldPWD.Focus(); return; } }
private void toolSave_Click(object sender, EventArgs e) { if (txtName.Text.Trim() == "") { mes.Show("请输入用户姓名!"); txtName.Focus(); return; } if (txtLogName.Text.Trim() == "") { mes.Show("请输入登录名!"); txtLogName.Focus(); return; } if (cmbDEP.SelectedValue == DBNull.Value || cmbDEP.SelectedValue == null) { mes.Show("请选择所属部门!"); cmbDEP.Focus(); return; } if (cmbPost.SelectedValue == DBNull.Value || cmbPost.SelectedValue == null) { mes.Show("请选择职务!"); cmbPost.Focus(); return; } if (cmbGroup.SelectedValue == DBNull.Value || cmbGroup.SelectedValue == null) { mes.Show("请选择所属分组!"); cmbGroup.Focus(); return; } if (cmbState.SelectedIndex < 0) { mes.Show("请选择用户状态!"); cmbState.Focus(); return; } MODELBASE_LOGIN MODELBASE_LOGIN = new MODELBASE_LOGIN(); try { MODELBASE_LOGIN.LOGINNAME = txtLogName.Text.Trim(); MODELBASE_LOGIN.workNO = txtWorkNO.Text.Trim(); MODELBASE_LOGIN.USERNAME = txtName.Text.Trim(); MODELBASE_LOGIN.DEPARTMENTID = cmbDEP.SelectedValue.ToString(); MODELBASE_LOGIN.POSTID = cmbPost.SelectedValue.ToString();; MODELBASE_LOGIN.groupID = cmbGroup.SelectedValue.ToString(); //用户状态选择第一个(正常)为“1”,否则为“0” if (cmbState.SelectedIndex == 0) { MODELBASE_LOGIN.userstate = "1"; } else { MODELBASE_LOGIN.userstate = "0"; } MODELBASE_LOGIN.TELEPHONENO = txtTel.Text.Trim(); if (chkIsMeterReader.Checked) { MODELBASE_LOGIN.isMeterReader = "1"; } else { MODELBASE_LOGIN.isMeterReader = "0"; } if (chkIsCharger.Checked) { MODELBASE_LOGIN.isCharger = "1"; } else { MODELBASE_LOGIN.isCharger = "0"; } if (chkIsCashierS.Checked) { MODELBASE_LOGIN.IsCashier = "1"; } else { MODELBASE_LOGIN.IsCashier = "0"; } MODELBASE_LOGIN.MEMO = txtMemo.Text; if (isAdd) { MODELBASE_LOGIN.LOGINID = GETTABLEID.GetTableID(strLoginID, "BASE_LOGIN"); MODELBASE_LOGIN.LOGINPASSWORD = "******"; MODELBASE_LOGIN.generateDateTime = mes.GetDatetimeNow(); if (BLLBASE_LOGIN.InsertBASE_LOGIN(MODELBASE_LOGIN)) { toolSave.Enabled = false; toolSearch.Enabled = true; toolModify.Enabled = true; toolDel.Enabled = true; toolResetPWD.Enabled = true; //toolAdd.Enabled = true;true toolAdd.Text = "添加"; DisEnableControls(grpDetail); toolSearch_Click(null, null); dgUser.ClearSelection(); for (int i = 0; i < dgUser.Rows.Count; i++) { if (dgUser.Rows[i].Cells["LOGINID"].Value != null && dgUser.CurrentRow.Cells["LOGINID"].Value != DBNull.Value) { string strID = dgUser.Rows[i].Cells["LOGINID"].Value.ToString(); if (MODELBASE_LOGIN.LOGINID == strID) { dgUser.CurrentCell = dgUser.Rows[i].Cells["USERNAME"]; dgUser_SelectionChanged(null, null); } } } //mes.Show("添加成功!"); dgUser.Enabled = true; return; } } else { MODELBASE_LOGIN.LOGINID = txtUserID.Text.Trim(); if (BLLBASE_LOGIN.UpdateUser(MODELBASE_LOGIN)) { toolSave.Enabled = false; toolSearch.Enabled = true; //toolModify.Enabled = true; toolDel.Enabled = true; toolAdd.Enabled = true; toolResetPWD.Enabled = true; toolModify.Text = "修改"; DisEnableControls(grpDetail); toolSearch_Click(null, null); dgUser.ClearSelection(); for (int i = 0; i < dgUser.Rows.Count; i++) { if (dgUser.Rows[i].Cells["LOGINID"].Value != null && dgUser.CurrentRow.Cells["LOGINID"].Value != DBNull.Value) { string strID = dgUser.Rows[i].Cells["LOGINID"].Value.ToString(); if (MODELBASE_LOGIN.LOGINID == strID) { dgUser.CurrentCell = dgUser.Rows[i].Cells["USERNAME"]; dgUser_SelectionChanged(null, null); } } } //mes.Show("修改成功!"); dgUser.Enabled = true; return; } } } catch (Exception ex) { mes.Show(ex.ToString()); } }