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