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