/// <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>
/// 配置
/// </summary>
/// <returns></returns>
private bool GetConfigValue()
{
bool ret = true;
///取得配置信息
NCLogger.GetInstance().WriteInfoLog("GetConfigValue Start");
NdnXmlConfig xmlConfig;
xmlConfig = new NdnXmlConfig(NCConst.CONFIG_FILE_DIR + NCUtility.GetAppConfig());
if (!xmlConfig.ReadXmlData("config", "ftpserver", ref ftpserver))
{
ret = false;
}
if (!xmlConfig.ReadXmlData("config", "ftpuser", ref userName))
{
ret = false;
}
if (!xmlConfig.ReadXmlData("config", "ftppassword", ref password))
{
ret = false;
}
password = NCCryp.Decrypto(password);
NCLogger.GetInstance().WriteInfoLog("GetConfigValue end");
return(ret);
}
/// <summary>
/// 行选择
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dataGridView1_SelectionChanged(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
txtUser.Text = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
txtName.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
txtPassword.Text = NCCryp.Decrypto(dataGridView1.SelectedRows[0].Cells[2].Value.ToString());
cmbType.Text = db.UserRightTable[dataGridView1.SelectedRows[0].Cells[3].Value.ToString()].ToString();
}
}
/// <summary>
/// 产品变更
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmbProduct_SelectedIndexChanged(object sender, EventArgs e)
{
txtProductID.Text = NCCryp.getProductID(cmbProduct.Text);
if (txtProductID.Text == "")
{
string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0106I", db.Language);
MessageBox.Show(msg);
return;
}
txtLicId.Text = "";
}
/// <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 FormRegist_Load(object sender, EventArgs e)
{
try
{
if (GetProductValue())
{
string[] products = product.Split(';');
foreach (string prod in products)
{
cmbProduct.Items.Add(prod);
}
cmbProduct.SelectedIndex = 0;
}
txtProductID.Text = NCCryp.getProductID();
if (txtProductID.Text == "")
{
string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0106I", db.Language);
MessageBox.Show(msg);
return;
}
}
catch (Exception ex)
{
NCLogger.GetInstance().WriteExceptionLog(ex);
return;
}
if (GetConfigValue())
{
txtLicId.Text = lic;
if (txtLicId.Text != "" && NCCryp.checkLic(txtLicId.Text))
{
btnRegist.Enabled = false;
btnSend.Enabled = false;
btnAdd.Enabled = false;
}
}
if (isOwner())
{
txtProductID.ReadOnly = false;
btnCreate.Enabled = true;
btnCreate.Visible = true;
btnAdd.Enabled = true;
}
else
{
btnCreate.Enabled = false;
btnCreate.Visible = false;
btnAdd.Enabled = 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 btnRegist_Click(object sender, EventArgs e)
{
if (NCCryp.checkLic(txtLicId.Text))
{
SetLicValue(txtLicId.Text);
string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0104I", db.Language);
MessageBox.Show(msg);
Close();
}
else
{
string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0105I", db.Language);
MessageBox.Show(msg);
}
}
/// <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();
}
}
/// <summary>
/// 取得数据库连接
/// </summary>
/// <returns></returns>
protected bool GetConnectionString()
{
NdnXmlConfig xmlConfig;
xmlConfig = new NdnXmlConfig(NCConst.CONFIG_FILE_DIR + NCUtility.GetAppConfig());
string strConnectionString = null;
string str = "ConnectionString";
if (xmlConfig.ReadXmlData("database", str, ref strConnectionString))
{
string[] temp = strConnectionString.Split(';');
if (temp.Length > 0)
{
for (int idx = 0; idx < temp.Length; idx++)
{
if (temp[idx].IndexOf("Password="******"Password="******"");
strPassword = NCCryp.Decrypto(temp[idx]);
}
else if (temp[idx].IndexOf("Data Source=") > -1)
{
temp[idx] = temp[idx].Replace("Data Source=", "");
strDataSource = temp[idx];
}
else if (temp[idx].IndexOf("Initial Catalog=") > -1)
{
temp[idx] = temp[idx].Replace("Initial Catalog=", "");
strDbName = temp[idx];
}
else if (temp[idx].IndexOf("User ID=") > -1)
{
temp[idx] = temp[idx].Replace("User ID=", "");
strUserName = temp[idx];
}
}
return(true);
}
}
return(false);
}
/// <summary>
/// 取得实例
/// </summary>
/// <param name="paramenter"></param>
public void GetInstance(object[] paramenter)
{
CmWinServiceAPI db_ = null;
if (paramenter.Length > 0)
{
db_ = (CmWinServiceAPI)paramenter[0];
}
if (paramenter.Length > 1)
{
string serialNo = (string)paramenter[1];
if (!String.IsNullOrEmpty(serialNo))
{
if (NCCryp.checkLic(serialNo, SYSTEM_ID))
{
FormMain form = new FormMain(db_);
form.ShowDialog();
}
}
}
}
/// <summary>
/// 生成
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnTest_Click(object sender, EventArgs e)
{
txtLicId.Text = NCCryp.getLic(NCCryp.getHardIDFromProductId(txtProductID.Text, cmbProduct.Text), cmbProduct.Text);
}
