protected void btnOK_Click(object sender, EventArgs e) { if (txtREASON.Text == "") { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "ItemNotNull").ToString()); //某项不允许为空 return; } //先保存操作记录 string re = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, "DMIS_SYS_WK_OPT_HISTORY"); if (re != "") { JScript.Alert(re); return; } //再设置业务的状态 string sql; if (txtOPT_TYPE.Text == "挂起") { sql = "update dmis_sys_pack set f_status='3' where f_no=" + txtPACKNO.Text; } else { sql = "update dmis_sys_pack set f_status='1' where f_no=" + txtPACKNO.Text; } if (DBOpt.dbHelper.ExecuteSql(sql) > 0) { JScript.CloseWin("refreshPage"); } }
protected void btnOk_Click(object sender, EventArgs e) { StringBuilder sorts = new StringBuilder(); for (int i = 0; i < ((DataTable)ViewState["dtSelect"]).Rows.Count; i++) { if (((DataTable)ViewState["dtSelect"]).Rows[i]["ORDER_TYPE"].ToString() == GetGlobalResourceObject("WebGlobalResource", "ComSetSort001").ToString())//要翻译 { sorts.Append(((DataTable)ViewState["dtSelect"]).Rows[i]["NAME"].ToString() + " ASC,"); } else { sorts.Append(((DataTable)ViewState["dtSelect"]).Rows[i]["NAME"].ToString() + " DESC,"); } } if (sorts.Length < 1) { JScript.Alert(this.Page, GetGlobalResourceObject("WebGlobalResource", "ComSetSort003").ToString());//要翻译 return; } else { sorts.Remove(sorts.Length - 1, 1); //除去最后一个, //refreshPage Session["CustomOrder"] = sorts.ToString(); JScript.CloseWin("refreshPage"); //JScript.RefreshParent(Session["Url"].ToString()); //sorts.Remove(sorts.Length - 1, 1); //除去最后一个, //Session["SortBackURL"] = Session["SortBackURL"].ToString() + "&SortOrders=" + sorts.ToString(); //利用此传递参数在返回页中确定是从左边的树形菜单找开的页面,还是从排序返回的页面。 //Response.Redirect(Session["SortBackURL"].ToString()); } }
protected void btnOk_Click(object sender, EventArgs e) { if (grvList.SelectedIndex < 0) { //JScript.Alert("请先选择某一典型票!"); return; } int no = 1; uint maxTid, maxBodyTid; _sql = "select count(*) from T_DD_TERMWISE_OPT_HEAD where to_char(DATEM,'YYYY')='" + DateTime.Now.ToString("yyyy") + "'"; int counts = Convert.ToInt16(DBOpt.dbHelper.ExecuteScalar(_sql)) + 1; string ph = DateTime.Now.ToString("yyyy") + counts.ToString("0000"); maxTid = DBOpt.dbHelper.GetMaxNum("T_DD_TERMWISE_OPT_HEAD", "TID"); maxBodyTid = DBOpt.dbHelper.GetMaxNum("T_DD_TERMWISE_OPT_BODY", "TID"); _sql = "insert into T_DD_TERMWISE_OPT_HEAD(TID,TASK,DATEM,YPR,PH,STATION) values(" + maxTid.ToString() + ",'" + grvList.SelectedRow.Cells[2].Text + "'," + "TO_DATE('" + DateTime.Now.ToString("yyyy-MM-dd") + "','YYYY-MM-DD'),'" + Session["MemberName"].ToString() + "','" + ph + "','" + ddlStation.SelectedItem.Text + "')"; if (DBOpt.dbHelper.ExecuteSql(_sql) > 0) { DataTable dt = DBOpt.dbHelper.GetDataTable("select * from T_DD_TYPICAL_OPT_BODY where HEAD_TID=" + grvList.SelectedDataKey[0].ToString()); for (int i = 0; i < dt.Rows.Count; i++) { _sql = "insert into T_DD_TERMWISE_OPT_BODY(HEAD_TID,TID,UNIT,XH,CONTENT) values(" + maxTid.ToString() + "," + maxBodyTid.ToString() + ",'" + dt.Rows[i]["UNIT"].ToString() + "'," + no.ToString() + ",'" + dt.Rows[i]["CONTENT"].ToString() + "')"; if (DBOpt.dbHelper.ExecuteSql(_sql) > 0) { maxBodyTid++; no++; } } } ////从界面上无法知道是否从典型票中,只能从数据库中来判断 ////如果选择了典型票,则T_DD_TERMWISE_OPT_HEAD有一条新记录,但PACK_NO没有值。 ////需要取值此票,马上把相应的PACK_NO赋上,再显示此票 //string tid, pack_no; //_sql = "select max(TID) from T_DD_TERMWISE_OPT_HEAD"; //object obj = DBOpt.dbHelper.ExecuteScalar(_sql); //if (obj == null) return; //tid = obj.ToString(); //_sql = "select PACK_NO from T_DD_TERMWISE_OPT_HEAD where TID=" + tid; //obj = DBOpt.dbHelper.ExecuteScalar(_sql); //if (obj != null) return; //有业务编号,则不处理。 //显示票内容 Session["RecNo"] = maxTid; //CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "T_DD_TERMWISE_OPT_HEAD", "TID=" + ViewState["RecNo"].ToString()); //initGridView();//取操作步骤 JScript.CloseWin("refreshPage"); }
protected void btnOK_Click(object sender, EventArgs e) { if (txtREASON.Text == "") { tdMessage.InnerText = "请填写退回理由!"; return; } if (WebWorkFlow.Withdraw(ViewState["PackNo"].ToString(), ViewState["CurWorkFlowNo"].ToString(), txtREASON.Text, Session["MemberName"].ToString())) { Session["sended"] = 1; JScript.CloseWin("refreshPage"); } else { tdMessage.InnerText = "退回不成功,请联系管理员!"; } }
protected void btnOk_Click(object sender, EventArgs e) { if (rblMember.SelectedItem == null) { tdMessage.InnerText = GetGlobalResourceObject("WebGlobalResource", "ItemNotNull").ToString(); // "请选择要改派的人员!"; return; } string packTypeNo, packTypeName; packTypeNo = DBOpt.dbHelper.ExecuteScalar("select f_packtypeno from dmis_sys_pack where f_no=" + ViewState["InstanceID"]).ToString(); packTypeName = DBOpt.dbHelper.ExecuteScalar("select f_packname from dmis_sys_pack where f_no=" + ViewState["InstanceID"]).ToString(); string[] sqls = new string[2]; sqls[0] = "update dmis_sys_workflow set f_receiver ='" + rblMember.SelectedItem.Text + "',f_receivedate='" + DateTime.Now.ToString("yyyy-MM-dd") + "' where f_no=" + ViewState["CurWorkFlowNo"].ToString(); sqls[1] = "update dmis_sys_memberstatus set f_receiver='" + rblMember.SelectedItem.Text + "',f_receivedate='" + DateTime.Now.ToString("yyyy-MM-dd") + "' where f_packno=" + ViewState["InstanceID"].ToString() + " and f_workflowno=" + ViewState["CurWorkFlowNo"] + " and f_receiver='" + txtMEMBER_NAME.Text + "'"; if (DBOpt.dbHelper.ExecuteSqlWithTransaction(sqls) > 0) { uint maxTid = DBOpt.dbHelper.GetMaxNum("DMIS_SYS_WK_OPT_HISTORY", "tid"); string reason = "将任务:" + tdPackDesc.InnerText + " 由 " + txtMEMBER_NAME.Text + " 改派给 " + rblMember.SelectedItem.Text; _sql = "insert into DMIS_SYS_WK_OPT_HISTORY(tid,packno,opt_type,datem,member_name,reason,F_PACKTYPENO,F_PACKTYPENAME) values(" + maxTid + "," + ViewState["InstanceID"].ToString() + ",'改派',TO_DATE('" + DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss") + "','DD-MM-YYYY HH24:MI:SS'),'" + Session["MemberName"].ToString() + "','" + reason + "'," + packTypeNo + ",'" + packTypeName + "')"; DBOpt.dbHelper.ExecuteSql(_sql); //如果改派的主办人也是从办者之中,则删除从办 _sql = "delete from dmis_sys_memberstatus where f_packno=" + ViewState["InstanceID"].ToString() + " and f_workflowno=" + ViewState["CurWorkFlowNo"] + " and f_receiver='" + rblMember.SelectedItem.Text + "'"; DBOpt.dbHelper.ExecuteSql(_sql); JScript.CloseWin("refreshPage"); } else { tdMessage.InnerText = GetGlobalResourceObject("WebGlobalResource", "SaveFailMessage").ToString();//"更改状态失败!请联系管理员!"; } }