Example #1
0
    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("");
        }
    }
Example #2
0
        /// <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();
            }
        }
Example #3
0
    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");
    }
Example #4
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");
        }
    }
Example #5
0
    //页面初始化
    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");
        }
    }
Example #6
0
    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);
        }
    }
Example #7
0
    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("");
        }
    }
Example #8
0
    //获取列表信息
    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);
    }
Example #11
0
    //页面初始化
    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);
    }
Example #13
0
    /// <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);
    }
Example #17
0
    //页面初始化
    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;
        }
    }
Example #18
0
    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("");
        }
    }
Example #19
0
    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);
        }
    }