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; //当前环节号 string sRight = ""; //文档权限编码 int CurWorkFlowNo; //工作流编号 dmis_sys_workflow表中的f_no值 PackTypeNo = Convert.ToInt16(grvList.DataKeys[row].Values[2]); CurLinkNo = Convert.ToInt16(grvList.DataKeys[row].Values[1]); CurWorkFlowNo = Convert.ToInt16(grvList.DataKeys[row].Values[3]); _sql = "select f_recno,F_DOCTYPENO from DMIS_SYS_DOC where F_PACKNO=" + grvList.DataKeys[row].Value.ToString() + " and F_LINKNO=" + CurLinkNo; DataTable doc = DBOpt.dbHelper.GetDataTable(_sql); if (doc == null || doc.Rows.Count < 1) { JScript.Alert("无法找到业务表的记录编号!"); return; } RecNo = Convert.ToInt16(doc.Rows[0][0]); DataTable docType = DBOpt.dbHelper.GetDataTable("select f_no,f_formfile,f_tablename,f_target from dmis_sys_doctype where f_no=" + doc.Rows[0][1].ToString()); if (docType == null || docType.Rows.Count < 1) { JScript.Alert("无法找到相应的文档!"); return; } DocTypeNo = Convert.ToInt16(docType.Rows[0][0]); sRight = WebWorkFlow.sDocTypeRight(DocTypeNo, Session["RoleIDs"].ToString()); if (sRight != "") { Session["Oper"] = 0; if (sRight[2] == '1' || sRight[3] == '1') { Session["Oper"] = 1; } Session["sended"] = "0"; Response.Redirect(docType.Rows[0][1].ToString() + "?RecNo=" + RecNo + @"&BackUrl=" + Page.Request.RawUrl + "&PackTypeNo=" + PackTypeNo + "&CurLinkNo=" + CurLinkNo + "&PackNo=" + grvList.DataKeys[row].Value.ToString() + "&CurWorkFlowNo=" + CurWorkFlowNo); } else { Response.Write("<script language=javascript>alert('对不起!你无权操作本文档')</script>"); } } }
public void openPage(System.Web.UI.Page pg, string sFileName, int iEdit) { DataTable oleRd; string sFile; if (sFileName != "") { Session["FormFile"] = sFileName; } else { if (!(Session["DocNo"] == null)) { if (FieldToValue.FieldToInt(Session["DocNo"]) > -1) { sSql = "SELECT F_DOCTYPENO,F_RECNO,F_TABLENAME FROM DMIS_SYS_DOC WHERE F_NO=" + Session["DocNo"]; oleRd = DBOpt.dbHelper.GetDataTable(sSql); if (oleRd.Rows.Count > 0) { Session["DocTypeNo"] = oleRd.Rows[0][0].ToString(); Session["RecNo"] = oleRd.Rows[0][1].ToString(); Session["TableName"] = oleRd.Rows[0][2].ToString(); } } } if (FieldToValue.FieldToInt(Session["DocTypeNo"]) == -2) { sFile = DBOpt.dbHelper.ExecuteScalar("SELECT F_FILENAME FROM DMIS_SYS_FILE WHERE F_NO=" + Session["RecNo"]).ToString(); if (sFile != "") { sFile = sFile.Replace("\\", "/"); sFile = sFile.Substring(sFile.LastIndexOf("/") + 1); } Session["FormFile"] = Server.MapPath("..\\upload\\") + sFile; } else { sSql = "SELECT F_FORMFILE FROM DMIS_SYS_DOCTYPE WHERE F_NO=" + Session["DocTypeNo"]; Session["FormFile"] = FieldToValue.FieldToString(DBOpt.dbHelper.ExecuteScalar(sSql)) + "?TID=" + Session["RecNo"]; Session["oper"] = -1; if (iEdit > 0) { string sRight = WebWorkFlow.sDocTypeRight(Convert.ToInt32(Session["DocTypeNo"]), Session["RoleIDs"].ToString()); if (sRight.Length == 7) { if (sRight.Substring(2, 1) == "1" | sRight.Substring(3, 1) == "1") { Session["oper"] = 1; } } } } } if (Session["FormFile"].ToString() != "") { oleRd = DBOpt.dbHelper.GetDataTable("select F_STYLE,F_TARGET from DMIS_SYS_filestyle where F_FILENAME='" + Session["FormFile"] + "'"); string sTyle = ""; string starget = ""; if (oleRd.Rows.Count > 0) { sTyle = FieldToValue.FieldToString(oleRd.Rows[0][0].ToString()); starget = FieldToValue.FieldToString(oleRd.Rows[0][1].ToString()); } if (starget == "") { System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("<script language=javascript>\r\n"); if (sTyle == "") { sb.Append("window.open('" + Session["FormFile"] + "');\r\n"); } else { sb.Append("window.open('" + Session["FormFile"] + "','','" + sTyle + "');\r\n"); } sb.Append("</script>"); pg.Response.Write(sb.ToString()); } else { pg.Response.Redirect(Session["FormFile"].ToString()); } } }