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());
}
}
