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());
}
}
}
