public static DataTable GetSendReceiveCount(string CompanyCD, string TableName, string TypeID, string BeginDate, string EndDate) { string TypeIdName = ""; if (TableName == "officedba.DocReceiveInfo") { TypeIdName = "ReceiveDocTypeID"; } else { TypeIdName = "SendDocTypeID"; } return(DocReceiveDBHelper.GetSendReceiveCount(CompanyCD, TableName, TypeIdName, TypeID, BeginDate, EndDate)); }
/// <summary> /// 根据收文ID修改收文信息 /// </summary> /// <param name="DocReceiveM">收文信息</param> /// <returns>bool值</returns> public static bool UpdateDocReceive(DocReceiveModel DocReceiveM) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; LogInfoModel logModel = new LogInfoModel(); //操作日志 bool isSucc = false; //定义返回变量 #region 设置操作日志内容 //设置公司代码 logModel.CompanyCD = userInfo.CompanyCD; //设置登陆用户ID logModel.UserID = userInfo.UserID; //设置模块ID 模块ID在ConstUtil中定义,以便维护 logModel.ModuleID = ConstUtil.MODULE_ID_DOCRECEIVE_LIST; //操作单据编号 编号 logModel.ObjectID = DocReceiveM.ReceiveDocNo; //操作对象 操作的表信息 logModel.ObjectName = ConstUtil.TABLE_NAME_DOCRECEIVE; //涉及关键元素 涉及其他业务、表关系 logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //备注 操作类型 logModel.Remark = ConstUtil.LOG_PROCESS_UPDATE; #endregion try { isSucc = DocReceiveDBHelper.UpdateDocReceive(DocReceiveM); } catch (System.Exception ex) { #region 操作失败时记录日志到文件 //定义变量 LogInfo logSys = new LogInfo(); //设置日志类型 需要指定为系统日志 logSys.Type = LogInfo.LogType.SYSTEM; //指定系统日志类型 出错信息 logSys.SystemKind = LogInfo.SystemLogKind.SYSTEM_ERROR; //指定登陆用户信息 logSys.UserInfo = userInfo; //设定模块ID logSys.ModuleID = ConstUtil.MODULE_ID_DOCRECEIVE_LIST; //描述 logSys.Description = ex.ToString(); //输出日志 LogUtil.WriteLog(logSys); #endregion } if (isSucc)//操作成功 { logModel.Remark += "成功"; } else//操作失败 { logModel.Remark += "失败"; } //记录日志 LogDBHelper.InsertLog(logModel); return(isSucc); }
/// <summary> /// 导出收文列表 /// </summary> /// <param name="DocReceiveM"></param> /// <param name="FileDateBegin"></param> /// <param name="FileDateEnd"></param> /// <param name="FileCompany"></param> /// <param name="ord"></param> /// <returns></returns> public static DataTable ExportDocReceive(DocReceiveModel DocReceiveM, string FileDateBegin, string FileDateEnd, string FileCompany, string ord) { return(DocReceiveDBHelper.ExportDocReceive(DocReceiveM, FileDateBegin, FileDateEnd, FileCompany, ord)); }
/// <summary> /// 收文明细打印 /// </summary> /// <param name="CompanyCD"></param> /// <param name="TypeID"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="ord"></param> /// <returns></returns> public static DataTable GetDocReceiveListPrint(string CompanyCD, string TypeID, string BeginDate, string EndDate, string ord) { return(DocReceiveDBHelper.GetDocReceiveListPrint(CompanyCD, TypeID, BeginDate, EndDate, ord)); }
/// <summary> /// 收文明细 /// </summary> /// <param name="CompanyCD"></param> /// <param name="TypeID"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="pageIndex"></param> /// <param name="pageCount"></param> /// <param name="ord"></param> /// <param name="TotalCount"></param> /// <returns></returns> public static DataTable GetDocReceiveList(string CompanyCD, string TypeID, string BeginDate, string EndDate, int pageIndex, int pageCount, string ord, ref int TotalCount) { return(DocReceiveDBHelper.GetDocReceiveList(CompanyCD, TypeID, BeginDate, EndDate, pageIndex, pageCount, ord, ref TotalCount)); }
/// <summary> /// 根据ID获得收文详细信息 /// </summary> /// <param name="CompanyCD">公司代码</param> /// <param name="DocReceiveID">收文ID</param> /// <returns>收文信息</returns> public static DataTable GetDocReceiveByID(string CompanyCD, int DocReceiveID) { return(DocReceiveDBHelper.GetDocReceiveByID(CompanyCD, DocReceiveID)); }
/// <summary> /// 根据条件检索收文信息 /// </summary> /// <param name="DocReceiveM">收文信息</param> /// <param name="FileDateBegin">开始时间</param> /// <param name="FileDateEnd">结束时间</param> /// <param name="FileCompany">来文单位</param> /// <returns>收文列表信息</returns> public static DataTable GetDocReceiveBycondition(DocReceiveModel DocReceiveM, string FileDateBegin, string FileDateEnd, string FileCompany, int pageIndex, int pageCount, string ord, ref int totalCount) { return(DocReceiveDBHelper.GetDocReceiveBycondition(DocReceiveM, FileDateBegin, FileDateEnd, FileCompany, pageIndex, pageCount, ord, ref totalCount)); }