private void LoadUserInfo() { //如果是修改加载user信息 用户账号不允许修改 if (this.Owner is ConfigManager) { ConfigManager configManager = (ConfigManager)this.Owner; if (configManager.flag.Equals("2")) { ScanDataSet scandataset = new Business.ConfigInfo().GetConfigInfoByID(configManager.configID); if (scandataset.ConfigInfo.Rows.Count > 0) { configTable = scandataset.ConfigInfo; configRow = scandataset.ConfigInfo.Rows[0]; this.tbsite.Text = configRow["site"].ToString(); this.tbSDKPath.Text = configRow["sdkpath"].ToString(); this.tbSDKSN.Text = configRow["sdksn"].ToString(); this.cbDBType.SelectedValue = configRow["dbtype"].ToString(); this.tbServer.Text = configRow["server"].ToString(); this.tbUserName.Text = configRow["username"].ToString(); this.tbPassWord.Text = configRow["password"].ToString(); string status = configRow["status"].ToString(); switch (status) { case "1": this.StartRadioButton.Checked = true; break; case "0": this.ForbidRadioButton.Checked = true; break; default: this.StartRadioButton.Checked = true; break; } } else { MessageBox.Show("获取用户信息错误!"); return; } } } }
private void btnUpdateStatus_Click(object sender, EventArgs e) { //判断选中几行 try { int count = 0; bool result = false; for (int i = 0; i < this.dgvConfigInfo.Rows.Count; i++) { if (this.dgvConfigInfo.Rows[i].Cells[this.dgvConfigInfo.Columns["SelectCheck"].Index].EditedFormattedValue.ToString() == "True") { count++; this.configID = this.dgvConfigInfo.Rows[i].Cells["id"].Value.ToString(); string status = this.dgvConfigInfo.Rows[i].Cells["status"].Value.ToString(); ScanDataSet scanDataSet = new Business.ConfigInfo().GetConfigInfoByID(this.configID); if (scanDataSet.ConfigInfo.Rows.Count > 0) { ScanDataSet.ConfigInfoDataTable dt = scanDataSet.ConfigInfo; dt.Rows[0]["status"] = status == "1" ? "0" : "1"; result = new Business.ConfigInfo().AddConfig(dt); } } } if (count == 0) { MessageBox.Show("请选择要修改的行!"); return; } else if (count > 1) { MessageBox.Show("请选择一行修改记录!"); return; } if (result) { MessageBox.Show("更新成功!"); return; } } catch (Exception ex) { throw ex; } }
private void btnSave_Click(object sender, EventArgs e) { try { //校验数据 CheckContent(); bool result; ConfigManager configManager; //判断是新增 or 修改 if (this.Owner is ConfigManager) { configManager = (ConfigManager)this.Owner; if (configManager.flag.Equals("1")) { configTable = new ScanDataSet.ConfigInfoDataTable(); configInfoRow = configTable.NewConfigInfoRow(); configInfoRow.Site = this.tbsite.Text.Trim(); configInfoRow.SdkPath = this.tbSDKPath.Text.Trim(); configInfoRow.SdkSn = this.tbSDKSN.Text.Trim(); configInfoRow.Forgid = ((ConfigManager)this.Owner).orgID; configInfoRow.Frcode = ((ConfigManager)this.Owner).frcode; configInfoRow.DbType = this.cbDBType.SelectedValue.ToString(); configInfoRow.Server = this.tbServer.Text.Trim(); configInfoRow.UserName = this.tbUserName.Text.Trim(); configInfoRow.PassWord = this.tbPassWord.Text.Trim(); configInfoRow.DbName = this.tbDBName.Text.Trim(); string status = ""; if (this.StartRadioButton.Checked) { status = "1"; } if (this.ForbidRadioButton.Checked) { status = "0"; } configInfoRow.Status = status; configTable.AddConfigInfoRow(configInfoRow); result = new Business.ConfigInfo().AddConfig(configTable); } else if (configManager.flag.Equals("2")) { ScanDataSet scandataset = new Business.ConfigInfo().GetConfigInfoByID(configManager.configID); if (scandataset.ConfigInfo.Rows.Count > 0) { configTable = scandataset.ConfigInfo; configRow = scandataset.ConfigInfo.Rows[0]; configRow["site"] = this.tbsite.Text.Trim(); configRow["sdkpath"] = this.tbSDKPath.Text.Trim(); configRow["sdksn"] = this.tbSDKSN.Text.Trim(); configRow["dbtype"] = this.cbDBType.SelectedValue.ToString(); configRow["server"] = this.tbServer.Text.Trim(); configRow["username"] = this.tbUserName.Text.Trim(); configRow["password"] = this.tbPassWord.Text.Trim(); configRow["dbname"] = this.tbDBName.Text.Trim(); string status = ""; if (this.StartRadioButton.Checked) { status = "1"; } if (this.ForbidRadioButton.Checked) { status = "0"; } configRow["status"] = status; if (!String.IsNullOrEmpty(((ConfigManager)this.Owner).configID)) { configRow["id"] = ((ConfigManager)this.Owner).configID; } result = new Business.ConfigInfo().AddConfig(configTable); } else { MessageBox.Show("获取用户信息错误!"); return; } } else { MessageBox.Show("获取业务标记错误!"); return; } } else { MessageBox.Show("获取父窗口错误!"); return; } if (result) { MessageBox.Show("保存成功!"); configManager.SearchData(); this.Close(); return; } else { MessageBox.Show("保存失败!"); return; } } catch (Exception ex) { throw ex; } }