public static string FinishData(string ID, string Status, string SwReadIDs, string LoginID) { string[] arrSwReadIds = SwReadIDs.Split(','); for (int i = 0; i < arrSwReadIds.Length; i++) { if (arrSwReadIds[i].Length > 0) { TOaSwReadVo objRead = new TOaSwReadVo(); objRead.ID = GetSerialNumber("t_oa_SWReadID"); objRead.SW_ID = ID; objRead.SW_PLAN_ID = arrSwReadIds[i]; objRead.SW_PLAN_DATE = System.DateTime.Now.ToShortDateString(); objRead.IS_OK = "0"; new TOaSwReadLogic().Create(objRead); } } bool b = false; b = new TOaSwInfoLogic().FinishSW(ID, "6", Status, LoginID); if (b) { return("成功"); } else { return(""); } }
/// <summary> /// 导出、打印收文 /// </summary> /// <param name="fwID">收文ID</param> public void SWPrint(string swID) { FileStream file = new FileStream(HttpContext.Current.Server.MapPath("template/SW.xls"), FileMode.Open, FileAccess.Read); HSSFWorkbook hssfworkbook = new HSSFWorkbook(file); ISheet sheet = hssfworkbook.GetSheet("Sheet1"); ICellStyle cellStyle = hssfworkbook.CreateCellStyle(); cellStyle.WrapText = true; cellStyle.VerticalAlignment = VerticalAlignment.CENTER; ICell cell; DataTable dt = new TOaSwInfoLogic().GetSWDetails(swID); if (dt.Rows.Count > 0) { sheet.GetRow(1).GetCell(2).SetCellValue(dt.Rows[0]["FROM_CODE"].ToString()); //原文编号 sheet.GetRow(1).GetCell(4).SetCellValue(dt.Rows[0]["SW_FROM"].ToString()); //来文机关 if (dt.Rows[0]["SW_DATE"].ToString() != "") { sheet.GetRow(1).GetCell(6).SetCellValue(DateTime.Parse(dt.Rows[0]["SW_DATE"].ToString()).ToShortDateString()); //收到日期 } sheet.GetRow(2).GetCell(2).SetCellValue(dt.Rows[0]["SW_CODE"].ToString()); //收文编号 if (dt.Rows[0]["PIGONHOLE_DATE"].ToString() != "") { sheet.GetRow(2).GetCell(4).SetCellValue(DateTime.Parse(dt.Rows[0]["PIGONHOLE_DATE"].ToString()).ToShortDateString()); //办结日期 } sheet.GetRow(3).GetCell(2).SetCellValue(dt.Rows[0]["SW_TITLE"].ToString()); //标题 cell = sheet.GetRow(4).GetCell(2); cell.CellStyle = cellStyle; //cell.SetCellValue(dt.Rows[0]["SW_PLAN3"].ToString() + "\n" + dt.Rows[0]["SW_PLAN5"].ToString()); //领导批示 cell.SetCellValue(dt.Rows[0]["SW_PLAN3"].ToString()); //领导批示 cell = sheet.GetRow(5).GetCell(2); cell.CellStyle = cellStyle; cell.SetCellValue(dt.Rows[0]["SW_PLAN2"].ToString()); //办公室意见 cell = sheet.GetRow(6).GetCell(2); cell.CellStyle = cellStyle; cell.SetCellValue(dt.Rows[0]["SW_PLAN4"].ToString()); //分管阅办 } using (MemoryStream stream = new MemoryStream()) { hssfworkbook.Write(stream); HttpContext curContext = HttpContext.Current; // 设置编码和附件格式 curContext.Response.ContentType = "application/vnd.ms-excel"; curContext.Response.ContentEncoding = Encoding.UTF8; curContext.Response.Charset = ""; curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("收文.xls", Encoding.UTF8)); curContext.Response.BinaryWrite(stream.GetBuffer()); curContext.Response.End(); } }
public static string deleteGridInfo(string strValue) { //TOaSwInfoVo TOaSwInfoVo = new TOaSwInfoVo(); //TOaSwInfoVo.ID = strValue; bool isSuccess = new TOaSwInfoLogic().Delete(strValue); if (isSuccess) { new PageBase().WriteLog("删除收文信息", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除收文信息" + strValue + "成功"); } return(isSuccess == true ? "1" : "0"); }
//页面初始化 private void InitPage() { TOaSwInfoVo objSW = new TOaSwInfoLogic().Details(this.hidTaskId.Value); this.FROM_CODE.Text = objSW.FROM_CODE; this.SW_CODE.Text = objSW.SW_CODE; this.SW_FROM.Text = objSW.SW_FROM; this.SW_COUNT.Text = objSW.SW_COUNT; this.SW_REG_DATE.Text = DateTime.Parse(objSW.SW_DATE).ToShortDateString(); this.SW_TITLE.Text = objSW.SW_TITLE; this.SW_MJ.Text = getDictName(objSW.SW_MJ, "FW_MJ");; this.SW_SIGN_ID.Text = objSW.SW_SIGN_ID; this.SW_SIGN_DATE.Text = DateTime.Parse(objSW.SW_SIGN_DATE).ToShortDateString(); if (this.hidTask_Tatus.Value == "1") { this.TReadUserList.Attributes.Add("style", "display:none"); } else if (this.hidTask_Tatus.Value == "2") { this.SW_APP_INFO.Value = objSW.SW_APP_INFO; this.SW_APP_ID.Text = new TSysUserLogic().Details(objSW.SW_APP_ID).REAL_NAME; this.SW_APP_DATE.Text = DateTime.Parse(objSW.SW_APP_DATE).ToShortDateString(); List <TOaSwReadVo> list = new TOaSwReadLogic().SelectByReadUser(objSW.ID); string strName = ""; string strId = ""; for (int i = 0; i < list.Count; i++) { string swid = list[i].SW_PLAN_ID; string swname = new TSysUserLogic().Details(swid).REAL_NAME; if (i == 0) { strName = swname; strId = swid; } else if (i > 0) { strName = strName + "," + swname; strId = strId + "," + swid; } } this.ReadUserNames.Value = strName; this.Hid_ReadUserIDs.Value = strId; this.SW_APP_INFO.Disabled = true; } else if (this.hidTask_Tatus.Value == "9") { this.TReadUserList.Attributes.Add("style", "display:none"); } }
//页面初始化 private void InitPage() { BindDataDictToControl("FW_MJ", this.MJ); this.SW_REG_DATE.Text = DateTime.Now.ToString("yyyy/MM/dd"); this.SW_APP_INFO.Disabled = true; if (this.hidView.Value == "true") { TOaSwInfoVo objSW = new TOaSwInfoLogic().Details(this.hidTaskId.Value); BindObjectToControls(objSW, this.form1); this.SW_REG_DATE.Text = DateTime.Parse(objSW.SW_REG_DATE).ToString("yyyy/MM/dd"); base.DisableAllControls(this.form1); this.MJ.Text = objSW.SW_MJ; this.SW_SIGN_DATE.Text = DateTime.Parse(objSW.SW_SIGN_DATE).ToShortDateString(); this.SW_APP_ID.Text = (objSW.SW_APP_ID.Length > 0) ? new TSysUserLogic().Details(objSW.SW_APP_ID).REAL_NAME : ""; this.SW_APP_DATE.Text = (objSW.SW_APP_DATE.Length > 0) ? DateTime.Parse(objSW.SW_APP_DATE).ToShortDateString() : ""; this.divContratSubmit.Visible = false; this.divBack.Visible = true; this.btnFileUp.Visible = false; List <TOaSwReadVo> list = new TOaSwReadLogic().SelectByReadUser(objSW.ID); string str = ""; for (int i = 0; i < list.Count; i++) { string swid = list[i].SW_PLAN_ID; string swname = new TSysUserLogic().Details(swid).REAL_NAME; if (i == 0) { str = swname; } else if (i > 0) { str = str + "," + swname; } } this.Text1.Value = str; this.TReadUserList.Attributes.Add("style", "display:block"); } else if (this.hidTaskId.Value.Length > 0) { TOaSwInfoVo objSW = new TOaSwInfoLogic().Details(this.hidTaskId.Value); BindObjectToControls(objSW, this.form1); this.SW_REG_DATE.Text = DateTime.Parse(objSW.SW_REG_DATE).ToString("yyyy/MM/dd"); } }
void IWFStepRules.CreatAndRegisterBusinessData() { //这里是产生和注册业务数据的地方 if (this.hidTaskId.Value.Length > 0 && String.IsNullOrEmpty(strBtnType)) { //这里是产生和注册业务数据的地方 TOaSwInfoVo objSW = new TOaSwInfoLogic().Details(this.hidTaskId.Value); objSW.ID = this.hidTaskId.Value; if (this.hidTask_Tatus.Value == "1") { this.TReadUserList.Attributes.Add("style", "display:none"); objSW.SW_APP_INFO = this.SW_APP_INFO.Value; objSW.SW_APP_ID = LogInfo.UserInfo.ID; objSW.SW_APP_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); objSW.SW_STATUS = "2"; wfControl.SaveInstStepServiceData("收文ID", "SwID", objSW.ID, "2"); } else if (this.hidTask_Tatus.Value == "2") { objSW.PIGONHOLE_ID = LogInfo.UserInfo.ID; objSW.PIGONHOLE_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); objSW.SW_STATUS = "9"; wfControl.SaveInstStepServiceData("收文ID", "SwID", objSW.ID, "9"); } new TOaSwInfoLogic().Edit(objSW); } else if (this.hidTaskId.Value.Length > 0 && strBtnType == "back") { //这里是产生和注册业务数据的地方 TOaSwInfoVo objSW = new TOaSwInfoLogic().Details(this.hidTaskId.Value); objSW.ID = this.hidTaskId.Value; if (this.hidTask_Tatus.Value == "1") { this.TReadUserList.Attributes.Add("style", "display:none"); objSW.SW_STATUS = "0"; wfControl.SaveInstStepServiceData("收文ID", "SwID", objSW.ID, "0"); } else if (this.hidTask_Tatus.Value == "2") { objSW.SW_APP_ID = "###"; objSW.SW_APP_DATE = "###"; objSW.SW_STATUS = "1"; wfControl.SaveInstStepServiceData("收文ID", "SwID", objSW.ID, "1"); } new TOaSwInfoLogic().Edit(objSW); } }
public static string FinishData(string ID, string Status, string LoginID) { bool b = false; b = new TOaSwInfoLogic().FinishSW(ID, "6", Status, LoginID); if (b) { return("成功"); } else { return(""); } }
//获取列表信息 private string getGridInfo() { string where = "1=1"; if (Request["TASKNAME"] != null) { if (Request["TASKNAME"].ToString().Trim() != "") { where += " and TASK_NAME like '%" + Request["TASKNAME"].ToString().Trim() + "%'"; } } if (Request["SENDUSER"] != null) { if (Request["SENDUSER"].ToString().Trim() != "") { where += " and SEND_USER like '%" + Request["SENDUSER"].ToString().Trim() + "%'"; } } if (Request["SENDDATE_from"] != null) { if (Request["SENDDATE_from"].ToString().Trim() != "") { where += " and SEND_DATE >= '" + Request["SENDDATE_from"].ToString().Trim() + " 00:00:00'"; } } if (Request["SENDDATE_to"] != null) { if (Request["SENDDATE_to"].ToString().Trim() != "") { where += " and SEND_DATE <= '" + Request["SENDDATE_to"].ToString().Trim() + " 23:59:59'"; } } string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); DataTable dt = new TOaSwInfoLogic().SelectHandleTable(LogInfo.UserInfo.ID, where, intPageIndex, intPageSize); string Json = CreateToJson(dt, dt.Rows.Count); return(Json); }
/// <summary> /// 获取断面信息 /// </summary> /// <returns></returns> private string getSWList(string strSWStatus) { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TOaSwInfoVo objSWInfo = new TOaSwInfoVo(); objSWInfo.SW_STATUS = strSWStatus; //objSWInfo.DRAFT_ID = LogInfo.UserInfo.ID; int intTotalCount = new TOaSwInfoLogic().GetSelectResultCount(objSWInfo); DataTable dt = new TOaSwInfoLogic().SelectByTable(objSWInfo, intPageIndex, intPageSize); string strJson = LigerGridDataToJson(dt, intTotalCount); return(strJson); }
/// <summary> /// 获取断面信息 /// </summary> /// <returns></returns> private string getOneGridInfo(string strSwStatus) { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TOaSwInfoVo TOaSwInfoVo = new TOaSwInfoVo(); TOaSwInfoVo.SW_STATUS = strSwStatus; DataTable dt = new TOaSwInfoLogic().SelectByTable(TOaSwInfoVo, intPageIndex, intPageSize); int intTotalCount = new TOaSwInfoLogic().GetSelectResultCount(TOaSwInfoVo); string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
//页面初始化 private void InitPage() { BindDataDictToControl("FW_MJ", this.MJ); this.SW_REG_DATE.Text = DateTime.Now.ToString("yyyy/MM/dd"); if (this.hidView.Value == "true") { TOaSwInfoVo objSW = new TOaSwInfoLogic().Details(this.hidTaskId.Value); BindObjectToControls(objSW, this.form1); this.SW_REG_DATE.Text = DateTime.Parse(objSW.SW_REG_DATE).ToString("yyyy/MM/dd"); base.DisableAllControls(this.form1); this.SW_SIGN_DATE.Text = DateTime.Parse(objSW.SW_SIGN_DATE).ToShortDateString(); //this.SW_PLAN_ID.Text = (objSW.SW_PLAN_ID.Length > 0) ? new TSysUserLogic().Details(objSW.SW_PLAN_ID).REAL_NAME : ""; //this.SW_PLAN_DATE.Text = (objSW.SW_PLAN_DATE.Length > 0) ? DateTime.Parse(objSW.SW_PLAN_DATE).ToShortDateString() : ""; //this.SW_PLAN_APP_ID.Text = (objSW.SW_PLAN_APP_ID.Length > 0) ? new TSysUserLogic().Details(objSW.SW_PLAN_APP_ID).REAL_NAME : ""; //this.SW_PLAN_APP_DATE.Text = (objSW.SW_PLAN_APP_DATE.Length > 0) ? DateTime.Parse(objSW.SW_PLAN_APP_DATE).ToShortDateString() : ""; //this.SW_APP_ID.Text = (objSW.SW_APP_ID.Length > 0) ? new TSysUserLogic().Details(objSW.SW_APP_ID).REAL_NAME : ""; //this.SW_APP_DATE.Text = (objSW.SW_APP_DATE.Length > 0) ? DateTime.Parse(objSW.SW_APP_DATE).ToShortDateString() : ""; } else if (this.hidTaskId.Value.Length > 0) { TOaSwInfoVo objSW = new TOaSwInfoLogic().Details(this.hidTaskId.Value); BindObjectToControls(objSW, this.form1); this.SW_REG_DATE.Text = DateTime.Parse(objSW.SW_REG_DATE).ToString("yyyy/MM/dd"); //this.SW_PLAN_ID.Text = (objSW.SW_PLAN_ID.Length > 0) ? new TSysUserLogic().Details(objSW.SW_PLAN_ID).REAL_NAME : ""; //this.SW_PLAN_DATE.Text = (objSW.SW_PLAN_DATE.Length > 0) ? DateTime.Parse(objSW.SW_PLAN_DATE).ToShortDateString() : ""; //this.SW_PLAN_APP_ID.Text = (objSW.SW_PLAN_APP_ID.Length > 0) ? new TSysUserLogic().Details(objSW.SW_PLAN_APP_ID).REAL_NAME : ""; //this.SW_PLAN_APP_DATE.Text = (objSW.SW_PLAN_APP_DATE.Length > 0) ? DateTime.Parse(objSW.SW_PLAN_APP_DATE).ToShortDateString() : ""; //this.SW_APP_ID.Text = (objSW.SW_APP_ID.Length > 0) ? new TSysUserLogic().Details(objSW.SW_APP_ID).REAL_NAME : ""; //this.SW_APP_DATE.Text = (objSW.SW_APP_DATE.Length > 0) ? DateTime.Parse(objSW.SW_APP_DATE).ToShortDateString() : ""; } }
/// <summary> /// 获取断面信息 /// </summary> /// <returns></returns> private string getOneGridInfo() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TOaSwReadVo tr = new TOaSwReadVo(); tr.REMARK1 = "0"; tr.SW_PLAN_ID = LogInfo.UserInfo.ID; TOaSwInfoVo TOaSwInfoVo = new TOaSwInfoVo(); DataTable dt = new TOaSwInfoLogic().SelectByTable_ForRead(TOaSwInfoVo, LogInfo.UserInfo.ID, intPageIndex, intPageSize); //int intTotalCount = new TOaSwInfoLogic().GetSelectResultCount(TOaSwInfoVo); int intTotalCount = new TOaSwReadLogic().GetSelectResultCount(tr); string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
/// <summary> /// 加载数据 /// </summary> /// <param name="strID">收文ID</param> private void InitData(string strID) { DataTable dt = new TOaSwInfoLogic().GetSWDetails(strID); if (dt.Rows.Count > 0) { FROM_CODE.Text = dt.Rows[0]["FROM_CODE"].ToString(); if (dt.Rows[0]["SW_REG_DATE"].ToString() != "") { SW_REG_DATE.Text = DateTime.Parse(dt.Rows[0]["SW_REG_DATE"].ToString()).ToShortDateString(); } SW_TITLE.Text = dt.Rows[0]["SW_TITLE"].ToString(); SUBJECT_WORD.Text = dt.Rows[0]["SUBJECT_WORD"].ToString(); SW_FROM.Text = dt.Rows[0]["SW_FROM"].ToString(); SW_COUNT.Text = dt.Rows[0]["SW_COUNT"].ToString(); MJ.SelectedValue = dt.Rows[0]["SW_MJ"].ToString(); SW_SIGN_ID.Text = dt.Rows[0]["SW_SIGN_ID"].ToString(); if (dt.Rows[0]["SW_SIGN_DATE"].ToString() != "") { SW_SIGN_DATE.Text = DateTime.Parse(dt.Rows[0]["SW_SIGN_DATE"].ToString()).ToShortDateString(); } if (dt.Rows[0]["PIGONHOLE_DATE"].ToString() != "") { PIGONHOLE_DATE.Text = DateTime.Parse(dt.Rows[0]["PIGONHOLE_DATE"].ToString()).ToShortDateString(); } SW_CODE.Text = dt.Rows[0]["SW_CODE"].ToString(); Hid_ReadUserIDs.Value = dt.Rows[0]["ReadUserID"].ToString(); ReadUserNames.Value = dt.Rows[0]["ReadUserName"].ToString(); Hid_MakeUserIDs.Value = dt.Rows[0]["MakeUserID"].ToString(); MakeUserNames.Value = dt.Rows[0]["MakeUserName"].ToString(); SW_PLAN2_INFO.Value = dt.Rows[0]["SW_PLAN2"].ToString(); SW_PLAN3_INFO.Value = dt.Rows[0]["SW_PLAN3"].ToString(); SW_PLAN4_INFO.Value = dt.Rows[0]["SW_PLAN4"].ToString(); SW_PLAN5_INFO.Value = dt.Rows[0]["SW_PLAN5"].ToString(); } }
public static string deleteOneGridInfo(string strValue) { bool isSuccess = new TOaSwInfoLogic().Delete(strValue); return(isSuccess == true ? "1" : "0"); }
//获取列表信息 private string getGridInfo(string strStatus) { //string strSortname = "SW_PLAN_DATE"; //string strSortorder = "desc"; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TOaSwInfoVo TOaSwInfoVo = new TOaSwInfoVo(); TOaSwInfoVo.SW_STATUS = strStatus; TOaSwInfoVo.SORT_FIELD = "READ_DATE"; TOaSwInfoVo.SORT_TYPE = "DESC"; if (Request["FROMCODE"] != null) { if (Request["FROMCODE"].ToString().Trim() != "") { TOaSwInfoVo.FROM_CODE = Request["FROMCODE"].ToString().Trim(); } } if (Request["SWCODE"] != null) { if (Request["SWCODE"].ToString().Trim() != "") { TOaSwInfoVo.SW_CODE = Request["SWCODE"].ToString().Trim(); } } if (Request["SWFROM"] != null) { if (Request["SWFROM"].ToString().Trim() != "") { TOaSwInfoVo.SW_FROM = Request["SWFROM"].ToString().Trim(); } } if (Request["SWTITLE"] != null) { if (Request["SWTITLE"].ToString().Trim() != "") { TOaSwInfoVo.SW_TITLE = Request["SWTITLE"].ToString().Trim(); } } if (Request["SIGNDATE"] != null)//传阅日期 { if (Request["SIGNDATE"].ToString().Trim() != "") { TOaSwInfoVo.REMARK1 = Request["SIGNDATE"].ToString().Trim(); } } if (Request["SUBJECTWORD"] != null) { if (Request["SUBJECTWORD"].ToString().Trim() != "") { TOaSwInfoVo.SUBJECT_WORD = Request["SUBJECTWORD"].ToString().Trim(); } } DataTable dt = new TOaSwInfoLogic().SelectByTable_ForRead(TOaSwInfoVo, base.LogInfo.UserInfo.ID, intPageIndex, intPageSize); int intTotalCount = new TOaSwInfoLogic().GetSelectResultCount_ForRead(TOaSwInfoVo, base.LogInfo.UserInfo.ID); string Json = CreateToJson(dt, intTotalCount); return(Json); }
//获取列表信息 private string getGridInfo(string strStatus) { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TOaSwInfoVo TOaSwInfoVo = new TOaSwInfoVo(); TOaSwInfoVo.SW_STATUS = strStatus; TOaSwInfoVo.SORT_FIELD = "ID"; TOaSwInfoVo.SORT_TYPE = "DESC"; if (Request["FROMCODE"] != null) { if (Request["FROMCODE"].ToString().Trim() != "") { TOaSwInfoVo.FROM_CODE = Request["FROMCODE"].ToString().Trim(); } } if (Request["SWCODE"] != null) { if (Request["SWCODE"].ToString().Trim() != "") { TOaSwInfoVo.SW_CODE = Request["SWCODE"].ToString().Trim(); } } if (Request["SWFROM"] != null) { if (Request["SWFROM"].ToString().Trim() != "") { TOaSwInfoVo.SW_FROM = Request["SWFROM"].ToString().Trim(); } } if (Request["SWTITLE"] != null) { if (Request["SWTITLE"].ToString().Trim() != "") { TOaSwInfoVo.SW_TITLE = Request["SWTITLE"].ToString().Trim(); } } if (Request["SIGNDATE"] != null) { if (Request["SIGNDATE"].ToString().Trim() != "") { TOaSwInfoVo.SW_SIGN_DATE = Request["SIGNDATE"].ToString().Trim(); } } if (Request["SUBJECTWORD"] != null) { if (Request["SUBJECTWORD"].ToString().Trim() != "") { TOaSwInfoVo.SUBJECT_WORD = Request["SUBJECTWORD"].ToString().Trim(); } } DataTable dt = new TOaSwInfoLogic().SelectByTable(TOaSwInfoVo, intPageIndex, intPageSize); int intTotalCount = new TOaSwInfoLogic().GetSelectResultCount(TOaSwInfoVo); string Json = CreateToJson(dt, intTotalCount); return(Json); }
//页面初始化 private void InitPage() { if (this.hidTaskId.Value.Length == 0) { return; } TOaSwInfoVo objSW = new TOaSwInfoLogic().Details(this.hidTaskId.Value); this.FROM_CODE.Text = objSW.FROM_CODE; this.SW_CODE.Text = objSW.SW_CODE; this.SW_TITLE.Text = objSW.SW_TITLE; this.SW_FROM.Text = objSW.SW_FROM; this.SW_COUNT.Text = objSW.SW_COUNT; this.MJ.Text = getDictName(objSW.SW_MJ, "FW_MJ"); this.SW_SIGN_ID.Text = objSW.SW_SIGN_ID; this.SW_SIGN_DATE.Text = DateTime.Parse(objSW.SW_SIGN_DATE).ToShortDateString(); this.SW_REG_DATE.Text = DateTime.Parse(objSW.SW_REG_DATE).ToShortDateString(); if (this.hidTask_Tatus.Value == "1") { this.SW_PLAN_APP_INFO.Disabled = true; this.SW_APP_INFO.Disabled = true; } else if (this.hidTask_Tatus.Value == "2") { this.SW_PLAN_INFO.Value = objSW.SW_PLAN_INFO; this.SW_PLAN_ID.Text = new TSysUserLogic().Details(objSW.SW_PLAN_ID).REAL_NAME; this.SW_PLAN_DATE.Text = DateTime.Parse(objSW.SW_PLAN_DATE).ToShortDateString(); this.SW_PLAN_INFO.Disabled = true; this.SW_APP_INFO.Disabled = true; this.dAcceptUserLst.Visible = true; this.wfControl.Visible = false; this.Button1.Visible = true; } else if (this.hidTask_Tatus.Value == "3") { this.SW_PLAN_INFO.Value = objSW.SW_PLAN_INFO; this.SW_PLAN_ID.Text = new TSysUserLogic().Details(objSW.SW_PLAN_ID).REAL_NAME; this.SW_PLAN_DATE.Text = DateTime.Parse(objSW.SW_PLAN_DATE).ToShortDateString(); this.SW_PLAN_APP_INFO.Value = objSW.SW_PLAN_APP_INFO; this.SW_PLAN_APP_ID.Text = new TSysUserLogic().Details(objSW.SW_PLAN_APP_ID).REAL_NAME; this.SW_PLAN_APP_DATE.Text = DateTime.Parse(objSW.SW_PLAN_APP_DATE).ToShortDateString(); this.SW_PLAN_INFO.Disabled = true; this.SW_PLAN_APP_INFO.Disabled = true; } else if (this.hidTask_Tatus.Value == "9") { this.SW_PLAN_INFO.Value = objSW.SW_PLAN_INFO; this.SW_PLAN_ID.Text = new TSysUserLogic().Details(objSW.SW_PLAN_ID).REAL_NAME; this.SW_PLAN_DATE.Text = DateTime.Parse(objSW.SW_PLAN_DATE).ToShortDateString(); this.SW_PLAN_APP_INFO.Value = objSW.SW_PLAN_APP_INFO; this.SW_PLAN_APP_ID.Text = new TSysUserLogic().Details(objSW.SW_PLAN_APP_ID).REAL_NAME; this.SW_PLAN_APP_DATE.Text = DateTime.Parse(objSW.SW_PLAN_APP_DATE).ToShortDateString(); //this.SW_APP_INFO.Value = objSW.SW_APP_INFO; //this.SW_APP_ID.Text = new TSysUserLogic().Details(objSW.SW_APP_ID).REAL_NAME; //this.SW_APP_DATE.Text = DateTime.Parse(objSW.SW_APP_DATE).ToShortDateString(); this.SW_PLAN_INFO.Disabled = true; this.SW_PLAN_APP_INFO.Disabled = true; this.SW_APP_INFO.Disabled = true; string strSwAppInfo = ""; TOaSwHandleVo objSwHandle = new TOaSwHandleVo(); objSwHandle.SW_ID = this.hidTaskId.Value; DataTable dt = new TOaSwHandleLogic().SelectByTable(objSwHandle); for (int i = 0; i < dt.Rows.Count; i++) { string strUserName = new TSysUserLogic().Details(dt.Rows[i]["SW_PLAN_ID"].ToString()).REAL_NAME; strSwAppInfo += strUserName + ":" + dt.Rows[i]["SW_PLAN_APP_INFO"].ToString() + "\r\n"; } this.SW_APP_INFO.Value = strSwAppInfo; } }
public static string SendData(string LoginID, string Action, string ID, string Status, string Reader, string Maker, string Handler, string SW_PLAN2, string SW_PLAN3, string SW_PLAN4, string SW_PLAN5) { bool b = false; string NewStatus = ""; string Suggestion = ""; //收文登记——》主任阅示 if (Action == "Add" || Action == "Update") { NewStatus = "1"; Suggestion = ""; Status = "0"; } if (Action == "Handle") { //主任阅示——》站长阅示 if (Status == "1") { NewStatus = "2"; Suggestion = SW_PLAN2; } //站长阅示——》分管阅办 if (Status == "2" && Reader.Trim() != "") { NewStatus = "3"; Suggestion = SW_PLAN3; } //站长阅示——》科室办结 if (Status == "2" && Reader.Trim() == "" && Maker.Trim() != "") { NewStatus = "4"; Suggestion = SW_PLAN3; } //分管阅办——》科室办结 if (Status == "3" && Maker.Trim() != "") { NewStatus = "4"; Suggestion = SW_PLAN4; } //分管阅办——》文件完结 if (Status == "3" && Maker.Trim() == "") { NewStatus = "5"; Suggestion = SW_PLAN4; } //科室办结——》文件完结 if (Status == "4") { NewStatus = "5"; Suggestion = SW_PLAN5; } } b = new TOaSwInfoLogic().SendSW(ID, NewStatus, Status, LoginID, Suggestion, Handler, Reader, Maker, "t_oa_SWHandleID"); if (b) { return("成功"); } else { return(""); } }
void IWFStepRules.CreatAndRegisterBusinessData() { if (this.hidTaskId.Value.Length > 0 && String.IsNullOrEmpty(strBtnType)) { //这里是产生和注册业务数据的地方 TOaSwInfoVo objSW = new TOaSwInfoLogic().Details(this.hidTaskId.Value); if (this.hidTask_Tatus.Value == "1") { objSW.SW_PLAN_INFO = this.SW_PLAN_INFO.Value; objSW.SW_PLAN_ID = LogInfo.UserInfo.ID; objSW.SW_PLAN_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); objSW.SW_STATUS = "2"; wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "2"); } else if (this.hidTask_Tatus.Value == "2") { objSW.SW_PLAN_APP_INFO = this.SW_PLAN_APP_INFO.Value; objSW.SW_PLAN_APP_ID = LogInfo.UserInfo.ID; objSW.SW_PLAN_APP_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); objSW.SW_STATUS = "3"; wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "3"); for (int i = 0; i < this.HID_USERIDS.Value.Split(',').Length; i++) { string strUserID = this.HID_USERIDS.Value.Split(',')[i]; TOaSwHandleVo objSwHandle = new TOaSwHandleVo(); objSwHandle.ID = GetSerialNumber("t_oa_SWHandleID"); objSwHandle.SW_ID = objSW.ID; objSwHandle.SW_PLAN_ID = strUserID; objSwHandle.IS_OK = "0"; new TOaSwHandleLogic().Create(objSwHandle); wfControl.MoreDealUserForAdd(strUserID); } } else if (this.hidTask_Tatus.Value == "3") { TOaSwHandleVo objSwHandle = new TOaSwHandleVo(); objSwHandle.SW_ID = objSW.ID; objSwHandle.SW_PLAN_ID = LogInfo.UserInfo.ID; objSwHandle = new TOaSwHandleLogic().Details(objSwHandle); objSwHandle.IS_OK = "1"; objSwHandle.SW_PLAN_APP_INFO = this.SW_APP_INFO.Value; objSwHandle.SW_PLAN_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); objSwHandle.SW_PLAN_ID = LogInfo.UserInfo.ID; new TOaSwHandleLogic().Edit(objSwHandle); //查看是否全部完成,变更收文记录状态 objSwHandle = new TOaSwHandleVo(); objSwHandle.SW_ID = objSW.ID; objSwHandle.IS_OK = "0"; DataTable dt = new TOaSwHandleLogic().SelectByTable(objSwHandle); if (dt.Rows.Count == 0) { objSW.SW_STATUS = "9"; } wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "9"); } else if (this.hidTask_Tatus.Value == "9") { wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "9"); } new TOaSwInfoLogic().Edit(objSW); } else if (this.hidTaskId.Value.Length > 0 && strBtnType == "back") { //这里是产生和注册业务数据的地方 TOaSwInfoVo objSW = new TOaSwInfoLogic().Details(this.hidTaskId.Value); if (this.hidTask_Tatus.Value == "1") { objSW.SW_PLAN_ID = "###"; objSW.SW_PLAN_DATE = "###"; objSW.SW_STATUS = "0"; wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "1"); } else if (this.hidTask_Tatus.Value == "2") { objSW.SW_PLAN_APP_ID = "###"; objSW.SW_PLAN_APP_DATE = "###"; objSW.SW_STATUS = "1"; wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "1"); } else if (this.hidTask_Tatus.Value == "3") { objSW.SW_APP_ID = "###"; objSW.SW_APP_DATE = "###"; objSW.SW_STATUS = "2"; wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "1"); } new TOaSwInfoLogic().Edit(objSW); } }