/// <summary>
/// 添加收文信息的方法
/// </summary>
/// <param name="DocReceiveM">收文信息</param>
/// <returns>被添加收文ID</returns>
public static int DocReceiveAdd(DocReceiveModel DocReceiveM)
{
try
{
#region 设置参数
SqlParameter[] param = new SqlParameter[25];
param[0] = SqlHelper.GetParameter("@CompanyCD ",DocReceiveM.CompanyCD );
param[1] = SqlHelper.GetParameter("@ReceiveDocNo ",DocReceiveM.ReceiveDocNo );
param[2] = SqlHelper.GetParameter("@ReceiveDocTypeID",DocReceiveM.ReceiveDocTypeID);
param[3] = SqlHelper.GetParameter("@SecretLevel ",DocReceiveM.SecretLevel );
param[4] = SqlHelper.GetParameter("@Critical ",DocReceiveM.Critical );
param[5] = SqlHelper.GetParameter("@FileDate", DocReceiveM.FileDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(DocReceiveM.FileDate.ToString()));
param[6] = SqlHelper.GetParameter("@FileNo ",DocReceiveM.FileNo );
param[7] = SqlHelper.GetParameter("@FileCompany ",DocReceiveM.FileCompany );
param[8] = SqlHelper.GetParameter("@FileTitle ",DocReceiveM.FileTitle );
param[9] = SqlHelper.GetParameter("@FileReason ",DocReceiveM.FileReason );
param[10] = SqlHelper.GetParameter("@KeyWord ",DocReceiveM.KeyWord );
param[11] = SqlHelper.GetParameter("@Description ",DocReceiveM.Description );
param[12] = SqlHelper.GetParameter("@DeptID ",DocReceiveM.DeptID );
param[13] = SqlHelper.GetParameter("@BackerNo ",DocReceiveM.BackerNo );
param[14] = SqlHelper.GetParameter("@Backer ",DocReceiveM.Backer );
param[15] = SqlHelper.GetParameter("@BackDate", DocReceiveM.BackDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(DocReceiveM.BackDate.ToString()));
param[16] = SqlHelper.GetParameter("@BackContent ",DocReceiveM.BackContent );
param[17] = SqlHelper.GetParameter("@Remark ",DocReceiveM.Remark );
param[18] = SqlHelper.GetParameter("@RegisterUserID ",DocReceiveM.RegisterUserID );
param[19] = SqlHelper.GetParameter("@UploadDate", DocReceiveM.UploadDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(DocReceiveM.UploadDate.ToString()));
param[20] = SqlHelper.GetParameter("@DocumentName ",DocReceiveM.DocumentName );
param[21] = SqlHelper.GetParameter("@DocumentURL ",DocReceiveM.DocumentURL );
param[22] = SqlHelper.GetParameter("@ModifiedDate", DocReceiveM.ModifiedDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(DocReceiveM.ModifiedDate.ToString()));
param[23] = SqlHelper.GetParameter("@ModifiedUserID ",DocReceiveM.ModifiedUserID );
SqlParameter paramid = new SqlParameter("@id", SqlDbType.Int);
paramid.Direction = ParameterDirection.Output;
param[24] = paramid;
#endregion
//创建命令
SqlCommand comm = new SqlCommand();
SqlHelper.ExecuteTransStoredProcedure("officedba.insertDocReceive", comm, param);
int DocReceiveID = Convert.ToInt32(comm.Parameters["@id"].Value);
return DocReceiveID;
}
catch
{
return 0;
}
}
/// <summary>
/// 根据收文ID修改收文信息
/// </summary>
/// <param name="DocReceiveM">收文信息</param>
/// <returns>bool值</returns>
public static bool UpdateDocReceive(DocReceiveModel DocReceiveM)
{
try
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE officedba.DocReceiveInfo set ");
sql.AppendLine("CompanyCD =@CompanyCD ,");
//sql.AppendLine("ReceiveDocNo =@ReceiveDocNo ,");
sql.AppendLine("ReceiveDocTypeID=@ReceiveDocTypeID,");
sql.AppendLine("SecretLevel =@SecretLevel ,");
sql.AppendLine("Critical =@Critical ,");
sql.AppendLine("FileDate =@FileDate ,");
sql.AppendLine("FileNo =@FileNo ,");
sql.AppendLine("FileCompany =@FileCompany ,");
sql.AppendLine("FileTitle =@FileTitle ,");
sql.AppendLine("FileReason =@FileReason ,");
sql.AppendLine("KeyWord =@KeyWord ,");
sql.AppendLine("Description =@Description ,");
sql.AppendLine("DeptID =@DeptID ,");
sql.AppendLine("BackerNo =@BackerNo ,");
sql.AppendLine("Backer =@Backer ,");
sql.AppendLine("BackDate =@BackDate ,");
sql.AppendLine("BackContent =@BackContent ,");
sql.AppendLine("Remark =@Remark ,");
sql.AppendLine("RegisterUserID =@RegisterUserID ,");
sql.AppendLine("UploadDate =@UploadDate ,");
sql.AppendLine("DocumentName =@DocumentName ,");
sql.AppendLine("DocumentURL =@DocumentURL ,");
sql.AppendLine("ModifiedDate =@ModifiedDate ,");
sql.AppendLine("ModifiedUserID =@ModifiedUserID ");
sql.AppendLine(" WHERE ");
sql.AppendLine("ID = @ID ");
SqlParameter[] param = new SqlParameter[24];
param[0] = SqlHelper.GetParameter("@ID ", DocReceiveM.ID);
param[1] = SqlHelper.GetParameter("@CompanyCD ",DocReceiveM.CompanyCD );
param[2] = SqlHelper.GetParameter("@ReceiveDocTypeID",DocReceiveM.ReceiveDocTypeID);
param[3] = SqlHelper.GetParameter("@SecretLevel ",DocReceiveM.SecretLevel );
param[4] = SqlHelper.GetParameter("@Critical ",DocReceiveM.Critical );
//param[5] = SqlHelper.GetParameter("@FileDate ",DocReceiveM.FileDate );
param[5] = SqlHelper.GetParameter("@FileDate", DocReceiveM.FileDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(DocReceiveM.FileDate.ToString()));
param[6] = SqlHelper.GetParameter("@FileNo ",DocReceiveM.FileNo );
param[7] = SqlHelper.GetParameter("@FileCompany ",DocReceiveM.FileCompany );
param[8] = SqlHelper.GetParameter("@FileTitle ",DocReceiveM.FileTitle );
param[9] = SqlHelper.GetParameter("@FileReason ",DocReceiveM.FileReason );
param[10] = SqlHelper.GetParameter("@KeyWord ",DocReceiveM.KeyWord );
param[11] = SqlHelper.GetParameter("@Description ",DocReceiveM.Description );
param[12] = SqlHelper.GetParameter("@DeptID ",DocReceiveM.DeptID );
param[13] = SqlHelper.GetParameter("@BackerNo ",DocReceiveM.BackerNo );
param[14] = SqlHelper.GetParameter("@Backer ",DocReceiveM.Backer );
//param[15] = SqlHelper.GetParameter("@BackDate ",DocReceiveM.BackDate );
param[15] = SqlHelper.GetParameter("@BackDate", DocReceiveM.BackDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(DocReceiveM.BackDate.ToString()));
param[16] = SqlHelper.GetParameter("@BackContent ",DocReceiveM.BackContent );
param[17] = SqlHelper.GetParameter("@Remark ",DocReceiveM.Remark );
param[18] = SqlHelper.GetParameter("@RegisterUserID ",DocReceiveM.RegisterUserID );
//param[19] = SqlHelper.GetParameter("@UploadDate ",DocReceiveM.UploadDate );
param[19] = SqlHelper.GetParameter("@UploadDate", DocReceiveM.UploadDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(DocReceiveM.UploadDate.ToString()));
param[20] = SqlHelper.GetParameter("@DocumentName ",DocReceiveM.DocumentName );
param[21] = SqlHelper.GetParameter("@DocumentURL ",DocReceiveM.DocumentURL );
//param[22] = SqlHelper.GetParameter("@ModifiedDate ",DocReceiveM.ModifiedDate );
param[22] = SqlHelper.GetParameter("@ModifiedDate", DocReceiveM.ModifiedDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(DocReceiveM.ModifiedDate.ToString()));
param[23] = SqlHelper.GetParameter("@ModifiedUserID ",DocReceiveM.ModifiedUserID );
SqlHelper.ExecuteTransSql(sql.ToString(), param);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
return false;
}
}
/// <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)
{
try
{
#region sql语句
string sql = "select " +
" dr.id,dr.ReceiveDocNo,cp.TypeName,CONVERT(varchar(100), dr.FileDate, 23) FileDate," +
" dr.FileNo,dr.FileCompany DeptName,dr.FileTitle,"+
" (case dr.SecretLevel when '1' then '一般' when '2' then '不公开' when '3' then '秘密' when '4' then '机密' when '5' then '绝密' end)SecretLevel,"+
"(case dr.Critical when '1' then '特提' when '2' then '特急' when '3' then '加急' when '4' then '平急' end) Critical" +
" from " +
" officedba.DocReceiveInfo dr,officedba.CodePublicType cp" +
" where" +
" dr.CompanyCD = '" + DocReceiveM.CompanyCD + "'" +
" and cp.id = dr.ReceiveDocTypeID";
if (DocReceiveM.FileNo != "")
sql += " and dr.FileNo like '%" + DocReceiveM.FileNo + "%'";
if (DocReceiveM.ReceiveDocTypeID != 0)
sql += " and dr.ReceiveDocTypeID = " + DocReceiveM.ReceiveDocTypeID + "";
if (DocReceiveM.Critical != "0")
sql += " and dr.Critical = '" + DocReceiveM.Critical + "'";
if (FileDateBegin.ToString() != "")
sql += " and dr.FileDate >= '" + FileDateBegin.ToString() + "'";
if (FileDateEnd.ToString() != "")
sql += " and dr.FileDate <= '" + FileDateEnd.ToString() + "'";
if (FileCompany != "")
sql += " and dr.FileCompany like '%" + FileCompany + "%'";
if (DocReceiveM.SecretLevel != "0")
sql += " and dr.SecretLevel = '" + DocReceiveM.SecretLevel + "'";
#endregion
return SqlHelper.ExecuteSql(sql);
}
catch
{
return null;
}
}
/// <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)
{
try
{
#region sql语句
string sql = "select " +
" dr.id,dr.ReceiveDocNo,cp.TypeName,CONVERT(varchar(100), dr.FileDate, 23) FileDate," +
" dr.FileNo,dr.FileCompany DeptName,dr.FileTitle,dr.SecretLevel,dr.Critical" +
" from " +
" officedba.DocReceiveInfo dr,officedba.CodePublicType cp" +
" where" +
" dr.CompanyCD = '" + DocReceiveM.CompanyCD + "'" +
" and cp.id = dr.ReceiveDocTypeID";
if (DocReceiveM.FileNo != "")
sql += " and dr.FileNo like '%" + DocReceiveM.FileNo + "%'";
if (DocReceiveM.ReceiveDocTypeID != 0)
sql += " and dr.ReceiveDocTypeID = " + DocReceiveM.ReceiveDocTypeID + "";
if (DocReceiveM.Critical != "0")
sql += " and dr.Critical = '" + DocReceiveM.Critical + "'";
if (FileDateBegin.ToString() != "")
sql += " and dr.FileDate >= '" + FileDateBegin.ToString() + "'";
if (FileDateEnd.ToString() != "")
sql += " and dr.FileDate <= '" + FileDateEnd.ToString() + "'";
if (FileCompany != "")
sql += " and dr.FileCompany like '%" + FileCompany + "%'";
if (DocReceiveM.SecretLevel != "0")
sql += " and dr.SecretLevel = '" + DocReceiveM.SecretLevel + "'";
#endregion
//return SqlHelper.ExecuteSql(sql);
return SqlHelper.CreateSqlByPageExcuteSql(sql.ToString(), pageIndex, pageCount, ord, null, ref TotalCount);
}
catch
{
return null;
}
}
/// <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="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);
}
