public FrmPathTableSelect(DbOpt.InFoDlg infoDlg)
{
//设计器构造代码
InitializeComponent();
//接收从调用窗体传过来的参数列表
this._sPathWayId = infoDlg.pKey1;
}
//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;
}
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="info_DLG1">dlgObj3是代码数据集</param>
public FrmPath_Jbxx(DbOpt.InFoDlg info_DLG1, bool isPathWay)
{
InitializeComponent();
info_DLG = info_DLG1;
bIsPathWay = isPathWay;
this.Load += new EventHandler(Frm_Load);
this.FormClosing += new FormClosingEventHandler(Frm_FormClosing);
this.FormClosed += new FormClosedEventHandler(Frm_Closed);
}
private void bar_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
switch (e.Item.Name)
{
case "barBtAdd":
DbOpt.InFoDlg info_dlg1 = new DbOpt.InFoDlg();
info_dlg1.dlgCs1 = " and PATHWAY_ID is null";
info_dlg1.dlgKind = DbOpt.OpenWindowKind.OpenAdd;
ShowXx(info_dlg1, false);
break;
case "barBtEdit":
this.ShowXx(new DbOpt.InFoDlg(), false); //显示信息
break;
case "barBtPeiZhi":
//gridView1.SetRowExpanded(-1, true);
//gridView1.SetRowExpanded(-2, true);
//gridView1.se
//gridView1.ExpandGroupRow(4, true);
//gridView1.SetRowExpanded
ShowPathWayModyfy();
break;
case "barCode":
new FrmPathWayCode().ShowDialog();
break;
case "barReason":
new FrmPathReason().ShowDialog();
break;
case "barBtTjSh":
case "barBtSh":
case "barBtFb":
case "barBtZf":
SavePath_STATUS(e.Item.Name);
break;
case "barBtDel":
DelPathWay();
break;
default:
gridView1.SetRowExpanded(4, false);
break;
}
}
catch (Exception ex)
{
this.UseHelp("操作[" + e.Item.Name + "]发生错误:" + ex.Message);
}
}
/// <summary>
/// 打开窗口
/// </summary>
/// <param name="info_dlg1">info_dlg1主要指新增,其他情况下面的程序会自动处理－获取</param>
/// /// <param name="isCopy"> 是否复制</param>
private void ShowXx(DbOpt.InFoDlg info_dlg1, bool isCopy)
{
try
{
//gridView1.GroupSummarySortInfo.Clear();
//gridView1.SortInfo.Clear();
gridView1.ActiveFilter.Clear();
#region 处理 info_dlg1
if (info_dlg1.dlgKind != DbOpt.OpenWindowKind.OpenAdd || isCopy) //不是新增或是复制
{
if (gridView1.FocusedRowHandle > -1)
{
info_dlg1 = new DbOpt.InFoDlg();
info_dlg1.dlgKind = DbOpt.OpenWindowKind.Open;
info_dlg1.pKey1 = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "PATHWAY_ID").ToString();
info_dlg1.dlgCs1 = " and PATHWAY_ID='" + info_dlg1.pKey1 + "'";
info_dlg1.name = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "PATHWAY_NAME").ToString(); //名称
//string strdel = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "isDelete").ToString(); //删除
//info_dlg1.dlgdtPosition = gridView1.FocusedRowHandle;
if (isCopy)
{
info_dlg1.dlgCs10 = "Copy";
}
//if (strdel == "1") return;//删除的，不要处理
}
else
{
this.UseHelp("所选择的不是有有效行,请重新选择!");
MsgBox.MsgShow("所选择的不是有效行,请重新选择!");
return;
}
}
#endregion
//if (IsGl == false) info_dlg1.dlgKindReadOnly = true;
info_dlg1.dlgObj = gridView1;
info_dlg1.dlgSqlMainWindow = sSql;
info_dlg1.dlgObj3 = dsDM;
//info_dlg1.dlgCs4 = zuofei.ToString();
//info_dlg1.dlgCs5 = qiYongZuoFei;
if (new FrmPath_Jbxx(info_dlg1, this.bIsPathWay).ShowDialog() == DialogResult.Yes)
{
ShowPathWayModyfy();
}
}
catch (Exception ex)
{
this.UseHelp("发生错误:" + ex.Message);
}
}
/// <summary>
/// 打开路径配置窗口
/// </summary>
private void ShowPathWayModyfy()
{
if (gridView1.FocusedRowHandle > -1)
{
DbOpt.InFoDlg info_dlg1 = new DbOpt.InFoDlg();
info_dlg1.pKey1 = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "PATHWAY_ID").ToString();
info_dlg1.dlgCs1 = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "STATUS").ToString();
info_dlg1.dlgCs2 = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MAX_DAYS").ToString();
info_dlg1.dlgCs3 = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "PATHWAY_NAME").ToString();
info_dlg1.dlgCs4 = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "VERSION").ToString();
info_dlg1.dlgCs5 = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "AMOUNT").ToString();
info_dlg1.pKey2 = bIsPathWay ? "0" : "1";
new FrmPathWayModify
(info_dlg1).ShowDialog();
}
else
{
this.UseHelp("所选择的不是有效行,操作无效");
}
}
