//在待办状态下接单 protected void btnAccept_Click(object sender, EventArgs e) { object obj = DBOpt.dbHelper.ExecuteScalar("select f_planday from dmis_sys_flowlink where f_no=" + ViewState["CurLinkNo"]); string finishedTime = ""; if (obj != null) { finishedTime = WebWorkFlow.GetLastTime(DateTime.Now, Convert.ToUInt32(obj)); } _sql = "update dmis_sys_workflow set f_working=1,f_receiver='" + Session["MemberName"].ToString() + "',f_receivedate='" + DateTime.Now.ToString("dd-MM-yyyy HH:mm") + "',F_LAST_FINISHED_TIME='" + finishedTime + "' where f_no=" + ViewState["CurWorkFlowNo"]; if (DBOpt.dbHelper.ExecuteSql(_sql) < 0) { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "WkAcceptTaskFailMessage").ToString()); //"接单失败!" return; } Session["Oper"] = 1; Response.Redirect(Page.Request.RawUrl); }
protected void grvList_RowCommand(object sender, GridViewCommandEventArgs e) { int row; if (!int.TryParse(e.CommandArgument.ToString(), out row)) { return; } if (e.CommandName == "FlowTable") //流程 { Response.Redirect("FlowTable.aspx?InstanceID=" + grvList.DataKeys[row].Value.ToString() + @"&BackUrl=" + Page.Request.RawUrl); } else if (e.CommandName == "Deal") //办理 { object obj; int RecNo; //记录编号 int DocTypeNo; //文档类型号 int PackTypeNo; //业务类型编号 int CurLinkNo; //当前环节号 int PackNo; //当前业务号 int CurWorkFlowNo; //工作流编号 dmis_sys_workflow表中的f_no值 PackTypeNo = Convert.ToInt16(grvList.DataKeys[row].Values[2]); PackNo = Convert.ToInt16(grvList.DataKeys[row].Value); CurLinkNo = Convert.ToInt16(grvList.DataKeys[row].Values[1]); CurWorkFlowNo = Convert.ToInt16(grvList.DataKeys[row].Values[3]); _sql = "select f_recno from DMIS_SYS_DOC where F_PACKNO=" + PackNo + " and F_LINKNO=" + CurLinkNo; obj = DBOpt.dbHelper.ExecuteScalar(_sql); if (obj == null) { RecNo = -1; } else { RecNo = Convert.ToInt16(obj); } DataTable docType = DBOpt.dbHelper.GetDataTable("select a.f_no,a.f_formfile,a.f_tablename,a.f_target from dmis_sys_doctype a,DMIS_SYS_WK_LINK_DOCTYPE b where a.f_no=b.F_DOCTYPENO and b.f_packtypeno=" + PackTypeNo + " and b.F_LINKNO=" + CurLinkNo); if (docType == null || docType.Rows.Count < 1) { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "WkNoDoc").ToString()); return; } DocTypeNo = Convert.ToInt16(docType.Rows[0][0]); DataTable rights = WebWorkFlow.DocTypeRights(DocTypeNo, Session["RoleIDs"].ToString());; if (rights != null && rights.Rows.Count > 0) { Session["Oper"] = 0; //待办状态只能读,不能修改,故下述代码注消 //for (int i = 0; i < rights.Rows.Count; i++) //{ // if (rights.Rows[i][0].ToString()[2] == '1' || rights.Rows[i][0].ToString()[3] == '1') // { // Session["Oper"] = 1; // break; // } //} Session["sended"] = "0"; Response.Redirect(docType.Rows[0][1].ToString() + "?RecNo=" + RecNo + @"&BackUrl=" + Page.Request.RawUrl + "&PackTypeNo=" + PackTypeNo + "&CurLinkNo=" + CurLinkNo + "&PackNo=" + PackNo + "&CurWorkFlowNo=" + CurWorkFlowNo); } else { Response.Write("<script language=javascript>alert('" + GetGlobalResourceObject("WebGlobalResource", "WkNoRightToRead").ToString() + "')</script>"); //对不起!你无权操作本文档 } } else if (e.CommandName == "Accept") // 接单 { string CurWorkFlowNo; //工作流编号 dmis_sys_workflow表中的f_no值 int CurLinkNo = Convert.ToInt16(grvList.DataKeys[row].Values[1]); CurWorkFlowNo = Convert.ToString(grvList.DataKeys[row].Values[3]); object obj = DBOpt.dbHelper.ExecuteScalar("select f_planday from dmis_sys_flowlink where f_no=" + CurLinkNo); string finishedTime = ""; if (obj != null) { finishedTime = WebWorkFlow.GetLastTime(DateTime.Now, Convert.ToUInt32(obj)); } if (Session["MemberName"].ToString() == grvList.Rows[row].Cells[7].Text || grvList.Rows[row].Cells[7].Text == " ") //如果没有主办人,则相同岗位的人都可以接收。 { _sql = "update dmis_sys_workflow set f_working=1,f_receiver='" + Session["MemberName"].ToString() + "',f_receivedate='" + DateTime.Now.ToString("dd-MM-yyyy HH:mm") + "',F_LAST_FINISHED_TIME='" + finishedTime + "' where f_no=" + CurWorkFlowNo; DBOpt.dbHelper.ExecuteSql(_sql); GridViewBind(); } else { //JScript.Alert("只有主办人才可以接单!"); return; } } }