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