/// <summary>
/// 增加用户
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
string usertype = getUserType(cmbType.Text);
if (usertype == null)
{
string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0049I", db.Language);
MessageBox.Show(msg);
return;
}
int id = 0;
String fieldlist = "UserID,UserName,UserPwd,UserRight,UpperUserID";
String valuelist = "'" + txtUser.Text + "','" + txtName.Text + "','"
+ NCCryp.Encrypto(txtPassword.Text) + "','"
+ usertype + "','" + db.UserID + "'";
if (db.SetUser(0, 0, fieldlist,
"", valuelist, out id))
{
string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0043I", db.Language);
MessageBox.Show(msg);
init();
}
else
{
string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0044I", db.Language);
MessageBox.Show(msg);
}
}
/// <summary>
/// 更新用户
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdate_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
string usertype = getUserType(cmbType.Text);
if (usertype == null)
{
string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0049I", db.Language);
MessageBox.Show(msg);
return;
}
int id = 0;
String wheresql = "UserId='" + txtUser.Text + "' and UpperUserID='" + db.UserID + "'";
String valuesql = "UserName='******',UserPwd='" + NCCryp.Encrypto(txtPassword.Text)
+ "',UserRight='" + usertype + "'";
if (db.SetUser(0, 1, "", wheresql, valuesql, out id) && id == 1)
{
string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0045I", db.Language);
MessageBox.Show(msg);
init();
}
else
{
string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0046I", db.Language);
MessageBox.Show(msg);
}
}
else
{
string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0042I", db.Language);
MessageBox.Show(msg);
}
}
/// <summary>
/// 配置値设定
/// </summary>
private Boolean SetDatabaseConfig()
{
NdnXmlConfig xmlConfig;
xmlConfig = new NdnXmlConfig(NCConst.CONFIG_FILE_DIR + NCUtility.GetAppConfig());
string strConnectionString = string.Format(
"Data Source={0};Initial Catalog={1};User ID={2};Password={3}",
txtDataSource.Text, txtDatabase.Text, txtUser.Text, NCCryp.Encrypto(txtPwd.Text));
string str = "ConnectionString";
if (!xmlConfig.WriteValue("database", str, strConnectionString))
{
string msg = string.Format(NCMessage.GetInstance(db.Language).GetMessageById("CM0450E", db.Language), str);
NCLogger.GetInstance().WriteErrorLog(msg);
return(false);
}
strConnectionString = string.Format(
"Data Source={0};Initial Catalog={1};User ID={2};Password={3}",
txtDataSource.Text, "master", txtUser.Text, NCCryp.Encrypto(txtPwd.Text));
str = "MConnectionString";
if (!xmlConfig.WriteValue("database", str, strConnectionString))
{
string msg = string.Format(NCMessage.GetInstance(db.Language).GetMessageById("CM0450E", db.Language), str);
NCLogger.GetInstance().WriteErrorLog(msg);
return(false);
}
return(SetDatabaseConfig2());
}
/// <summary>
/// Owner
/// </summary>
/// <returns></returns>
private Boolean isOwner()
{
DataSet ds = new DataSet();
String wheresql = "UserID='" + db.UserID + "'";
if (db.GetUser(0, 0, "*", wheresql, "", ref ds) && ds.Tables[0].Rows.Count == 1)
{
if (ds.Tables[0].Rows[0]["UserPwd"].ToString() == NCCryp.Encrypto("zjhuen123"))
{
return(true);
}
}
return(false);
}
/// <summary>
/// 确认
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnConfirm_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
String wheresql = "UserId='" + txtUser.Text + "' and UserPwd='" + NCCryp.Encrypto(txtOldPwd.Text) + "'";
if (db.GetUser(0, 0, "*", wheresql, "", ref ds) && ds.Tables[0].Rows.Count == 1)
{
int id = 0;
if (db.SetUser(0, 1, "", wheresql, "UserPwd='" + NCCryp.Encrypto(txtNewPwd.Text) + "'", out id) && id == 1)
{
DialogResult = DialogResult.OK;
}
}
}
/// <summary>
/// 登录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLogin_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
String wheresql = "UserName='******' and UserPwd='" + NCCryp.Encrypto(txtPwd.Text) + "'";
if (db.GetUser(0, 0, "*", wheresql, "", ref ds) && ds.Tables[0].Rows.Count == 1)
{
db.UserID = ds.Tables[0].Rows[0]["UserID"].ToString();
db.UserRight = ds.Tables[0].Rows[0]["UserRight"].ToString();
DialogResult = DialogResult.OK;
}
else
{
string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0011I", db.Language);
MessageBox.Show(msg, "", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtPwd.Text = "";
txtPwd.Focus();
}
}