protected void Page_Load(object sender, EventArgs e) { valObj.af_PageBy(TF_F_COLUMN.Attribute.COLUMN_ID, Order.Desc); title = valObj._ZhName + "Ñ¡Ôñ"; Page.Title = title; if (Request["formid"] != null) { condObj.FORM_ID = int.Parse(Request["formid"]); } if (!IsPostBack) { aspPager.CurrentPageIndex = 1; aspPager.PageSize = 20; try { listObj = BLLTable <TF_F_COLUMN> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); FORM_BLL sub_bll = new FORM_BLL(condObj.FORM_ID); if (sub_bll.HadSubForm) { condObj = new TF_F_COLUMN(); condObj.FORM_ID = sub_bll.GetSubForm().FORM_ID; listObj2 = BLLTable <TF_F_COLUMN> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); } listObj.AddRange(listObj2); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } aspPager.RecordCount = recount; } }
protected void Page_Load(object sender, EventArgs e) { title ="���뵥�б�"; Page.Title = title; if (!string.IsNullOrEmpty(Request["WFID"])) { wf_obj_id = int.Parse(Request["WFID"]); wfbll = new WFOBJECT_BLL(wf_obj_id); if (wfbll.Base != null) { bllform = wfbll.FORM_BLL; wfobj = wfbll.Base; } else { return; } } else { return; } appPath = WebHelper.GetAppPath(); if (!IsPostBack) { staff_id = userBase.GetStaff().STAFF_ID; title = wfbll.Base._WF_OBJ_NAME; //////////// WF_INFO cond = new WF_INFO(); cond.STATUS = "1"; List<WF_INFO> lst = BLLTable<WF_INFO>.Factory(conn).Select(new WF_INFO(), cond); List<WF_TYPE> lstType = BLLTable<WF_TYPE>.Factory(conn).Select(new WF_TYPE(), new WF_TYPE()); for (int i = 0; i < lstType.Count; i++) { var lll = lst.Where(l => l._TYPE_ID == lstType[i]._TYPE_ID); litMenu.Text += "<li><a>" + lstType[i].TYPE_NAME + "</a><ul>"; foreach (WF_INFO l in lll) { litMenu.Text += "<li><a href='" + appPath + "WF/FORMList.aspx?mine=1&WFID=" + l.WFID + "' data=\"{key:'wf" + l.WFID + "mylist'}\">" + l.WFCNAME + "����</a></li>"; } litMenu.Text += "</ul></li>"; } //////////// //���û�������Ա����ô�����staff_id == 0 ViewState["STAFF_ID"] = staff_id; #region//Ĭ�����Գ�ʼ�� aspPager.CurrentPageIndex = 1; aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto;//.WebCtrls txtPageSize.Value = "30"; aspPager.PageSize = 30; #endregion #region//���ݳ�ʼ�� //txtSTATUS.Items.AddRange(FormHelper.GetListItem(WF_FORMBASE.Attribute.STATUS)); #endregion BindList(1); } }
protected void Page_Load(object sender, EventArgs e) { int intWfId = Common.GetReqIntValue("wfid"); string strWhere = Common.GetReqStrValue("where"); int recount = -1; string strCOLS = ""; string[] arr = null; DataTable dt = null; WFOBJECT_BLL wfbll = new WFOBJECT_BLL(intWfId); FORM_BLL bllform = null; if (wfbll.Base != null) { bllform = wfbll.FORM_BLL; } if (bllform != null) { dt = bllform.WF_SelectByPage(intWfId, 12, 1, ref recount, strWhere, out strCOLS); //在合同里增加 金额 字段 arr = StringHelper.GetStringArray(strCOLS, ','); } Response.Clear(); Response.Buffer = true; Response.Charset = "GB2312"; //Response.ContentEncoding = System.Text.Encoding.UTF8; Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("流程列表" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls")); Response.ContentType = "application/vnd.ms-excel"; string header = ""; string body = ""; header += "编号\t"; header += "提交人\t"; header += "申请单名称\t"; header += "申请部门\t"; header += "提交时间\t"; header += "审批情况\t"; if (arr != null) { for (int i = 0; i < arr.Length; i++) { string[] aaa = arr[i].Split(':'); if (aaa.Length > 1) { header += aaa[1] + "\t"; } } } header += "\n"; if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { body += Convert.ToString(dt.Rows[i]["RECID"]) + "\t"; body += Convert.ToString(dt.Rows[i]["CSTAFF_NAME"]) + "\t"; body += Convert.ToString(dt.Rows[i]["RECNAME"]) + "\t"; body += Convert.ToString(dt.Rows[i]["DEPT_NAME"]) + "\t"; body += Convert.ToString(dt.Rows[i]["ADDTIME"]) + "\t"; body += WFEnum.GetRecStatus(Convert.ToString(dt.Rows[i]["STATUS"])) + "\t"; if (arr != null) { for (int j = 0; j < arr.Length; j++) { string[] aaa = arr[j].Split(':'); if (aaa.Length > 1) { body += Convert.ToString(dt.Rows[i][aaa[0]]) + "\t"; } } } body += "\n"; } } Response.Write(header); Response.Write(body); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request["RECID"])) { recid = decimal.Parse(Request["RECID"]); } else { Response.Write("非法连接!"); Response.End(); } if (!string.IsNullOrEmpty(Request["WFID"])) { WFOBJ_ID = int.Parse(Request["WFID"]); } if (!IsPostBack) { //try //{ ViewState["CHECK_INFO"] = ""; StringBuilder sbDetail = new StringBuilder(); if (recid > 0) { WF_FORMBASE valObj = BLLTable <WF_FORMBASE> .Factory(conn).GetRowData(WF_FORMBASE.Attribute.RECID, recid); if (WFOBJ_ID <= 0) { WFOBJ_ID = valObj.WFID; } WFOBJECT_BLL wfbll = new WFOBJECT_BLL(WFOBJ_ID); FORM_BLL formbll = wfbll.FORM_BLL; //WFINFO_EXD wfExd = wfbll.WFExd;// new WFINFO_EXD(WFID, valObj.PROCID); //WFORM_EXD wform = wfExd.GetFORM(); litTitle.Text = valObj.RECNAME; WFRecordInfo recObj = new WFRecordInfo(valObj, true); if (recObj.HadRecord == false) { Response.Write("您要查看的申请记录不存在!"); Response.End(); return; } PROCID = valObj.PROCID; title = valObj.RECNAME; if (!string.IsNullOrEmpty(valObj.CHECK_INFO)) { ViewState["CHECK_INFO"] = valObj.CHECK_INFO; } if (sbDetail.Length > 1) { ViewState["HadDetail"] = true; litDetail.Text = sbDetail.ToString(); } if (valObj.PROCID > 0) { ViewState["PROCID"] = valObj.PROCID; } litDetail.Text = formbll.WF_HtmlShowForm(recObj);// WFRecord.ShowRecordDetail(wfid, recid, recObj); if (!string.IsNullOrEmpty(valObj.ANNEX_FILE)) { //litAnnex.Text = "<dl class='row'><dt>附件:</dt><dd><a href='" + WebHelper.GetAppPath() + valObj.ANNEX_FILE + "' target='_blank'>" + valObj.ANNEX_FILE.Substring(valObj.ANNEX_FILE.LastIndexOf("/") + 1) + "</a></dd></dl>"; string tempStr = "<tr><td class='lbl'><label>员工名:</label></td><td colspan='4'><span>陈焕许</span></td></tr>"; tempStr = StringHelper.ReplaceNonCase(tempStr, "员工名", "附件"); litAnnex.Text = StringHelper.ReplaceNonCase(tempStr, "陈焕许", "<a href='" + WebHelper.GetAppPath() + valObj.ANNEX_FILE + "' target='_blank'>" + valObj.ANNEX_FILE.Substring(valObj.ANNEX_FILE.LastIndexOf("/") + 1) + "</a>"); } bool hadPower = false; litWFPath.Text = wfbll.HtmlWFTextMap(recid, userBase.StaffID, ref hadPower);// WFHtml.ShowProcessTextMap(wfid, valObj.PROCID, recid, userBase.StaffID, ref hadPower); } //} //catch (Exception ex) //{ // litWarn.Text = ex.Message; txtREASON.Value = "00000000"; //} } }
protected void Page_Load(object sender, EventArgs e) { #region//必须的参数信息初始化 if (!string.IsNullOrEmpty(Request["RECID"])) { recid = decimal.Parse(Request["RECID"]); } if (!string.IsNullOrEmpty(Request["WFID"])) { wf_obj_id = int.Parse(Request["WFID"]); if (wf_obj_id <= 0) { if (recid <= 0) { Response.Redirect("SelWFID.aspx"); } if (ViewState["WFID"] != null) { wf_obj_id = Convert.ToInt32(ViewState["WFID"]); } } if (ViewState["WFCNAME"] == null) { wfcname = BLLTable <WF_WFOBJECT> .Factory(conn).GetOneValue(WF_WFOBJECT.Attribute.WF_OBJ_ID, wf_obj_id, WF_WFOBJECT.Attribute.WF_OBJ_NAME); ViewState["WFCNAME"] = wfcname; } else { wfcname = ViewState["WFCNAME"].ToString(); } } else { if (recid <= 0) { Response.Redirect("SelWFID.aspx"); } if (ViewState["WFID"] != null) { wf_obj_id = Convert.ToInt32(ViewState["WFID"]); } } #endregion theme = WebHelper.GetAppPath() + "Themes/" + BasePage._ThemeName; backUrl = WebHelper.GetAppPath() + "WF/FORMList.aspx?mime=1&WFID=" + wf_obj_id; if (preUrl != "") { backUrl = preUrl; } title = wfcname + title; if (!IsPostBack) { Form.Enctype = "multipart/form-data"; UpFilesBfSubmit1.ShowPathPre = "../"; UpFilesBfSubmit1.SavePath = "UploadFiles/WF/Rec/"; txtDEPT_ID.ORG_ID = "7"; #region//默认信息初始化 HR_STAFF staff = userBase.GetStaff(); //如果账户没有员工对应 if (staff != null && !staff.IsNull()) { txtCSTAFF_ID.Value = staff.STAFF_ID.ToString(); txtCSTAFF_NAME.Value = staff.STAFF_NAME; txtDEPT_ID.DEPT_ID = Convert.ToString(staff.GetValue(HR_DEPT_STAFF.Attribute.DEPT_ID)); txtSTAFF_ID.Staff_NAME = staff.STAFF_NAME; txtSTAFF_ID.Staff_ID = staff.STAFF_ID; txtRECNO.Value = WFRecordInfo.GetRECNO(Convert.ToString(staff.GetValue(HR_DEPT_STAFF.Attribute.DEPT_ID))); HR_DEPT dept = BLLTable <HR_DEPT> .Factory(conn).GetRowData(HR_DEPT.Attribute.DEPT_ID, Convert.ToString(staff.GetValue(HR_DEPT_STAFF.Attribute.DEPT_ID))); if (dept != null && !dept.IsNull()) { txtCDEPT_ID.Value = dept.DEPT_ID; txtCDEPT_NAME.Value = dept.DEPT_NAME; } else { litWarn.Text = "您的账户未设置所属部门"; } } else { litWarn.Text = "您的账户未有对应员工"; } #endregion ViewState["CHECK_INFO"] = ""; WFOBJECT_BLL wfobj = new WFOBJECT_BLL(wf_obj_id); //WFINFO_EXD wfexd = new WFINFO_EXD(wfid,0); FORM_BLL formexd = wfobj.FORM_BLL; if (recid > 0) { #region//单据信息编辑 WF_FORMBASE baseVal = BLLTable <WF_FORMBASE> .Factory(conn).GetRowData(WF_FORMBASE.Attribute.RECID, recid); WFRecordInfo recObj = new WFRecordInfo(baseVal, true); if (recObj.HadRecord == false) { ScriptHelper.AlertAndGo(Page, "您要编辑的申请记录不存在!", backUrl); return; } if (wf_obj_id <= 0) { ViewState["WFID"] = baseVal.WFID;//记录下当前工作流ID wf_obj_id = baseVal.WFID; } Dictionary <string, WFieldInfo> dicMore = recObj.ExdFields; //zlg关键-构建表单 litFormMore.Text = formexd.WF_HtmlEditForm(recObj);// WFHtml.ShowMoreFormHtml(wfid, dicMore, ref sbDetail); hadDetail = formexd.HadSubForm; ViewState["STATUS"] = baseVal.STATUS; if (!string.IsNullOrEmpty(baseVal.CHECK_INFO)) { ViewState["CHECK_INFO"] = baseVal.CHECK_INFO; } if (recObj.Base.STATUS == WFEnum.RecStatus.Checking.ToString("d") || recObj.Base.STATUS == WFEnum.RecStatus.ReCheck.ToString("d") || recObj.Base.STATUS == WFEnum.RecStatus.Accepted.ToString("d")) { ScriptHelper.AlertAndGo(Page, "该记录已经进入审批流程,不允许修改!", backUrl); } else { if (recObj.Base.STATUS == WFEnum.RecStatus.NoAccept.ToString("d")) { btnOK.Text = "重新提交"; } WF_FORMBASE valObj = recObj.Base; #region txtDEPT_ID.DEPT_NAME = Convert.ToString(valObj.DEPT_NAME); txtDEPT_ID.DEPT_ID = Convert.ToString(valObj.DEPT_ID);//Convert.ToString txtSTAFF_ID.Staff_ID = valObj.STAFF_ID; txtCSTAFF_ID.Value = Convert.ToString(valObj.CSTAFF_ID); //Convert.ToString txtCSTAFF_NAME.Value = Convert.ToString(valObj.CSTAFF_NAME); //Convert.ToString txtNOTE.Value = Convert.ToString(valObj.NOTE); //Convert.ToString #endregion if (valObj.STAFF_ID != userBase.StaffID && valObj.CSTAFF_ID != userBase.StaffID) { //不是自己提交的申请不能修改或提交审批 btnSave.Enabled = false; } } UpFilesBfSubmit1.ShowOldFiles(baseVal.ANNEX_FILE); #endregion } else { litFormMore.Text = formexd.WF_HtmlEditForm();// WFHtml.ShowMoreFormHtml(wfid, null, ref sbDetail); hadDetail = formexd.HadSubForm; } } }
protected void Page_Load(object sender, EventArgs e) { title = "申请单列表"; Page.Title = title; if (!string.IsNullOrEmpty(Request["WFID"])) { wf_obj_id = int.Parse(Request["WFID"]); wfbll = new WFOBJECT_BLL(wf_obj_id); if (wfbll.Base != null) { bllform = wfbll.FORM_BLL; wfobj = wfbll.Base; } else { return; } } else { return; } appPath = WebHelper.GetAppPath(); if (!IsPostBack) { staff_id = userBase.GetStaff().STAFF_ID; title = wfbll.Base._WF_OBJ_NAME; //////////// WF_INFO cond = new WF_INFO(); cond.STATUS = "1"; List <WF_INFO> lst = BLLTable <WF_INFO> .Factory(conn).Select(new WF_INFO(), cond); List <WF_TYPE> lstType = BLLTable <WF_TYPE> .Factory(conn).Select(new WF_TYPE(), new WF_TYPE()); for (int i = 0; i < lstType.Count; i++) { var lll = lst.Where(l => l._TYPE_ID == lstType[i]._TYPE_ID); litMenu.Text += "<li><a>" + lstType[i].TYPE_NAME + "</a><ul>"; foreach (WF_INFO l in lll) { litMenu.Text += "<li><a href='" + appPath + "WF/FORMList.aspx?mine=1&WFID=" + l.WFID + "' data=\"{key:'wf" + l.WFID + "mylist'}\">" + l.WFCNAME + "管理</a></li>"; } litMenu.Text += "</ul></li>"; } //////////// //如果没存在这个员工怎么处理,staff_id == 0 ViewState["STAFF_ID"] = staff_id; #region //默认属性初始化 aspPager.CurrentPageIndex = 1; aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto; //.WebCtrls txtPageSize.Value = "30"; aspPager.PageSize = 30; #endregion #region//数据初始化 //txtSTATUS.Items.AddRange(FormHelper.GetListItem(WF_FORMBASE.Attribute.STATUS)); #endregion BindList(1); } }
protected void Page_Load(object sender, EventArgs e) { valObj.af_PageBy(TF_F_COLUMN.Attribute.COLUMN_ID, Order.Desc); title = valObj._ZhName + "ѡ��"; Page.Title = title; if (Request["formid"] != null) { condObj.FORM_ID = int.Parse(Request["formid"]); } if (!IsPostBack) { aspPager.CurrentPageIndex = 1; aspPager.PageSize = 20; try { listObj = BLLTable<TF_F_COLUMN>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); FORM_BLL sub_bll = new FORM_BLL(condObj.FORM_ID); if (sub_bll.HadSubForm) { condObj = new TF_F_COLUMN(); condObj.FORM_ID = sub_bll.GetSubForm().FORM_ID; listObj2 = BLLTable<TF_F_COLUMN>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); } listObj.AddRange(listObj2); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } aspPager.RecordCount = recount; } }