private void btnSave_Click(object sender, EventArgs e) { try { if (dtPathTableItemRelation.GetChanges() != null && dtPathTableItemRelation.GetChanges().Rows.Count > 0) { this.BindingContext[dtPathTableItemRelation].EndCurrentEdit(); int row = DbOpt.Update(dtPathTableItemRelation, this._sSqlPathTableItemRelation); if (row > 0) { dtPathTableItemRelation.AcceptChanges(); MessageBox.Show("表单配置保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("表单配置保存失败,数据未能更新!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ex) { MessageBox.Show("保存失败,错误信息:" + ex.Message); } }
/// <summary> /// 保存事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void barBtSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { //提示是否保存 if (Trasen.Base.MsgBox.MsgShow("未填写评估内容的数据将被清除,确定保存当前字典配置?", "提示", MessageBoxButtons.YesNo, 350, 120) == DialogResult.Yes) { //结束DGV编辑状态 dgvDic.EndEdit(); //查找DT中评估内容为空的行,并删除 foreach (DataRow dr in dt.Select("CONTENT is NULL")) { if (dr["CONTENT"].ToString().Trim() == "") { dr.Delete(); } } //保存修改 this.BindingContext[dt].EndCurrentEdit(); int rows = DbOpt.Update(dt, sSql); if (rows >= 0) { dt.AcceptChanges(); //初始化 Init(); this.UseHelp("保存成功!"); } } } catch (Exception ex) { this.UseHelp("保存失败:" + ex.Message); } }
private void btnSetNow_Click(object sender, EventArgs e) { if (dgvPathTable.SelectedRows.Count == 1) { int iPathTableID = (int)dgvPathTable.SelectedRows[0].Cells["PATH_TABLE_ID"].Value; if (dtTable_Way.Rows.Count > 0) { dtTable_Way.Rows[0]["PATHTABLEID"] = iPathTableID.ToString(); int result = DbOpt.Update(dtTable_Way, this._sSqlTable_Way); if (result > 0) { LoadTable_Way(); } else { MessageBox.Show("设置表单失败.!"); } } else { string sSqlInsert = string.Format("INSERT INTO [PATHTABLE_WAY_RELATION] VALUES('{0}',{1},'')", this._sPathWayId, iPathTableID); int result = DbOpt.ExecuteNonQuery(sSqlInsert); if (result > 0) { LoadTable_Way(); } else { MessageBox.Show("设置表单失败.!"); } } } }
/// <summary> /// 保存事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void barBtSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { if (dgvCode.ReadOnly) { return; } //提示是否保存 if (Trasen.Base.MsgBox.MsgShow("没有代码或名称的数据将被清除,确定保存当前代码?", "提示", MessageBoxButtons.YesNo, 350, 120) == DialogResult.Yes) { //获取当前选择的代码类型 int iSelect = dgvCodeType.SelectedRows[0].Index; //结束DataGridView编辑状态 dgvCode.EndEdit(); //查找DataTable中代码和名称为空的行,并删除 foreach (DataRow dr in dtItem.Select("CODE is NULL OR NAME is NULL")) { //判断CODE和NAME是否为空字符串 if (dr["CODE"].ToString().Trim() == "" || dr["NAME"].ToString().Trim() == "") { dr.Delete();//删除该行 } } //结束当前绑定DataTable的编辑状态 this.BindingContext[dtItem].EndCurrentEdit(); //将DataTable更新至数据库,并获取修改行数 int rows = DbOpt.Update(dtItem, sSql); //判断是否有修改 if (rows >= 0) { //接受改变 dtItem.AcceptChanges(); //初始化 Init(); //设置选择的代码类型 dgvCodeType.CurrentCell = dgvCodeType["NOTE_t", iSelect]; //状态栏提示成功 this.UseHelp("保存成功!"); StartEdit(false); } } } catch (Exception ex) { //异常状态栏提示 this.UseHelp("保存失败:" + ex.Message); } }
/// <summary> /// 保存事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void barBtSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { //提示是否保存 if (Trasen.Base.MsgBox.MsgShow("未选择评估内容的数据将被清除,确定保存当前评估?", "提示", MessageBoxButtons.YesNo, 350, 120) == DialogResult.Yes) { //结束DataGridView编辑状态 dgvPathRuleItem.EndEdit(); //查找DataTable(路径评估)中评估内容为空的行,并删除 foreach (DataRow dr in dt.Select("CONTENT is NULL")) { //判断CONTENT(评估内容)是否为空字符串 if (dr["CONTENT"].ToString().Trim() == "") { dr.Delete();//删除该行 } } //结束当前绑定DataTable(路径评估)的编辑状态 this.BindingContext[dt].EndCurrentEdit(); //将DataTable(路径评估)更新至数据库,并获取修改行数 int rows = DbOpt.Update(dt, sSql); //判断是否有修改 if (rows >= 0) { //接受改变 dt.AcceptChanges(); //初始化 Init(); //状态栏提示成功 this.UseHelp("保存成功!"); } } } catch (Exception ex) { //异常状态栏提示 this.UseHelp("保存失败:" + ex.Message); } }
/// <summary> /// 保存 /// </summary> private int proSave() { int rows = -1; txt_PATHWAY_NAME.Tag = bIsPathWay ? "2;路径名称;1;0,100;" : "2;单病种名称;1;0,100;"; txt_PATHWAY_VERSION.Tag = "2;版本号;1;0,50;"; //ce_MIN_HOSPITAL_DAYS.Tag = "1;住院天数下线;1;0,5000;0;"; //ce_MAX_HOSPITAL_DAYS.Tag = "1;住院天数上线;1;0,5000;0;"; //ce_MIN_COST.Tag = "1;路径费用下线;1;0,90000000;2;"; //ce_MAX_COST.Tag = "1;路径费用上线;1;0,90000000;2;"; if (this.BindingContext[dt].Count > 0) { string strErr = PubFun.getCheckDataStr(paneMain); if (ce_MAX_HOSPITAL_DAYS.Value < ce_MIN_HOSPITAL_DAYS.Value) { strErr += CON_CRLF + "住院天数 上线:" + ce_MAX_HOSPITAL_DAYS.Value.ToString() + " 小于下线" + ce_MIN_HOSPITAL_DAYS.Value.ToString(); } if (ce_MAX_COST.Value < ce_MIN_COST.Value) { strErr += CON_CRLF + "住院天数 上线:" + ce_MAX_COST.Value.ToString() + " 小于下线" + ce_MIN_COST.Value.ToString(); } if (strErr.Trim() != "") { MsgBox.MsgShow(strErr); return(rows); } //System.Collections.ArrayList alSql = new System.Collections.ArrayList(); if (info_DLG.dlgKind != DbOpt.OpenWindowKind.Open) { lbl_id.EditValue = Guid.NewGuid(); lbl_CREATE_DATE.DateTime = DbOpt.GetSysDate(); lbl_EMP_ID_CREATE.Text = InstanceBaseForm.BCurrentUser.EmployeeId.ToString(); // //if (dt.Rows.Count == 0) //{ // DataRow r = dt.NewRow(); // //如果是打开 // r["pym"] = PubStaticFun.GetPYWBM(txt_PATHWAY_NAME.Text.Trim(), 1); // r["wbm"] = PubStaticFun.GetPYWBM(txt_PATHWAY_NAME.Text.Trim(), 1); // r["VERSION"] = txt_PATHWAY_VERSION.Text; // r["DEPTID"] = int.Parse(lookEditCmb2.TextValue.ToString()); // r["MIN_DAYS"] = ce_MIN_HOSPITAL_DAYS.EditValue; // r["MAX_DAYS"] = ce_MAX_HOSPITAL_DAYS.EditValue; // r["MIN_AMOUNT"] = ce_MIN_COST.EditValue; // r["MAX_AMOUNT"] = ce_MAX_COST.EditValue; // r["PATHWAY_ID"] = lbl_id.EditValue; // dt.Rows.Add(r); //} } else { lbl_UPDATE_DATE.DateTime = DbOpt.GetSysDate(); lbl_EMP_ID_UPDATE.Text = InstanceBaseForm.BCurrentUser.EmployeeId.ToString(); //txt_PATHWAY_VERSION.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", dt, "VERSION", true)); //lookEditCmb2.DataBindings.Add(new System.Windows.Forms.Binding("TextValue", dt, "DEPTID", true)); //ce_MIN_HOSPITAL_DAYS.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", dt, "MIN_DAYS", true)); //ce_MAX_HOSPITAL_DAYS.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", dt, "MAX_DAYS", true)); //ce_MIN_COST.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", dt, "MIN_AMOUNT", true)); //ce_MAX_COST.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", dt, "MAX_AMOUNT", true)); } //for (int i = 0; i < gridView1.RowCount; i++) //{ // dt_sybz.Rows[i]["PATHWAY_ID"] = lbl_id.EditValue; //} // update code pengy 2015.6.5 for (int i = 0; i < dt_sybz.Rows.Count; i++) { DataRowState state = dt_sybz.Rows[i].RowState; if (state != DataRowState.Deleted) { dt_sybz.Rows[i]["PATHWAY_ID"] = lbl_id.EditValue; } } ArrayList cmdList = new ArrayList(); txt_PATHWAY_NAME.Text = txt_PATHWAY_NAME.Text.Trim(); this.lbl_WBM.Text = PubStaticFun.GetPYWBM(txt_PATHWAY_NAME.Text.Trim(), 1); this.lbl_PYM.Text = PubStaticFun.GetPYWBM(txt_PATHWAY_NAME.Text.Trim(), 0); this.BindingContext[dt].EndCurrentEdit(); dt.Rows[0]["MONOCONDITION"] = bIsPathWay ? "0" : "1";//单病种 为 1 ,默认 为0 dt.Rows[0]["PATHWAY_ID"] = lbl_id.EditValue; //dt.Rows[0]["DEPTID"] = lookEditCmb2.TextValue; this.BindingContext[dt_sybz].EndCurrentEdit(); if (cmdList != null && cmdList.Count > 0) { rows = DbOpt.Update(new DataTable[] { dt, dt_sybz }, new string[] { sSql, sSql_sybz }, null, cmdList); } else { rows = DbOpt.Update(new DataTable[] { dt, dt_sybz }, new string[] { sSql, sSql_sybz }, null, null); } if (rows > -1) { dt.AcceptChanges(); info_DLG.pKey1 = lbl_id.Text; info_DLG.name = txt_PATHWAY_NAME.Text + "_" + txt_PATHWAY_VERSION.Text; info_DLG.dlgCs10 = "";//复制失效 //this.Text = "路径-" + info_DLG.name + " 信息"; dt_sybz.AcceptChanges(); gridControl1.Tag = dt_sybz.Copy(); this.setEnabledInAddOrOther(EventKind.barSave); this.setParentFormtxx(info_DLG); this.setEnable(EventKind.barSave); } } return(rows); }