protected void btnAppendItem_Click(object sender, EventArgs e) { if (ViewState["DxpTID"] == null) //先保存头 { string ret, sql; ret = ControlWebValidator.Validate(this.Page, Session["TableName"].ToString()); if (ret.Length > 0) { info.InnerText = ret; return; } ret = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, Session["TableName"].ToString(), out sql); if (ret.Length > 0) { info.InnerText = ret; return; } else { ViewState["DxpTID"] = txtTID.Text; info.InnerText = ""; } } uint maxTid = DBOpt.dbHelper.GetMaxNum("T_DD_TYPICAL_OPT_BODY", "TID"); _sql = "insert into T_DD_TYPICAL_OPT_BODY(HEAD_TID,TID,XH) values(" + ViewState["DxpTID"].ToString() + "," + maxTid.ToString() + "," + Convert.ToString(grvList.Rows.Count + 1) + ")"; DBOpt.dbHelper.ExecuteSql(_sql); initGridView(); }
protected virtual void btnSave_Click(object sender, EventArgs e) { string ret, sql; ret = ControlWebValidator.Validate(this.Page, Session["TableName"].ToString()); if (ret.Length > 0) { info.InnerText = ret; return; } ret = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, Session["TableName"].ToString(), out sql); if (ret.Length > 0) { info.InnerText = ret; return; } else { info.InnerText = ""; WebLog.InsertLog("", "成功", sql); } //JScript.CloseWin("refreshPage"); Response.Redirect(Session["URL"].ToString()); }
protected override void btnSave_Click(object sender, EventArgs e) { string ret, sql; ret = ControlWebValidator.Validate(this.Page, Convert.ToInt16(Session["MainTableId"].ToString())); if (ret.Length > 0) { detail_info.InnerText = ret; return; } ret = CustomControlSave.CustomControlSaveByTableIDReturnS(this.Page, Convert.ToInt16(Session["MainTableId"].ToString()), out sql); if (ret.Length > 0) { detail_info.InnerText = ret; //tdPageMessage.InnerText = ret; return; } else { detail_info.InnerText = ""; //WebLog.InsertLog("", "成功", sql); } //JScript.CloseWin("refreshPage"); Response.Redirect(Session["URL"].ToString()); }
//具体的页面特殊修改,修改修改人名控件、日期控件 //protected void Page_Load(object sender, EventArgs e) //{ // if (Session["sended"] != null) // { // if (Session["sended"].ToString() == "1" && ViewState["BackUrl"] != null) // Response.Redirect(ViewState["BackUrl"].ToString()); // } // if (!IsPostBack) // { // if (Request["BackUrl"] != null) // ViewState["BackUrl"] = Request["BackUrl"]; // else // ViewState["BackUrl"] = null; // object obj = null; // if (Request["PackTypeNo"] != null && Request["CurLinkNo"] != null) //从工作流界面打开,肯定有PackTypeNo和CurLinkNo // { // ViewState["PackTypeNo"] = Request["PackTypeNo"]; // ViewState["CurLinkNo"] = Request["CurLinkNo"]; // if (Request["PackNo"] != null) // { // ViewState["PackNo"] = Request["PackNo"]; // _sql = "select f_recno from DMIS_SYS_DOC where f_packno=" + Request["PackNo"] + " and f_linkno=" + Request["CurLinkNo"]; // ViewState["RecNo"] = DBOpt.dbHelper.ExecuteScalar(_sql); // if (ViewState["RecNo"] == null) // { // //JScript.Alert("业务表的记录号,请联系管理员!"); // return; // } // } // else // ViewState["RecNo"] = -1; // if (Request["CurWorkFlowNo"] != null) ViewState["CurWorkFlowNo"] = Request["CurWorkFlowNo"]; // } // else //从业务表查询界面打开,有PackTypeNo、TableName、RecNo // { // ViewState["PackTypeNo"] = Request["PackTypeNo"]; // ViewState["TableName"] = Request["TableName"]; // ViewState["RecNo"] = Request["RecNo"]; // _sql = "select F_PACKNO from DMIS_SYS_DOC where f_tablename='" + Request["TableName"].ToString() + "' and f_recno=" + ViewState["RecNo"].ToString(); // ViewState["PackNo"] = DBOpt.dbHelper.ExecuteScalar(_sql); // if (ViewState["PackNo"] == null) // { // //JScript.Alert("未找到业务号!"); // return; // } // obj = DBOpt.dbHelper.ExecuteScalar("select f_no from DMIS_SYS_WORKFLOW where f_packno=" + ViewState["PackNo"].ToString() + " and f_status='在办'"); // if (obj != null) //在办的业务 // ViewState["CurWorkFlowNo"] = obj; // else // { // _sql = "select max(f_no) from DMIS_SYS_WORKFLOW where f_packno=" + ViewState["PackNo"].ToString() + " and f_status='完成'"; //归档的业务,最后的环节 // ViewState["CurWorkFlowNo"] = DBOpt.dbHelper.ExecuteScalar(_sql); // } // ViewState["CurLinkNo"] = DBOpt.dbHelper.ExecuteScalar("select f_flowno from DMIS_SYS_WORKFLOW where f_no=" + ViewState["CurWorkFlowNo"].ToString()); // } // //找当前环节对应的文档 // _sql = "select a.f_no,a.f_name,a.f_tablename,a.f_reportfile from dmis_sys_doctype a,DMIS_SYS_WK_LINK_DOCTYPE b where a.f_no=b.F_DOCTYPENO and b.f_packtypeno=" + // ViewState["PackTypeNo"].ToString() + " and b.F_LINKNO=" + ViewState["CurLinkNo"].ToString(); // DataTable temp = DBOpt.dbHelper.GetDataTable(_sql); // if (temp == null || temp.Rows.Count < 1) // { // JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "WkNoDoc").ToString()); //"没有找到对应的文档!" // return; // } // else // { // ViewState["DocTypeNo"] = temp.Rows[0][0]; //文档编号 // ViewState["DocTypeName"] = temp.Rows[0][1]; //文档名称 // ViewState["TableName"] = temp.Rows[0][2]; //文档对应的数据库表名称 // ViewState["REPORT_ID"] = temp.Rows[0][3]; //报表编号 // } // int counts; // btnSave.Enabled = false; // btnSaveClose.Enabled = false; // btnSend.Enabled = false; // btnWithdraw.Enabled = false; // btnAccept.Enabled = false; // btnWithdraw.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmWithdraw").ToString() + "');"); //确定要退回到上一步? // btnAccept.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmAccept").ToString() + "');"); //确定要接单? // if (SetRight.IsAdminitrator(Session["MemberID"].ToString())) //管理员开放修改业务的数据的权限,但不能发送、回退。不参与流转的处理 // { // btnSave.Enabled = true; // btnSaveClose.Enabled = true; // WebWorkFlow.SetAllWebControlEnable(this.Page, Convert.ToInt16(ViewState["PackTypeNo"]), ViewState["TableName"].ToString()); // } // else // { // if (Session["Oper"] != null) // { // if (Convert.ToInt16(Session["Oper"]) > 0) //有权限修改 // { // WebWorkFlow.SetWebControlRight(this.Page, Session["RoleIDs"].ToString(), Convert.ToInt16(ViewState["PackTypeNo"]), Convert.ToInt16(ViewState["CurLinkNo"]), ViewState["TableName"].ToString()); // btnSave.Enabled = true; // btnSaveClose.Enabled = true; // btnSend.Enabled = true; // btnWithdraw.Enabled = true; // //判断文件上传删除的权限,只要能修改委托书基本资料,则可以 // if (hcbSTATION.Enabled) // { // btnAddFile.Enabled = true; // btnDelFile.Enabled = true; // } // //如果是最后一步,则弹出是否要归档的窗口 // string sMainer = ""; // if (ViewState["CurWorkFlowNo"] != null) // obj = DBOpt.dbHelper.ExecuteScalar("select F_RECEIVER from DMIS_SYS_WORKFLOW where F_NO=" + ViewState["CurWorkFlowNo"]); // if (obj != null) // sMainer = obj.ToString(); // else // btnSend.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmSubmit").ToString() + "');"); //确定要提交到下一步?(新建业务时。) // if (sMainer == Session["MemberName"].ToString()) // { // int iCat = -1; // obj = DBOpt.dbHelper.ExecuteScalar("SELECT F_FLOWCAT FROM DMIS_SYS_FLOWLINK WHERE F_NO=" + ViewState["CurLinkNo"]); // if (obj != null) iCat = Convert.ToInt16(obj); // if (iCat == 2) // btnSend.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmFinish").ToString() + "');");//该项目已办理完成,是否要归档? // else // btnSend.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmSubmit").ToString() + "');");//确定要提交到下一步 // } // } // else //待办的状态下处理接单按钮 // { // int flag = -1; //判断是否接单 // obj = DBOpt.dbHelper.ExecuteScalar("select f_working from DMIS_SYS_WORKFLOW where F_NO=" + ViewState["CurWorkFlowNo"]); // if (obj != null) flag = Convert.ToInt16(obj); // if (flag == 0) //待办状态 // { // string zbr = ""; // obj = DBOpt.dbHelper.ExecuteScalar("select f_receiver from DMIS_SYS_WORKFLOW where F_NO=" + ViewState["CurWorkFlowNo"]); // if (obj != null) zbr = obj.ToString().Trim(); // if (zbr == "" || zbr == Session["MemberName"].ToString()) btnAccept.Enabled = true; // } // else if (flag == 1) //从办人员点击进入状态,只能提交 // { // if (WebWorkFlow.IsCongBanRen(ViewState["PackNo"].ToString(), ViewState["CurWorkFlowNo"].ToString(), Session["MemberName"].ToString())) // btnSend.Enabled = true; // } // else // { // btnAccept.Enabled = false; // } // } // } // } // FillDropDownList.FillHtmlCombxByTable(ref hcbSTATION, "T_STATION_PARA", "NAME", "TID"); // initFile(); //显示上传的文件 // string tid; // if (ViewState["PackNo"] != null) // { // //任务单内容,只有一条,故用PACK查找 // if (DBOpt.dbHelper.IsExist("T_BZ_TASK", "PACK_NO=" + ViewState["PackNo"].ToString())) // CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "T_BZ_TASK", "PACK_NO=" + ViewState["PackNo"].ToString()); // if (DBOpt.dbHelper.IsExist("T_BZ_TASK_CHEECK", "PACK_NO=" + ViewState["PackNo"].ToString())) // CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "T_BZ_TASK_CHEECK", "PACK_NO=" + ViewState["PackNo"].ToString()); // //任务处理情况,一个业务有多条记录,查找当前处理的步骤对应的文档是否在业务表是存在记录 // string tableName = DBOpt.dbHelper.ExecuteScalar("select f_tablename from DMIS_SYS_DOC where f_packno=" + ViewState["PackNo"].ToString() + " and f_linkno=" + ViewState["CurLinkNo"].ToString()).ToString(); // tid = DBOpt.dbHelper.ExecuteScalar("select f_recno from DMIS_SYS_DOC where f_packno=" + ViewState["PackNo"].ToString() + " and f_linkno=" + ViewState["CurLinkNo"].ToString()).ToString(); // obj = DBOpt.dbHelper.ExecuteScalar("select f_name from dmis_sys_flowlink where f_no=" + ViewState["CurLinkNo"].ToString()); // if (tableName == "T_BZ_TASK_DISPOSE") //成员处理环节 // { // CustomControlFill.CustomControlFillByTableAndWhere(this.Page, tableName, "TID=" + tid); // tdCurDispoase.InnerText = obj.ToString(); // if (txtF_FLOWNAME.Text == "") txtF_FLOWNAME.Text = obj.ToString(); // } // else //不是处理环节 // { // tdCurDispoase.InnerText = ""; // } // //填充已经完成的处理步骤数据 // initData(); // //2009-3-6 每个业务表保存业务号,故用一个控件来保存就可以了. // if (txtPACK_NO.Text.Trim() == "") txtPACK_NO.Text = ViewState["PackNo"].ToString(); // } // //确定当前步骤是否是第一步 // obj = DBOpt.dbHelper.ExecuteScalar("select f_flowcat from dmis_sys_flowlink where f_no=" + ViewState["CurLinkNo"].ToString()); // if (!obj.ToString().Equals("0")) //不是第一步 // { // //设置初始人名 // if (!SetRight.IsAdminitrator(Session["MemberID"].ToString())) //不是管理员才设置初始人员及日期,否则会把管理员的名称也赋值给相应的控件 // { // string[] name ={ "txtSTARTER", "txtCHECKER", "txtFZR" }; // TextBox txt; // for (int i = 0; i < name.Length; i++) // { // txt = (TextBox)Page.FindControl(name[i]); // if (txt == null) continue; // if (!txt.ReadOnly && txt.Text == "") txt.Text = Session["MemberName"].ToString(); // } // //设置初始日期 // string[] date ={ "wdlSTARTTIME", "wdlCHECK_DATE", "wdlDISPOSE_STARTTIME" }; // WebDate wdl; // for (int i = 0; i < date.Length; i++) // { // wdl = (WebDate)Page.FindControl(date[i]); // if (wdl == null) continue; // if (wdl.Enabled && wdl.Text == "") wdl.setTime(DateTime.Now); // } // } // } // else //开始步骤 // { // if (ViewState["RecNo"].ToString() == "-1") //新增任务书的情况 // { // _sql = "select count(*) from T_BZ_TASK where to_char(STARTTIME,'YYYYMM')='" + DateTime.Now.ToString("yyyyMM") + "'"; // counts = Convert.ToInt16(DBOpt.dbHelper.ExecuteScalar(_sql)) + 1; // txtPH.Text = DateTime.Now.ToString("yyyyMM") + counts.ToString("000"); // txtTID.Text = ""; // txtSTARTER.Text = Session["MemberName"].ToString(); // wdlSTARTTIME.setTime(DateTime.Now); // } // else //第二次打开任务书,则还是第一步的步骤,则显示任务书的数据 // { // CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "T_BZ_TASK", "TID=" + ViewState["RecNo"].ToString()); // } // } // } //} protected virtual void btnSave_Click(object sender, EventArgs e) { string re; re = ControlWebValidator.Validate(this.Page, Session["TableName"].ToString()); if (re != "") { info.InnerText = re; return; } if (CustomControlSave.CustomControlSaveByTableName(this.Page, Session["TableName"].ToString()) < 0) { info.InnerText = GetGlobalResourceObject("WebGlobalResource", "SaveFailMessage").ToString();//"数据保存失败,请联系管理员!" return; } info.InnerText = ""; if (Convert.ToInt16(Session["Oper"]) == 1) { _sql = "select count(*) from DMIS_SYS_DOC where F_PACKNO=" + Session["PackNo"] + " and F_DOCTYPENO=" + Session["DocTypeNo"] + " and F_TABLENAME='" + Session["TableName"] + "' and F_RECNO='" + txtBaseTid.Text + "'"; object obj = DBOpt.dbHelper.ExecuteScalar(_sql); //不允许插入重复文档 if (Convert.ToInt16(obj) != 1) { uint max = DBOpt.dbHelper.GetMaxNum("DMIS_SYS_DOC", "F_NO"); Session["DocTypeName"] = DBOpt.dbHelper.ExecuteScalar("select F_NAME from DMIS_SYS_DOCTYPE where F_NO=" + Session["DocTypeNo"]); _sql = "insert into DMIS_SYS_DOC(F_NO,F_DOCNAME,F_DOCTYPENO,F_CREATEMAN,F_CREATEDATE,F_TABLENAME,F_RECNO,F_PACKNO) values(" + max + ",'" + Session["DocTypeName"] + "'," + Session["DocTypeNo"] + ",'" + Session["MemberName"] + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + Session["TableName"] + "','" + txtBaseTid.Text + "'," + Session["PackNo"] + ")"; if (DBOpt.dbHelper.ExecuteSql(_sql) < 0) //修改时还要插入吗? { } } } }
protected override void btnSave_Click(object sender, EventArgs e) { //先保存数据; string ret, sql; if (ddl周期类型.SelectedItem.Text == "按年") { txt月份数字.Text = ddl1.SelectedItem.Value; txt日期数字.Text = ddl2.SelectedItem.Value; txt发生时候.Text = ddl1.SelectedItem.Value + "月" + ddl2.SelectedItem.Value + "日"; } else if (ddl周期类型.SelectedItem.Text == "按季") { txt月份数字.Text = ddl1.SelectedItem.Value; txt日期数字.Text = ddl2.SelectedItem.Value; txt发生时候.Text = "第" + ddl1.SelectedItem.Value + "个月份" + ddl2.SelectedItem.Value + "日"; } else if (ddl周期类型.SelectedItem.Text == "按月") { txt月份数字.Text = ""; txt日期数字.Text = ddl2.SelectedItem.Value; txt发生时候.Text = ddl2.SelectedItem.Value + "日"; } else if (ddl周期类型.SelectedItem.Text == "按周") { txt月份数字.Text = ""; txt日期数字.Text = ddl2.SelectedItem.Value; txt发生时候.Text = ddl2.SelectedItem.Text; } ret = ControlWebValidator.Validate(this.Page, Session["TableName"].ToString()); if (ret.Length > 0) { tdPageMessage.InnerText = ret; return; } ret = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, Session["TableName"].ToString(), out sql); if (ret.Length > 0) { tdPageMessage.InnerText = ret; //WebLog.InsertLog("", "失败", sql); return; } else { tdPageMessage.InnerText = ""; //WebLog.InsertLog("", "成功", sql); } }
protected void btnSave_Click(object sender, EventArgs e) { string re, sql; re = ControlWebValidator.Validate(this.Page, "T_STATION_SHIFT"); if (re != "") { lblMessage.Text = re; return; } if (CustomControlSave.CustomControlSaveByTableName(this.Page, "T_STATION_SHIFT", out sql) < 0) { lblMessage.Text = (String)GetGlobalResourceObject("WebGlobalResource", "SaveFailMessage"); return; } lblMessage.Text = (String)GetGlobalResourceObject("WebGlobalResource", "SaveSuccessMessage"); }
protected override void btnSave_Click(object sender, EventArgs e) { string ret, sql; ret = ControlWebValidator.Validate(this.Page, Session["TableName"].ToString()); if (ret.Length > 0) { info.InnerText = ret; return; } ret = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, Session["TableName"].ToString(), out sql); if (ret.Length > 0) { info.InnerText = ret; return; } else { info.InnerText = ""; WebLog.InsertLog("", "成功", sql); } }
protected override void btnSave_Click(object sender, EventArgs e) { string ret, sql; ret = ControlWebValidator.Validate(this.Page, Session["TableName"].ToString()); if (ret.Length > 0) { info.InnerText = ret; return; } ret = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, Session["TableName"].ToString(), out sql); if (ret.Length > 0) { info.InnerText = ret; return; } else { ViewState["DxpTID"] = txtTID.Text; info.InnerText = ""; } Response.Redirect(Session["URL"].ToString()); }
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); 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 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 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); } } }