private void butsave_Click(object sender, System.EventArgs e) { if (MessageBox.Show(this, "您 [确定] 要保存参数设置吗?", "确认", MessageBoxButtons.YesNo) == DialogResult.No) { return; } try { string str_old = "修改[" + cmbyjks.Text.Trim() + "]参数 "; InstanceForm.BDatabase.BeginTransaction(); DataTable tb = (DataTable)this.myDataGrid1.DataSource; for (int i = 0; i <= tb.Rows.Count - 1; i++) { int _values = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["参数值"], "0")); string _code = Convertor.IsNull(tb.Rows[i]["参数编码"], "0"); string ssql = "update yk_config set zt=" + _values + " where bh='" + _code + "' and deptid=" + Convertor.IsNull(cmbyjks.SelectedValue, "0") + ""; InstanceForm.BDatabase.DoCommand(ssql); str_old = str_old + _code.ToString() + ":" + _values.ToString() + "|"; } SystemLog systemLog = new SystemLog(-1, InstanceForm.BCurrentDept.DeptId, InstanceForm.BCurrentUser.EmployeeId, "修改药品参数", str_old, DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase), 0, "主机名:" + System.Environment.MachineName, 8); systemLog.Save(); systemLog = null; Yp.InsertLog("修改药品参数", TrasenFrame.Forms.FrmMdiMain.CurrentDept.DeptId, 0, TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId, DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToString(), str_old, InstanceForm.BDatabase); InstanceForm.BDatabase.CommitTransaction(); MessageBox.Show("保存成功"); } catch (System.Exception err) { InstanceForm.BDatabase.RollbackTransaction(); MessageBox.Show(err.Message); } }
private void butsave_Click(object sender, System.EventArgs e) { if (MessageBox.Show(this, "您的确要更改以下药品的禁用状态吗?", "确认", MessageBoxButtons.YesNo) == DialogResult.No) { return; } if (this.rdolog.Checked == true) { return; } DataTable tb = (DataTable)this.myDataGrid1.DataSource; string ssql = ""; string sdate = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToString(); try { //this.Cursor=XcjwHIS.BussinessLogicLayer.Classes.PublicStaticFun.WaitCursor(); InstanceForm.BDatabase.BeginTransaction(); this.butsave.Enabled = false; for (int i = 0; i <= tb.Rows.Count - 1; i++) { if (tb.Rows[i]["药库禁用"].ToString().Trim() == "√") { ssql = "update yf_kcph set ykbdelete=1 where cjid=" + Convert.ToInt32(tb.Rows[i]["cjid"]) + " and deptid=" + Convert.ToInt32(tb.Rows[i]["deptid"]) + ""; InstanceForm.BDatabase.DoCommand(ssql); ssql = "update yf_kcmx set bdelete=1 where cjid=" + Convert.ToInt32(tb.Rows[i]["cjid"]) + " and deptid=" + Convert.ToInt32(tb.Rows[i]["deptid"]) + ""; InstanceForm.BDatabase.DoCommand(ssql); Yp.InsertLog("禁用药品", Convert.ToInt32(tb.Rows[i]["deptid"]), Convert.ToInt32(tb.Rows[i]["cjid"]), InstanceForm.BCurrentUser.EmployeeId, sdate, "★药库人员禁用,当时库存为 " + tb.Rows[i]["库存量"].ToString() + tb.Rows[i]["单位"].ToString(), InstanceForm.BDatabase); } else { ssql = "update yf_kcph set ykbdelete=0 where cjid=" + Convert.ToInt32(tb.Rows[i]["cjid"]) + " and deptid=" + Convert.ToInt32(tb.Rows[i]["deptid"]) + " and ykbdelete=1"; int ncount = InstanceForm.BDatabase.DoCommand(ssql); if (ncount > 0) { ssql = "select * from yf_kcph where bdelete=0 and cjid=" + Convert.ToInt32(tb.Rows[i]["cjid"]) + " and deptid=" + Convert.ToInt32(tb.Rows[i]["deptid"]) + ""; DataTable tbph = InstanceForm.BDatabase.GetDataTable(ssql); if (tbph.Rows.Count > 0) { ssql = "update yf_kcmx set bdelete=0 where cjid=" + Convert.ToInt32(tb.Rows[i]["cjid"]) + " and deptid=" + Convert.ToInt32(tb.Rows[i]["deptid"]) + ""; InstanceForm.BDatabase.DoCommand(ssql); } Yp.InsertLog("禁用药品", Convert.ToInt32(tb.Rows[i]["deptid"]), Convert.ToInt32(tb.Rows[i]["cjid"]), InstanceForm.BCurrentUser.EmployeeId, sdate, "★药库人员解除禁用,当时库存为 " + tb.Rows[i]["库存量"].ToString() + tb.Rows[i]["单位"].ToString(), InstanceForm.BDatabase); } } } InstanceForm.BDatabase.CommitTransaction(); this.butsave.Enabled = true; MessageBox.Show("保存成功"); } catch (System.Exception err) { InstanceForm.BDatabase.RollbackTransaction(); this.butsave.Enabled = true; MessageBox.Show(err.Message); } }