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("设置表单失败.!");
}
}
}
}
//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 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();
}
}
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();
}
}
}
