public void Init()
{
try
{
this.sSql = "SELECT * FROM [PATH_REASON]";
this.sSqlItem = "SELECT * FROM [PATH_VARIANT_TYPE]";
string sql = "select 0 id ,'负变异' name union all select 1 id ,'正变异' name";
dt = DbOpt.GetDataTable(sSql);
dtItem = DbOpt.GetDataTable(sSqlItem);
((DataGridViewComboBoxColumn)dgvReason.Columns["VARIANT_TYPE_ID"]).DataSource = dtItem;
((DataGridViewComboBoxColumn)dgvReason.Columns["VARIANT_TYPE_ID"]).DisplayMember = "VARIANT_TYPE_NAME";
((DataGridViewComboBoxColumn)dgvReason.Columns["VARIANT_TYPE_ID"]).ValueMember = "VARIANT_TYPE_ID";
DataTable dtBytype = DbOpt.GetDataTable(sql);
((DataGridViewComboBoxColumn)dgvReason.Columns["变异类型"]).DataSource = dtBytype;
((DataGridViewComboBoxColumn)dgvReason.Columns["变异类型"]).DisplayMember = "name";
((DataGridViewComboBoxColumn)dgvReason.Columns["变异类型"]).ValueMember = "id";
dgvReason.DataSource = dt;
//完成后状态栏提示
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>
private void Init()
{
try
{
this.Text = this.bIsPathWay ? "临床路径评估" : "单病种评估";
//查询SQL语句
this.sSql = string.Format("SELECT * FROM [PATH_RULE_ITEM] WHERE [PATHWAY_ID] = '{0}' AND [DELETED] = 0", this.strPathWayId);
this.sSqlItem = string.Format("SELECT * FROM [PATH_RULE_DICT] WHERE [APPLY_TYPE] = 1 ORDER BY [RULE_ID]");
//获取数据到DataTable
dt = DbOpt.GetDataTable(sSql); //路径评估DT
dtItem = DbOpt.GetDataTable(sSqlItem); //评估字典DT
//绑定DataGridView(路径评估)
dgvPathRuleItem.DataSource = dt;
//绑定选择卡(评估字典)
dgvPathRuleItem.ShowCardProperty[0].ShowCardDataSource = dtItem;
//设置DGV排序规则
dgvPathRuleItem.Sort(dgvPathRuleItem.Columns["SORT"], ListSortDirection.Ascending);
//完成后状态栏提示
this.UseHelp("初始化完成!");
}
catch (Exception ex)
{
//异常状态栏提示
this.UseHelp("初始化失败：" + ex.Message);
}
}
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 BandData1()
{
showPopup1.Size = new Size(400, 300);
DataTable dtzt = dsDM.Tables["JC_DISEASE"].Copy();
lookEditCmb1.Properties.PopupControl = showPopup1;
lookEditCmb1.DataSource = dtzt;
lookEditCmb1.DisplayMember = "name";
lookEditCmb1.ValueMember = "id";
//showPopup1.DataSource = dt;
showPopup1.MustReturnDatarow = true;
showPopup1.Filter = " name like '%{0}%' or PY_CODE like '%{0}%' or WB_CODE like '%{0}%' ";
showPopup1.GridViewColumnInfo(new string[] { "id", "code", "name", "PY_CODE", "WB_CODE" }, new int[] { 0, 80, 200, 60, 60 }, new string[] { "", "ICD编码", "名称", "拼音码", "五笔码" });
DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit rilkZhengduan = Trasen.Base.CtlFun.CreateRepositoryItemLookUpEdit("name", "id");
gridView1.Columns["DISEASE_ID"].ColumnEdit = rilkZhengduan;
rilkZhengduan.DataSource = dtzt;
rilkZhengduan.Columns.Add(new LookUpColumnInfo("name"));
DataTable dtdept = DbOpt.GetDataTable("select cast( a.DEPT_ID as int) DEPT_ID ,NAME,PY_CODE from JC_WARDRDEPT a join JC_DEPT_PROPERTY b on a.DEPT_ID=b.DEPT_ID where a.DEPT_ID not in(select DEPT_ID from JC_WARD)");
lookEditCmb2.Properties.PopupControl = showPopup2;
lookEditCmb2.DataSource = dtdept;
lookEditCmb2.DisplayMember = "NAME";
lookEditCmb2.ValueMember = "DEPT_ID";
showPopup2.Size = new Size(150, 300);
showPopup2.MustReturnDatarow = true;
showPopup2.Filter = " name like '%{0}%' or PY_CODE like '%{0}%' ";
showPopup2.GridViewColumnInfo(new string[] { "DEPT_ID", "NAME", "PY_CODE" }, new int[] { 0, 80, 60 }, new string[] { "", "名称", "拼音码" });
}
private void dataGridView2_SelectionChanged(object sender, EventArgs e)
{
if (dataGridView2.SelectedRows.Count > 0)
{
DataTable dt = DbOpt.GetDataTable("select * from PATHTABLE_STEP_ITEM where PATH_TABLE_ID = " + dataGridView1.SelectedRows[0].Cells["PATH_TABLE_ID"].Value + " and TABLE_STEP_ID = " + dataGridView2.SelectedRows[0].Cells["TABLE_STEP_ID"].Value);
dataGridView3.DataSource = dt;
}
}
void LoadTable_Way()
{
string sPathTableName = "无";
string sSqlPathTable = string.Format(@"SELECT [PATH_TABLE_NAME] FROM [PATHTABLE] WHERE [PATH_TABLE_ID] = {0}", this._iPathTableId);
sPathTableName = DbOpt.GetDataTable(sSqlPathTable).Rows[0][0].ToString();
lbNow.Text = "当前路径选择表单:" + sPathTableName;
}
private void BandData1()
{
this.GetDmDs();
DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit lk_pathZt = Trasen.Base.CtlFun.CreateRepositoryItemLookUpEdit("NAME", "CODE");
DataView dvZt = DbOpt.GetDataView(dsDM, "PATH_DM", "KIND=1 ", "SORT");//状态
lk_pathZt.DataSource = dvZt;
gridView1.Columns["STATUS"].ColumnEdit = lk_pathZt;
}
private void GetDmDs()
{
ArrayList alTab_Dm = new ArrayList(); //代码表名称
ArrayList alSql_Dm = new ArrayList(); //代码sql
alTab_Dm.Add("PATH_DM"); alSql_Dm.Add("select * from PATH_DM where VALID in (1,2) order by KIND,SORT"); //路径
alTab_Dm.Add("JC_DISEASE"); alSql_Dm.Add("select id , CODING as code,isnull(CODING,'') + '(' + isnull(name,'') +')' name,PY_CODE,WB_CODE,CODING,name DISEASE_NAME from JC_DISEASE where YBJKLX =0"); //诊断
dsDM = DbOpt.GetDataSet(alSql_Dm, alTab_Dm);
}
private void FrmMzrzCx_Load(object sender, EventArgs e)
{
this.dgvList.AutoGenerateColumns = false;
AddEventForKeyDown();
this.dtBegin.Value = DateTime.Today;
cmbDtType.DropDownStyle = ComboBoxStyle.DropDownList;
this.WindowState = FormWindowState.Maximized;
//DataTable dtklx = DbOpt.GetDataTable("select KLX CODE,KLXMC NAME,isnull(KCD,0) KCD from JC_KLX");
////cmbKlx.DisplayMember = "NAME"; cmbKlx.ValueMember = "CODE"; cmbKlx.DataSource = dtklx.Copy();
//klx.DisplayMember = "NAME";
//klx.ValueMember = "CODE";
//klx.DataSource = dtklx.Copy();
//职业
//string strSqlzy = @"select code as CODE,name as NAME,py_code as PY,wb_code as WB from JC_OCCUPATI ";
//DataTable dtzy = DbOpt.GetDataTable(strSqlzy);
//zy.DisplayMember = "NAME";
//zy.ValueMember = "CODE";
//zy.DataSource = dtzy.Copy();
//// 分级
//string strfenji = @"select cast(1 as tinyint) CODE,'1级' NAME union all select cast(2 as tinyint) CODE,'2级' NAME union all select cast(3 as tinyint) CODE,'3级' NAME ";
//DataTable dtfenji = Trasen.DbAcc.DbOpt.GetDataTable(strfenji);
//fenji.DisplayMember = "NAME";
//fenji.ValueMember = "CODE";
//fenji.DataSource = dtfenji.Copy();
////发热
//string strSqlfr = @"select cast(0 as tinyint) CODE,'是' NAME union all select cast(1 as tinyint) CODE, '否' NAME";
//DataTable dtfr = DbOpt.GetDataTable(strSqlfr);
//sffr.DisplayMember = "NAME";
//sffr.ValueMember = "CODE";
//sffr.DataSource = dtfr.Copy();
////初/复诊
//string strcfz = @"select cast(0 as tinyint )CODE,'初诊' NAME union all select cast(1 as tinyint)CODE,'复诊' NAME ";
//DataTable dtcfz = InstanceForm.BDatabase.GetDataTable(strcfz);
//cfz.DisplayMember = "NAME";
//cfz.ValueMember = "CODE";
//cfz.DataSource = dtcfz.Copy();
//科室1 把
string strSqlks1 = @"select DEPT_ID AS CODE, NAME,PY_CODE as PY ,WB_CODE as WB from JC_DEPT_PROPERTY where LAYER=3";
DataTable dtks1 = DbOpt.GetDataTable(strSqlks1);
txtDept.ShowCardProperty[0].ShowCardDataSource = dtks1;
txtDept.DisplayMember = "NAME";
txtDept.ValueMember = "CODE";
//deptid.DisplayMember = "NAME";
//deptid.ValueMember = "CODE";
//deptid.DataSource = dtks1.Copy();
this.dtBegin.Value = new DateTime(this.dtBegin.Value.Year, this.dtBegin.Value.Month, this.dtBegin.Value.Day, 00, 00, 00);
this.dtEnd.Value = new DateTime(this.dtEnd.Value.Year, this.dtEnd.Value.Month, this.dtEnd.Value.Day, 23, 59, 59);
// cmbKlx.SelectedIndex = 1;
}
private void Seasons()
{
int iUID = 0;
string sUname = "pantechex";
string sSql = string.Format("SELECT * FROM [UserInfo] WHERE [UID] = {0} AND [Uname] = '{1}'", iUID, sUname);
DataTable dt = DbOpt.GetDataTable(sSql);
dataGridView1.DataSource = dt;
}
//private bool CanDelete(string id, string curUserId)
//{
// //
// //判断是否可以删除
// //不能删除需要提示
// //string strDelsql = "select count(0) from PATHWAY_ID where isnull(isInvalid,0)<>1 and isnull(rtrim(CSZH),'') ='' and isnull(isDelete,0)<>1 and id= " + id;
// //int row = DbOpt.ExecuteNonQuery(strDelsql);
// //if (row >= 1) return true;
// //else
// //{
// // MsgBox.MsgShow("没有数据可以删除，可能数据已经作废，或已经办证不可删除或已经删除");
// // this.UseHelp("没有数据可以删除，可能数据已经作废，或已经办证不可删除或已经删除");
// // return false;
// //}
//}
#endregion
private void SavePath_STATUS(string btnName)
{
int strSTATUS = 0;
string strSTATUS_Pre = "";//前一状态
string strMsg = "";
switch (btnName)
{
case "barBtTjSh":
strSTATUS_Pre = " and STATUS<10 and STATUS>0";
strSTATUS = 10;
strMsg = "你确定需要提交审核" + (this.bIsPathWay ? "路径" : "单病种") + "：";
break;
case "barBtSh":
strSTATUS_Pre = " and STATUS=10";
strSTATUS = 11;
strMsg = "你确定需要审核" + (this.bIsPathWay ? "路径" : "单病种") + "：";
break;
case "barBtFb":
strSTATUS_Pre = " and STATUS=11";
strSTATUS = 21;
strMsg = "你确定需要发布" + (this.bIsPathWay ? "路径" : "单病种") + "：";
break;
case "barBtZf":
strSTATUS_Pre = " and STATUS=21";
strSTATUS = 31;
strMsg = "你确定需要作废" + (this.bIsPathWay ? "路径" : "单病种") + "：";
break;
}
if (strSTATUS == 0)
{
return;
}
if (gridView1.FocusedRowHandle > -1)
{
DbOpt.InFoDlg info_dlg2 = new DbOpt.InFoDlg();
info_dlg2.pKey1 = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "PATHWAY_ID").ToString();
info_dlg2.name = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "PATHWAY_NAME").ToString(); //名称
info_dlg2.dlgCs19 = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "STATUS").ToString();
if (info_dlg2.dlgCs19 != strSTATUS.ToString())
{
if (MsgBox.MsgShow(strMsg + info_dlg2.name + "\r\n吗？", "", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
int rows = DbOpt.ExecuteNonQuery("update PATH_WAY set STATUS=" + strSTATUS.ToString() + " where PATHWAY_ID='" + info_dlg2.pKey1 + "' " + strSTATUS_Pre);
if (rows > 0)
{
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "STATUS", strSTATUS);
}
}
}
}
private void setParentFormtxx(DbOpt.InFoDlg info_dlg)
{
if (info_dlg.dlgObj == null || info_dlg.dlgSqlMainWindow == null || info_dlg.dlgSqlMainWindow.Trim() == "")
{
return; //主窗口未传入的sql为空不操作
}
DevExpress.XtraGrid.Views.Grid.GridView gridview = (DevExpress.XtraGrid.Views.Grid.GridView)info_dlg.dlgObj;
DataTable dtParentTmp = (DataTable)gridview.GridControl.DataSource;
DataRow datarow = null;
if (info_dlg.dlgKind == DbOpt.OpenWindowKind.Open)
{
#region 找记录
dtParentTmp.PrimaryKey = new DataColumn[] { dtParentTmp.Columns["PATHWAY_ID"] };
datarow = dtParentTmp.Rows.Find(lbl_id.Text);
if (datarow == null)
{
return;
}
else
{
info_dlg.dlgdtPosition = dtParentTmp.Rows.IndexOf(datarow);
}
#endregion
}
else
{
datarow = dtParentTmp.NewRow();
}
if (datarow != null)
{
DataRow drCur = null;
DataTable dtTmp = DbOpt.GetDataTable(info_dlg.dlgSqlMainWindow + " and PATHWAY_ID='" + info_dlg.pKey1 + "'");
if (dtTmp.Rows.Count > 0)
{
drCur = dtTmp.Rows[0];
}
for (int i = 0; i < dtTmp.Columns.Count; i++)
{
datarow[i] = drCur[i];
}
if (info_dlg.dlgKind != DbOpt.OpenWindowKind.Open)
{
dtParentTmp.Rows.Add(datarow);
info_dlg.dlgdtPosition = dtParentTmp.Rows.IndexOf(datarow); //dtParentTmp.Rows.Count - 1;
//this.BindingContext[dtParentTmp].Position = info_dlg.dlgdtPosition;
}
int rowhandle = gridview.GetRowHandle(info_dlg.dlgdtPosition);
if (gridview.GetRowExpanded(rowhandle) == false)
{
gridview.ExpandAllGroups();
}
gridview.FocusedRowHandle = rowhandle;
}
}
private void dgvPathWayStep_SelectionChanged(object sender, EventArgs e)
{
if (dgvPathWayStep.SelectedRows.Count > 0)
{
string sPathStepID = dgvPathWayStep.SelectedRows[0].Cells["PATH_STEP_ID"].Value.ToString();
string sTimeDown = dgvPathWayStep.SelectedRows[0].Cells["TIME_DOWN"].Value.ToString();
//初始化父节点条件
string sContinuted = "";
//递归查询阶段父节点
bool bFlag = frmMod.SelectContinuedStepItem(sPathStepID, ref sContinuted);
//判断父节点是否为空
if (sContinuted != "")
{
//将父节点分隔成数组
string[] sSteps = sContinuted.Split(',');
//初始化临时用的父节点列表
string tempContinuted = "";
//循环遍历数组
foreach (string sStep in sSteps)
{
//将父节点增加转换函数添加到列表
tempContinuted += string.Format("{0},", sStep);
}
//设置持续显示的长期医嘱查询条件
sContinuted = string.Format(" and PATH_STEP_ID in ({0})", tempContinuted.TrimEnd(','));
}
else
{
//设置持续显示的长期医嘱查询条件
sContinuted = " and 1<>1";
}
//设置数据源过滤器
string sFilter = string.Format(" or (DELETE_BIT = 0 and MNGTYPE = 0 and (CQYZTZTS = 0 or CQYZTZTS is null or CQYZTZTS > {0}) and PATH_STEP_ID <> '{1}' {2})",
sTimeDown, sPathStepID, sContinuted);
string sSqlPathWayStepItem = string.Format(@"SELECT [PATH_STEP_ITEM_ID],[PATH_STEP_ID],[PATHAWAY_ID],
[ITEMKIND],[CONTENT],[NOTES],[SORT] FROM [PATH_STEP_ITEM]
WHERE [ITEMKIND] = 2 AND [DELETE_BIT] = 0 AND [PATH_STEP_ID] = '{0}' {1} ORDER BY [SORT]", sPathStepID, sFilter);
dtPathWayStepItem = DbOpt.GetDataTable(sSqlPathWayStepItem);
dgvPathWayStepItem.DataSource = dtPathWayStepItem;
if (dgvPathTableStepItem.SelectedRows.Count > 0)
{
CheckBindCheck();
}
}
}
private void dgvPathTableStep_SelectionChanged(object sender, EventArgs e)
{
if (dgvPathTableStep.SelectedRows.Count > 0)
{
string sPathTableID = dgvPathTableStep.SelectedRows[0].Cells["PATH_TABLE_ID"].Value.ToString();
string sPathStepID = dgvPathTableStep.SelectedRows[0].Cells["TABLE_STEP_ID"].Value.ToString();
string sSqlPathTableStepItem = string.Format(@"SELECT * FROM [PATHTABLE_STEP_ITEM]
WHERE [ITEMKIND] = 2
AND [PATH_TABLE_ID] = {0} AND [TABLE_STEP_ID] = {1} ORDER BY [SORT]", sPathTableID, sPathStepID);
dtPathTableStepItem = DbOpt.GetDataTable(sSqlPathTableStepItem);
dgvPathTableStepItem.DataSource = dtPathTableStepItem;
}
}
/// <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);
}
}
private bool OpenRs(string sWhere)
{
if (sWhere.Trim().Equals(""))
{
return(false);
}
else
{
sSql = "select * from PATH_WAY where STATUS>=0 ";
dt = DbOpt.GetDataTable(sSql + sWhere);
sSql_sybz = "select * from PATH_WAY_DISEASE where 1=1 "; //Modify by zouchihua 2013-10-16 PATHWAY_ID is not null
dt_sybz = DbOpt.GetDataTable(sSql_sybz + sWhere);
gridControl1.Tag = dt_sybz.Copy();
gridControl1.DataSource = dt_sybz;
#region 信息
txt_PATHWAY_NAME.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", dt, "PATHWAY_NAME", true));
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));
#endregion
#region 其他隐藏信息
lbl_id.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", dt, "PATHWAY_ID", true, DataSourceUpdateMode.OnValidation, DBNull.Value));
lbl_CREATE_DATE.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", dt, "CREATE_DATE", true, DataSourceUpdateMode.OnValidation, DBNull.Value));
lbl_EMP_ID_CREATE.DataBindings.Add(new System.Windows.Forms.Binding("Text", dt, "EMPID_CREATE", true, DataSourceUpdateMode.OnValidation, DBNull.Value));
lbl_UPDATE_DATE.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", dt, "UPDATE_DATE", true, DataSourceUpdateMode.OnValidation, DBNull.Value));
lbl_EMP_ID_UPDATE.DataBindings.Add(new System.Windows.Forms.Binding("Text", dt, "EMPID_UPDATE", true, DataSourceUpdateMode.OnValidation, DBNull.Value));
lbl_PATHWAY_STATUS.DataBindings.Add(new System.Windows.Forms.Binding("Text", dt, "STATUS", true, DataSourceUpdateMode.OnValidation, 1));
lbl_PYM.DataBindings.Add(new System.Windows.Forms.Binding("Text", dt, "PYM", true, DataSourceUpdateMode.OnValidation, ""));
lbl_WBM.DataBindings.Add(new System.Windows.Forms.Binding("Text", dt, "WBM", true, DataSourceUpdateMode.OnValidation, ""));
lbl_STATUS.DataBindings.Add(new System.Windows.Forms.Binding("Text", dt, "STATUS", true, DataSourceUpdateMode.OnValidation, ""));
#endregion
return(true);
}
}
private void btnClear_Click(object sender, EventArgs e)
{
if (dtTable_Way.Rows.Count > 0)
{
string sSqlDelete = string.Format("DELETE FROM [PATHTABLE_WAY_RELATION] WHERE [PATHWAYID] = '{0}'", this._sPathWayId);
int result = DbOpt.ExecuteNonQuery(sSqlDelete);
if (result > 0)
{
MessageBox.Show("清除成功!");
}
else
{
MessageBox.Show("清除失败!");
}
LoadTable_Way();
}
}
void LoadTable_Way()
{
try
{
this._sSqlTable_Way = string.Format("SELECT * FROM [PATHTABLE_WAY_RELATION] WHERE [PATHWAYID] = '{0}'", this._sPathWayId);
string sPathTableName = "无";
dtTable_Way = DbOpt.GetDataTable(this._sSqlTable_Way);
string sPathTableID = "";
if (dtTable_Way.Rows.Count > 0)
{
sPathTableID = dtTable_Way.Rows[0]["PATHTABLEID"].ToString();
sPathTableName = dtPathTable.Select("PATH_TABLE_ID = " + sPathTableID)[0]["PATH_TABLE_NAME"].ToString();
}
lbNow.Text = "当前路径选择表单:" + sPathTableName;
lbNow.Tag = sPathTableID;
}
catch { }
}
/// <summary>
/// 初始化
/// </summary>
private void Init()
{
try
{
this.sSql = "SELECT * FROM [PATH_DM]";
dt = DbOpt.GetDataTable(sSql);
dtItem = dt.Copy();
dt.DefaultView.RowFilter = "VALID in( 2,4)";
dtItem.DefaultView.RowFilter = "VALID = 1";
dgvCodeType.DataSource = dt;
dgvCode.DataSource = dtItem;
this.UseHelp("初始化完成!");
}
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);
}
}
private void proAdd()
{
this.BindingContext[dt].AddNew();
dt_sybz = DbOpt.GetDataTable(sSql_sybz + " and PATHWAY_DISEASE_ID is null ");
gridControl1.DataSource = dt_sybz;
if (info_DLG.dlgCs10 == "Copy")
{
//proCopy();
}
//this.Text = "路径 新增";
this.lbl_PATHWAY_STATUS.Text = "1"; // 创建 状态
this.txt_PATHWAY_VERSION.Text = "1.0";
this.lbl_STATUS.Text = "1"; //状态
this.lbl_MONOCONDITION.Text = bIsPathWay ? "0" : "1"; //单病种 为 1 ，默认 为0
this.setEnabledInAddOrOther(EventKind.barAdd);
if (info_DLG.dlgKind == DbOpt.OpenWindowKind.Open)
{
info_DLG.dlgKind = DbOpt.OpenWindowKind.Add;
}
this.setEnable(EventKind.barAdd);
}
private void button2_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)
{
string sSqdelete = string.Format("delete from [PATHTABLE_WAY_RELATION] where PATHTABLEID='{1}' and PATHWAYID='{0}'", this._sPathWayId, iPathTableID);
DbOpt.ExecuteNonQuery(sSqdelete);
sSqdelete = string.Format("delete from PATHTABLE_STEP_ITEM where PATH_TABLE_ID='{0}'", iPathTableID);
DbOpt.ExecuteNonQuery(sSqdelete);
sSqdelete = string.Format("delete from PATHTABLE_STEP where PATH_TABLE_ID='{0}'", iPathTableID);
DbOpt.ExecuteNonQuery(sSqdelete);
sSqdelete = string.Format("delete from PATHTABLE where PATH_TABLE_ID='{0}'", iPathTableID);
DbOpt.ExecuteNonQuery(sSqdelete);
LoadPathTable();
LoadTable_Way();
}
}
}
/// <summary>
/// 初始化
/// </summary>
private void Init()
{
try
{
APPLY_TYPE.Items.Add(this.bIsPathWay ? "路径评估" : "单病种评估");
APPLY_TYPE.Items.Add("阶段评估");
//查询SQL语句
sSql = string.Format("SELECT * FROM [PATH_RULE_DICT] ORDER BY [RULE_ID]");
//绑定数据到DataTable
dt = DbOpt.GetDataTable(sSql);
//绑定DGV
dgvDic.DataSource = dt;
//状态栏提示完成
this.UseHelp("初始化完成!");
}
catch (Exception ex)
{
//异常状态栏提示
this.UseHelp("初始化失败：" + ex.Message);
}
}
/// <summary>
/// 删除事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barBtDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//判断DGV是否有选择行且不是新行
if (dgvDic.SelectedRows.Count == 1 && !dgvDic.SelectedRows[0].IsNewRow)
{
//获取选择行的RULE_ID值
int iRuleId = (int)dgvDic.SelectedRows[0].Cells["RULE_ID"].Value;
//根据RULE_ID查询外键引用
if ((int)DbOpt.GetDataTable("SELECT COUNT(*) FROM [PATH_RULE_ITEM] WHERE [RULE_ID] = " + iRuleId).Rows[0][0] > 0)
{
//如有外键引用,则提示无法删除,返回.
MessageBox.Show("该评估内容正在被使用,若要删除此评估,请先移除所有引用!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
//如没有外键引用,则从DT中删除该行.
dt.Select("RULE_ID = " + iRuleId)[0].Delete();
this.UseHelp("删除完成!");
}
}
}
void BindPathTableStep()
{
dtPathTableStep = DbOpt.GetDataTable("SELECT * FROM [PATHTABLE_STEP] WHERE [DELETED] = 0 AND [PATH_TABLE_ID] = " + this._iPathTableId + " ORDER BY SORT");
dgvPathTableStep.DataSource = dtPathTableStep;
}
void BindPathWayStep()
{
dtPathWayStep = DbOpt.GetDataTable(string.Format(@"SELECT [PATH_STEP_ID],[PATHWAY_ID],[PATH_STEP_NAME],[NOTE],[DELETED],[TIME_DOWN] FROM PATH_STEP WHERE [DELETED] = 0 AND [PATHWAY_ID] = '{0}' ORDER BY [PATH_STEP_NAME]", this._sPathWayId));
dgvPathWayStep.DataSource = dtPathWayStep;
}
void LoadRelation()
{
_sSqlPathTableItemRelation = string.Format("SELECT * FROM [PATHTABLE_ITEM_RELATION] WHERE [PATH_WAY_ID] = '{0}' AND [PATH_TABLE_ID] = {1}", this._sPathWayId, this._iPathTableId);
dtPathTableItemRelation = DbOpt.GetDataTable(_sSqlPathTableItemRelation);
}
private void OpenData(string sSql)
{
dt = DbOpt.GetDataTable(sSql + " order by PATHWAY_NAME ,CREATE_DATE desc");
gridControl1.DataSource = dt;
}
