protected void btnSave_Click(object sender, EventArgs e) { string re = ""; //系统管理员只修改所有文档对就的业务表的数据,但不产生新的记录 if (SetRight.IsAdminitrator(Session["MemberID"].ToString())) { DataTable doc = DBOpt.dbHelper.GetDataTable("select distinct f_tablename,f_recno from dmis_sys_doc where f_packno=" + ViewState["PackNo"].ToString()); for (int i = 0; i < doc.Rows.Count; i++) { if (doc.Rows[i][0].ToString() == "T_BZ_TASK_DISPOSE" && txtDISPOSE_TID.Text == "") { continue; } if (doc.Rows[i][0].ToString() == "T_BZ_TASK" && txtTID.Text == "") { continue; } if (doc.Rows[i][0].ToString() == "T_BZ_TASK_CHEECK" && txtCHECK_TID.Text == "") { continue; } re = ControlWebValidator.Validate(this.Page, doc.Rows[i][0].ToString()); if (re != "") { JScript.Alert(re); tdMessage.InnerText = re; return; } re = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, doc.Rows[i][0].ToString()); if (re != "") { JScript.Alert(re); tdMessage.InnerText = re; return; } tdMessage.InnerText = ""; } return; } bool isAdd = false; bool isStartLink = false; //是否起始环节 object obj; TextBox txtPrimaryField = null; Control con; //此业务对应的所有数据库表,一个环节只能保存一个数据库表 DataTable tables = DBOpt.dbHelper.GetDataTable("select f_tablename from dmis_sys_doctype where f_doccat='业务表' and f_packtypeno=" + ViewState["PackTypeNo"].ToString()); for (int i = 0; i < tables.Rows.Count; i++) { if (tables.Rows[i][0].ToString() == ViewState["TableName"].ToString()) { con = Page.FindControl(DBOpt.dbHelper.ExecuteScalar("select a.custom_control_name from DMIS_SYS_COLUMNS a,DMIS_SYS_TABLES b where isprimary=1 and a.table_id=b.id and b.name='" + ViewState["TableName"].ToString() + "'").ToString()); if (con == null) { //JScript.Alert("对不起!无法找到表" + ViewState["TableName"].ToString() + "的主键对应的控件!"); //tdMessage.InnerText = "对不起!无法找到表" + ViewState["TableName"].ToString() + "的主键对应的控件!"; return; } txtPrimaryField = (TextBox)con; break; } } if (txtPrimaryField.Text == "") { isAdd = true; } //保存业务表的数据 re = ControlWebValidator.Validate(this.Page, ViewState["TableName"].ToString()); if (re != "") { JScript.Alert(re); tdMessage.InnerText = re; return; } tdMessage.InnerText = ""; re = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, ViewState["TableName"].ToString()); if (re != "") { JScript.Alert(re); tdMessage.InnerText = re; return; } tdMessage.InnerText = ""; _sql = "select f_flowcat from dmis_sys_flowlink where f_no=" + ViewState["CurLinkNo"].ToString(); obj = DBOpt.dbHelper.ExecuteScalar(_sql); if (obj != null && obj.ToString() == "0") { isStartLink = true; } //新建业务数据并且是起始环节时,创建工作流数据 if (isAdd && isStartLink) { uint packNo = 0; string station = ""; string startTime, endTime; startTime = ""; endTime = ""; station = hcbSTATION.SelectedText; if (wdlSTARTTIME.getTime().ToString("yyyy-MM-dd") != "1900-01-01" && wdlENDTIME.getTime().ToString("yyyy-MM-dd") != "1900-01-01") { startTime = wdlSTARTTIME.getTime().ToString("dd-MM-yyyy HH:mm"); endTime = wdlENDTIME.getTime().ToString("dd-MM-yyyy HH:mm"); } if (WebWorkFlow.CreatePack(Convert.ToInt32(ViewState["PackTypeNo"]), txtCONTENT.Text, Session["MemberName"].ToString(), ref packNo, station, startTime, endTime) < 0) { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "WkInsertInstanceFailMessage").ToString()); //创建业务数据失败! tdMessage.InnerText = GetGlobalResourceObject("WebGlobalResource", "WkInsertInstanceFailMessage").ToString(); return; } tdMessage.InnerText = ""; int iFirstFlowNo = -1; int iWorkFlowNo = -1; iFirstFlowNo = Convert.ToInt16(DBOpt.dbHelper.ExecuteScalar("select F_NO from DMIS_SYS_FLOWLINK where F_PACKTYPENO=" + ViewState["PackTypeNo"] + " and F_FLOWCAT=0")); bool bCreated = WebWorkFlow.CreateFlow(Convert.ToInt16(packNo), ref iWorkFlowNo, Session["MemberName"].ToString(), iFirstFlowNo, "", Session["MemberName"].ToString(), "", txtPrimaryField.Text); if (!bCreated) { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "WkInsertTaskFailMessage").ToString());//创建工作流数据失败! tdMessage.InnerText = GetGlobalResourceObject("WebGlobalResource", "WkInsertTaskFailMessage").ToString(); return; } tdMessage.InnerText = ""; ViewState["PackNo"] = packNo; ViewState["CurWorkFlowNo"] = iWorkFlowNo; ViewState["CurLinkNo"] = iFirstFlowNo; ViewState["RecNo"] = txtPrimaryField.Text; //增加PACK_NO值 //_sql = "update " + ViewState["TableName"].ToString() + " set PACK_NO=" + packNo + " where TID=" + txtPrimaryField.Text; //DBOpt.dbHelper.ExecuteSql(_sql); } //if (isAdd) //增加总结验收时的情况。 //{ //2009-3-6所有步骤都要更新业务表中的PACK_NO,故保存时,都保存一下当前业务表中相应的业务号. _sql = "update " + ViewState["TableName"].ToString() + " set PACK_NO=" + ViewState["PackNo"].ToString() + " where TID=" + txtPrimaryField.Text; DBOpt.dbHelper.ExecuteSql(_sql); //} //只有用户保存了,确认它接收此任务了。 //修改已经接收的状态,使此业务不能抽回 if (ViewState["CurWorkFlowNo"] != null && Convert.ToInt16(ViewState["CurWorkFlowNo"]) > 0) { obj = DBOpt.dbHelper.ExecuteScalar("select f_working from dmis_sys_workflow where f_no=" + ViewState["CurWorkFlowNo"]); if (obj == null || Convert.ToInt16(obj) == 0) //已经接收的,允许再接收 { _sql = "update dmis_sys_workflow set f_working=1,f_receiver='" + Session["MemberName"].ToString() + "',f_receivedate='" + DateTime.Now.ToString("dd-MM-yyyy HH:mm") + "' where f_no=" + ViewState["CurWorkFlowNo"]; DBOpt.dbHelper.ExecuteSql(_sql); } } }
protected void btnSave_Click(object sender, EventArgs e) { string re; //系统管理员只修改所有文档对就的业务表的数据,但不产生新的记录。 //2009-3-25 用户要求修改缺陷单的级别时,同时要修改业务流任务的描述。 if (SetRight.IsAdminitrator(Session["MemberID"].ToString())) { DataTable doc = DBOpt.dbHelper.GetDataTable("select distinct f_tablename,f_recno from dmis_sys_doc where f_packno=" + ViewState["PackNo"].ToString()); for (int i = 0; i < doc.Rows.Count; i++) { re = ControlWebValidator.Validate(this.Page, doc.Rows[i][0].ToString()); if (re != "") { JScript.Alert(re); detail_info.InnerText = re; return; } re = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, doc.Rows[i][0].ToString()); if (re != "") { JScript.Alert(re); detail_info.InnerText = re; return; } else { detail_info.InnerText = ""; } } return; } re = ControlWebValidator.Validate(this.Page, ViewState["TableName"].ToString()); if (re != "") { JScript.Alert(re); detail_info.InnerText = re; return; } re = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, ViewState["TableName"].ToString()); if (re != "") { JScript.Alert(re); detail_info.InnerText = re; return; } detail_info.InnerText = ""; //第一次保存时,生成工作流数据 if (txtPACK_NO.Text.Trim() == "") //这才是判断标准 { uint packNo = 0; string station = hcbSTATION.SelectedText; string planStarttime = wdlDATEM.getTime().ToString("dd-MM-yyyy HH:mm"); double planHours = 0; string desc = "(" + txtPH.Text + ")" + txtCOMMAND_CONTENT.Text.Trim(); //任务描述 string planEndtime = wdlDATEM.getTime().AddHours(planHours).ToString("dd-MM-yyyy HH:mm"); if (WebWorkFlow.CreatePack(Convert.ToInt32(ViewState["PackTypeNo"]), desc, Session["MemberName"].ToString(), ref packNo, station, planStarttime, planEndtime) < 0) { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "WkInsertInstanceFailMessage").ToString()); //创建业务数据失败! detail_info.InnerText = GetGlobalResourceObject("WebGlobalResource", "WkInsertInstanceFailMessage").ToString(); return; } int iFirstFlowNo = -1; int iWorkFlowNo = -1; iFirstFlowNo = Convert.ToInt16(DBOpt.dbHelper.ExecuteScalar("select F_NO from DMIS_SYS_FLOWLINK where F_PACKTYPENO=" + ViewState["PackTypeNo"] + " and F_FLOWCAT=0")); bool bCreated = WebWorkFlow.CreateFlow(Convert.ToInt16(packNo), ref iWorkFlowNo, Session["MemberName"].ToString(), iFirstFlowNo, "", Session["MemberName"].ToString(), "", txtTID.Text); //第一次新建流程时,传接从办人的姓名列表 if (!bCreated) { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "WkInsertTaskFailMessage").ToString());//创建工作流数据失败! detail_info.InnerText = GetGlobalResourceObject("WebGlobalResource", "WkInsertTaskFailMessage").ToString(); return; } ViewState["PackNo"] = packNo; ViewState["CurWorkFlowNo"] = iWorkFlowNo; ViewState["CurLinkNo"] = iFirstFlowNo; ViewState["RecNo"] = txtTID.Text; //增加PACK_NO值 _sql = "update " + ViewState["TableName"].ToString() + " set PACK_NO=" + packNo + " where TID=" + txtTID.Text; if (DBOpt.dbHelper.ExecuteSql(_sql) > 0) { txtPACK_NO.Text = packNo.ToString(); } } //只有用户保存了,确认它接收此任务了。 //修改已经接收的状态,使此业务不能抽回 if (ViewState["CurWorkFlowNo"] != null && Convert.ToInt16(ViewState["CurWorkFlowNo"]) > 0) { object obj = DBOpt.dbHelper.ExecuteScalar("select f_working from dmis_sys_workflow where f_no=" + ViewState["CurWorkFlowNo"]); if (obj == null || Convert.ToInt16(obj) == 0) //已经接收的,允许再接收 { _sql = "update dmis_sys_workflow set f_working=1,f_receiver='" + Session["MemberName"].ToString() + "',f_receivedate='" + DateTime.Now.ToString("dd-MM-yyyy HH:mm") + "' where f_no=" + ViewState["CurWorkFlowNo"]; DBOpt.dbHelper.ExecuteSql(_sql); } } }
protected void btnSave_Click(object sender, EventArgs e) { string re; //系统管理员只修改所有文档对就的业务表的数据,但不产生新的记录。 //2009-3-25 用户要求修改缺陷单的级别时,同时要修改业务流任务的描述。 if (SetRight.IsAdminitrator(Session["MemberID"].ToString())) { DataTable doc = DBOpt.dbHelper.GetDataTable("select distinct f_tablename,f_recno from dmis_sys_doc where f_packno=" + ViewState["PackNo"].ToString()); for (int i = 0; i < doc.Rows.Count; i++) { re = ControlWebValidator.Validate(this.Page, doc.Rows[i][0].ToString()); if (re != "") { JScript.Alert(re); tdMessage.InnerText = re; return; } re = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, doc.Rows[i][0].ToString()); if (re != "") { JScript.Alert(re); tdMessage.InnerText = re; return; } else { //2009-3-25 修改业务流任务的描述 int packNO; if (ViewState["PackNo"] != null && int.TryParse(ViewState["PackNo"].ToString(), out packNO)) { string station = ""; string planStarttime = wdlDD_DATEM.getTime().ToString("dd-MM-yyyy HH:mm"); double planHours = 0; if (ddlDD_TYPE.SelectedItem.Text == "Commonly") { planHours = Convert.ToDouble(ConfigurationManager.AppSettings["Commonly"]); } else if (ddlDD_TYPE.SelectedItem.Text == "Importance") { planHours = Convert.ToDouble(ConfigurationManager.AppSettings["Importance"]); } else if (ddlDD_TYPE.SelectedItem.Text == "Urgency") { planHours = Convert.ToDouble(ConfigurationManager.AppSettings["Urgency"]); } string desc = "(" + ddlDD_TYPE.SelectedItem.Text + txtDD_PH.Text + ")" + txtDD_FAULT.Text.Trim(); //任务描述 desc = desc.Replace('\'', '‘'); desc = desc.Replace('"', '“'); string planEndtime = wdlDD_DATEM.getTime().AddHours(planHours).ToString("dd-MM-yyyy HH:mm"); if (ddlDD_STATION.SelectedItem != null) { station = ddlDD_STATION.SelectedItem.Text; } _sql = "update DMIS_SYS_PACK set f_desc='" + desc + "',plan_endtime='" + planEndtime + "' where f_no=" + packNO; DBOpt.dbHelper.ExecuteSql(_sql); } tdMessage.InnerText = ""; } } return; } //其它人员处理业务时保存 bool isAdd = false; if (txtTID.Text == "") { isAdd = true; //判断是否是新增的,保存之后,txtTID会有值,故在此判断 } re = ControlWebValidator.Validate(this.Page, ViewState["TableName"].ToString()); if (re != "") { JScript.Alert(re); tdMessage.InnerText = re; return; } re = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, ViewState["TableName"].ToString()); if (re != "") { JScript.Alert(re); tdMessage.InnerText = re; return; } tdMessage.InnerText = ""; //第一次保存时,生成工作流数据 if (isAdd) { uint packNo = 0; string station = ""; string planStarttime = wdlDD_DATEM.getTime().ToString("dd-MM-yyyy HH:mm"); double planHours = 0; if (ddlDD_TYPE.SelectedItem.Text == "Commonly") { planHours = Convert.ToDouble(ConfigurationManager.AppSettings["Commonly"]); } else if (ddlDD_TYPE.SelectedItem.Text == "Importance") { planHours = Convert.ToDouble(ConfigurationManager.AppSettings["Importance"]); } else if (ddlDD_TYPE.SelectedItem.Text == "Urgency") { planHours = Convert.ToDouble(ConfigurationManager.AppSettings["Urgency"]); } string desc = "(" + ddlDD_TYPE.SelectedItem.Text + txtDD_PH.Text + ")" + txtDD_FAULT.Text.Trim(); //任务描述 string planEndtime = wdlDD_DATEM.getTime().AddHours(planHours).ToString("dd-MM-yyyy HH:mm"); if (ddlDD_STATION.SelectedItem != null) { station = ddlDD_STATION.SelectedItem.Text; } if (WebWorkFlow.CreatePack(Convert.ToInt32(ViewState["PackTypeNo"]), desc, Session["MemberName"].ToString(), ref packNo, station, planStarttime, planEndtime) < 0) { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "WkInsertInstanceFailMessage").ToString()); //创建业务数据失败! tdMessage.InnerText = GetGlobalResourceObject("WebGlobalResource", "WkInsertInstanceFailMessage").ToString(); return; } int iFirstFlowNo = -1; int iWorkFlowNo = -1; iFirstFlowNo = Convert.ToInt16(DBOpt.dbHelper.ExecuteScalar("select F_NO from DMIS_SYS_FLOWLINK where F_PACKTYPENO=" + ViewState["PackTypeNo"] + " and F_FLOWCAT=0")); bool bCreated = WebWorkFlow.CreateFlow(Convert.ToInt16(packNo), ref iWorkFlowNo, Session["MemberName"].ToString(), iFirstFlowNo, "", Session["MemberName"].ToString(), "", txtTID.Text); //第一次新建流程时,传接从办人的姓名列表 if (!bCreated) { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "WkInsertTaskFailMessage").ToString());//创建工作流数据失败! tdMessage.InnerText = GetGlobalResourceObject("WebGlobalResource", "WkInsertTaskFailMessage").ToString(); return; } ViewState["PackNo"] = packNo; ViewState["CurWorkFlowNo"] = iWorkFlowNo; ViewState["CurLinkNo"] = iFirstFlowNo; ViewState["RecNo"] = txtTID.Text; //增加PACK_NO值 _sql = "update " + ViewState["TableName"].ToString() + " set PACK_NO=" + packNo + " where TID=" + txtTID.Text; DBOpt.dbHelper.ExecuteSql(_sql); } //只有用户保存了,确认它接收此任务了。 //修改已经接收的状态,使此业务不能抽回 if (ViewState["CurWorkFlowNo"] != null && Convert.ToInt16(ViewState["CurWorkFlowNo"]) > 0) { object obj = DBOpt.dbHelper.ExecuteScalar("select f_working from dmis_sys_workflow where f_no=" + ViewState["CurWorkFlowNo"]); if (obj == null || Convert.ToInt16(obj) == 0) //已经接收的,允许再接收 { _sql = "update dmis_sys_workflow set f_working=1,f_receiver='" + Session["MemberName"].ToString() + "',f_receivedate='" + DateTime.Now.ToString("dd-MM-yyyy HH:mm") + "' where f_no=" + ViewState["CurWorkFlowNo"]; DBOpt.dbHelper.ExecuteSql(_sql); } } }
protected override void btnSave_Click(object sender, EventArgs e) { string re; //系统管理员只修改所有文档对就的业务表的数据,但不产生新的记录 if (SetRight.IsAdminitrator(Session["MemberID"].ToString())) { DataTable doc = DBOpt.dbHelper.GetDataTable("select distinct f_tablename,f_recno from dmis_sys_doc where f_packno=" + ViewState["PackNo"].ToString()); for (int i = 0; i < doc.Rows.Count; i++) { re = ControlWebValidator.Validate(this.Page, doc.Rows[i][0].ToString()); if (re != "") { JScript.Alert(re); tdMessage.InnerText = re; return; } re = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, doc.Rows[i][0].ToString()); if (re != "") { JScript.Alert(re); tdMessage.InnerText = re; return; } tdMessage.InnerText = ""; } return; } bool isAdd = false; if (txtTID.Text == "") { isAdd = true; //判断是否是新增的,保存之后,txtTID会有值,故在此判断 } re = ControlWebValidator.Validate(this.Page, ViewState["TableName"].ToString()); if (re != "") { JScript.Alert(re); tdMessage.InnerText = re; return; } re = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, ViewState["TableName"].ToString()); if (re != "") { JScript.Alert(re); tdMessage.InnerText = re; return; } tdMessage.InnerText = ""; //第一次保存时,生成工作流数据 if (isAdd) { uint packNo = 0; string station = ""; //if (hcb厂站.SelectedItem != null) station = hcb厂站.SelectedItem.Text; station = hcbSTATION.SelectedText; // string planStarttime = wdlSTARTDATE.getTime().ToString("dd-MM-yyyy HH:mm"); string planEndtime = wdlENDDATE.getTime().ToString("dd-MM-yyyy HH:mm"); if (WebWorkFlow.CreatePack(Convert.ToInt32(ViewState["PackTypeNo"]), "(" + txtPH.Text + ")" + txtDEVICE_NAME.Text, Session["MemberName"].ToString(), ref packNo, station, planStarttime, planEndtime) < 0) { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "WkInsertInstanceFailMessage").ToString()); //创建业务数据失败! tdMessage.InnerText = GetGlobalResourceObject("WebGlobalResource", "WkInsertInstanceFailMessage").ToString(); return; } int iFirstFlowNo = -1; int iWorkFlowNo = -1; iFirstFlowNo = Convert.ToInt16(DBOpt.dbHelper.ExecuteScalar("select F_NO from DMIS_SYS_FLOWLINK where F_PACKTYPENO=" + ViewState["PackTypeNo"] + " and F_FLOWCAT=0")); bool bCreated = WebWorkFlow.CreateFlow(Convert.ToInt16(packNo), ref iWorkFlowNo, Session["MemberName"].ToString(), iFirstFlowNo, "", Session["MemberName"].ToString(), "", txtTID.Text); //第一次新建流程时,传接从办人的姓名列表 if (!bCreated) { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "WkInsertTaskFailMessage").ToString());//创建工作流数据失败! tdMessage.InnerText = GetGlobalResourceObject("WebGlobalResource", "WkInsertTaskFailMessage").ToString(); return; } ViewState["PackNo"] = packNo; ViewState["CurWorkFlowNo"] = iWorkFlowNo; ViewState["CurLinkNo"] = iFirstFlowNo; ViewState["RecNo"] = txtTID.Text; //增加PACK_NO值 _sql = "update " + ViewState["TableName"].ToString() + " set PACK_NO=" + packNo + " where TID=" + txtTID.Text; DBOpt.dbHelper.ExecuteSql(_sql); } //只有用户保存了,确认它接收此任务了。 //修改已经接收的状态,使此业务不能抽回 if (ViewState["CurWorkFlowNo"] != null && Convert.ToInt16(ViewState["CurWorkFlowNo"]) > 0) { object obj = DBOpt.dbHelper.ExecuteScalar("select f_working from dmis_sys_workflow where f_no=" + ViewState["CurWorkFlowNo"]); if (obj == null || Convert.ToInt16(obj) == 0) //已经接收的,允许再接收 { _sql = "update dmis_sys_workflow set f_working=1,f_receiver='" + Session["MemberName"].ToString() + "',f_receivedate='" + DateTime.Now.ToString("dd-MM-yyyy HH:mm") + "' where f_no=" + ViewState["CurWorkFlowNo"]; DBOpt.dbHelper.ExecuteSql(_sql); } } }