/// <summary>
/// 添加会议通知的方法
/// </summary>
/// <param name="MeetingInfoM">会议通知信息</param>
/// <returns>被添加会议通知ID</returns>
public static int MeetingInfoAdd(MeetingInfoModel MeetingInfoM)
{
try
{
#region 设置参数
SqlParameter[] param = new SqlParameter[25];
param[0] = SqlHelper.GetParameter("@CompanyCD ", MeetingInfoM.CompanyCD);
param[1] = SqlHelper.GetParameter("@MeetingNo ", MeetingInfoM.MeetingNo);
param[2] = SqlHelper.GetParameter("@Title ", MeetingInfoM.Title);
param[3] = SqlHelper.GetParameter("@TypeID ", MeetingInfoM.TypeID);
param[4] = SqlHelper.GetParameter("@Caller ", MeetingInfoM.Caller);
param[5] = SqlHelper.GetParameter("@DeptID ", MeetingInfoM.DeptID);
param[6] = SqlHelper.GetParameter("@Chairman ", MeetingInfoM.Chairman);
param[7] = SqlHelper.GetParameter("@StartDate", MeetingInfoM.StartDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(MeetingInfoM.StartDate.ToString()));
param[8] = SqlHelper.GetParameter("@StartTime ", MeetingInfoM.StartTime);
param[9] = SqlHelper.GetParameter("@TimeLong ", MeetingInfoM.TimeLong);
param[10] = SqlHelper.GetParameter("@Place ", MeetingInfoM.Place);
param[11] = SqlHelper.GetParameter("@Topic ", MeetingInfoM.Topic);
param[12] = SqlHelper.GetParameter("@Contents ", MeetingInfoM.Contents);
param[13] = SqlHelper.GetParameter("@ReadyInfo ", MeetingInfoM.ReadyInfo);
param[14] = SqlHelper.GetParameter("@Attachment ", MeetingInfoM.Attachment);
param[15] = SqlHelper.GetParameter("@Remark ", MeetingInfoM.Remark);
param[16] = SqlHelper.GetParameter("@MeetingStatus ", MeetingInfoM.MeetingStatus);
param[17] = SqlHelper.GetParameter("@IsMobileCall ", MeetingInfoM.IsMobileCall);
param[18] = SqlHelper.GetParameter("@CallContent ", MeetingInfoM.CallContent);
param[19] = SqlHelper.GetParameter("@JoinUser ", MeetingInfoM.JoinUser);
param[20] = SqlHelper.GetParameter("@Sender ", MeetingInfoM.Sender);
param[21] = SqlHelper.GetParameter("@SendDate", MeetingInfoM.SendDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(MeetingInfoM.SendDate.ToString()));
param[22] = SqlHelper.GetParameter("@ModifiedDate ", MeetingInfoM.ModifiedDate);
param[23] = SqlHelper.GetParameter("@ModifiedUserID", MeetingInfoM.ModifiedUserID);
SqlParameter paramid = new SqlParameter("@id", SqlDbType.Int);
paramid.Direction = ParameterDirection.Output;
param[24] = paramid;
#endregion
//创建命令
SqlCommand comm = new SqlCommand();
SqlHelper.ExecuteTransStoredProcedure("officedba.insertMeetingInfo", comm, param);
int MeetingInfoID = Convert.ToInt32(comm.Parameters["@id"].Value);
return(MeetingInfoID);
}
catch
{
return(0);
}
}
/// <summary>
/// 根据会议通知ID修改会议通知信息
/// </summary>
/// <param name="MeetingInfoM">会议通知信息</param>
/// <returns>bool值</returns>
public static bool UpdateMeetingInfo(MeetingInfoModel MeetingInfoM)
{
try
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE officedba.MeetingInfo set ");
sql.AppendLine("CompanyCD =@CompanyCD ,");
//sql.AppendLine("MeetingNo =@MeetingNo ,");
sql.AppendLine("Title =@Title ,");
sql.AppendLine("TypeID =@TypeID ,");
sql.AppendLine("Caller =@Caller ,");
sql.AppendLine("DeptID =@DeptID ,");
sql.AppendLine("Chairman =@Chairman ,");
sql.AppendLine("StartDate =@StartDate ,");
sql.AppendLine("StartTime =@StartTime ,");
sql.AppendLine("TimeLong =@TimeLong ,");
sql.AppendLine("Place =@Place ,");
sql.AppendLine("Topic =@Topic ,");
sql.AppendLine("Contents =@Contents ,");
sql.AppendLine("ReadyInfo =@ReadyInfo ,");
sql.AppendLine("Attachment =@Attachment ,");
sql.AppendLine("Remark =@Remark ,");
sql.AppendLine("IsMobileCall =@IsMobileCall ,");
sql.AppendLine("CallContent =@CallContent ,");
sql.AppendLine("JoinUser =@JoinUser ,");
sql.AppendLine("Sender =@Sender ,");
sql.AppendLine("SendDate =@SendDate ,");
sql.AppendLine("ModifiedDate =@ModifiedDate ,");
sql.AppendLine("ModifiedUserID=@ModifiedUserID");
sql.AppendLine(" WHERE ");
sql.AppendLine("ID = @ID ");
SqlParameter[] param = new SqlParameter[23];
param[0] = SqlHelper.GetParameter("@ID ", MeetingInfoM.ID);
param[1] = SqlHelper.GetParameter("@CompanyCD ", MeetingInfoM.CompanyCD);
param[2] = SqlHelper.GetParameter("@Title ", MeetingInfoM.Title);
param[3] = SqlHelper.GetParameter("@TypeID ", MeetingInfoM.TypeID);
param[4] = SqlHelper.GetParameter("@Caller ", MeetingInfoM.Caller);
param[5] = SqlHelper.GetParameter("@DeptID ", MeetingInfoM.DeptID);
param[6] = SqlHelper.GetParameter("@Chairman ", MeetingInfoM.Chairman);
//param[7] = SqlHelper.GetParameter("@StartDate ",MeetingInfoM.StartDate );
param[7] = SqlHelper.GetParameter("@StartDate", MeetingInfoM.StartDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(MeetingInfoM.StartDate.ToString()));
param[8] = SqlHelper.GetParameter("@StartTime ", MeetingInfoM.StartTime);
param[9] = SqlHelper.GetParameter("@TimeLong ", MeetingInfoM.TimeLong);
param[10] = SqlHelper.GetParameter("@Place ", MeetingInfoM.Place);
param[11] = SqlHelper.GetParameter("@Topic ", MeetingInfoM.Topic);
param[12] = SqlHelper.GetParameter("@Contents ", MeetingInfoM.Contents);
param[13] = SqlHelper.GetParameter("@ReadyInfo ", MeetingInfoM.ReadyInfo);
param[14] = SqlHelper.GetParameter("@Attachment ", MeetingInfoM.Attachment);
param[15] = SqlHelper.GetParameter("@Remark ", MeetingInfoM.Remark);
param[16] = SqlHelper.GetParameter("@IsMobileCall ", MeetingInfoM.IsMobileCall);
param[17] = SqlHelper.GetParameter("@CallContent ", MeetingInfoM.CallContent);
param[18] = SqlHelper.GetParameter("@JoinUser ", MeetingInfoM.JoinUser);
param[19] = SqlHelper.GetParameter("@Sender ", MeetingInfoM.Sender);
//param[21] = SqlHelper.GetParameter("@SendDate ",MeetingInfoM.SendDate );
param[20] = SqlHelper.GetParameter("@SendDate", MeetingInfoM.SendDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(MeetingInfoM.SendDate.ToString()));
param[21] = SqlHelper.GetParameter("@ModifiedDate ", MeetingInfoM.ModifiedDate);
param[22] = SqlHelper.GetParameter("@ModifiedUserID", MeetingInfoM.ModifiedUserID);
SqlHelper.ExecuteTransSql(sql.ToString(), param);
return(SqlHelper.Result.OprateCount > 0 ? true : false);
}
catch
{
return(false);
}
}
/// <summary>
/// 导出会议通知列表
/// </summary>
/// <param name="MeetingInfoM"></param>
/// <param name="FileDateBegin"></param>
/// <param name="FileDateEnd"></param>
/// <param name="ord"></param>
/// <returns></returns>
public static DataTable ExportMeetingInfo(MeetingInfoModel MeetingInfoM, string FileDateBegin, string FileDateEnd, string ord)
{
try
{
#region sql语句
string sql = "select " +
" mi.ID,mi.MeetingNo,mi.Title," +
" mi.DeptID,isnull(di.DeptName,'') DeptName," +
" mi.Caller,isnull(ei.EmployeeName,'') EmployeeName," +
" CONVERT(varchar(100), mi.StartDate, 23)+' '+mi.StartTime StartDate," +
" mi.Place,mr.RoomName," +
" (case mi.MeetingStatus when '1' then '草稿' when '2' then '延期' when '3' then '取消' when '4' then '已通知' end)MeetingStatus," +
" mi.Sender,isnull(eis.EmployeeName,'') SenderName " +
" ,isnull(mrc.MeetingNo,'') ishave" +
" from " +
" officedba.MeetingInfo mi" +
" left join officedba.DeptInfo di on di.id = mi.DeptID" +
" left join officedba.EmployeeInfo ei on ei.id = mi.Caller" +
" left join officedba.MeetingRoom mr on mr.id = mi.Place" +
" left join officedba.EmployeeInfo eis on eis.id = mi.Sender" +
" left join officedba.MeetingRecord mrc on mrc.MeetingNo = mi.MeetingNo" +
" where" +
" mi.CompanyCD = '" + MeetingInfoM.CompanyCD + "'";
if (MeetingInfoM.MeetingNo != "")
{
sql += " and mi.MeetingNo like '%" + MeetingInfoM.MeetingNo + "%'";
}
if (MeetingInfoM.MeetingStatus != "0")
{
sql += " and mi.MeetingStatus = '" + MeetingInfoM.MeetingStatus + "'";
}
if (MeetingInfoM.Place != 0)
{
sql += " and mi.Place = " + MeetingInfoM.Place + "";
}
if (MeetingInfoM.DeptID != 0)
{
sql += " and mi.DeptID = " + MeetingInfoM.DeptID + "";
}
if (MeetingInfoM.Title != "")
{
sql += " and mi.Title like '%" + MeetingInfoM.Title + "%'";
}
if (MeetingInfoM.Caller != 0)
{
sql += " and mi.Caller = " + MeetingInfoM.Caller + "";
}
if (MeetingInfoM.Sender != 0)
{
sql += " and mi.Sender = " + MeetingInfoM.Sender + "";
}
if (FileDateBegin != "")
{
sql += " and mi.StartDate >= '" + FileDateBegin.ToString() + "'";
}
if (FileDateEnd != "")
{
sql += " and mi.StartDate <= '" + FileDateEnd.ToString() + "'";
}
#endregion
return(SqlHelper.ExecuteSql(sql));
}
catch
{
return(null);
}
}
/// <summary>
/// 根据条件检索会议信息
/// </summary>
/// <param name="MeetingInfoM">会议信息</param>
/// <param name="FileDateBegin">开始时间</param>
/// <param name="FileDateEnd">结束时间</param>
/// <returns>会议列表信息</returns>
public static DataTable GetMeetingInfoBycondition(MeetingInfoModel MeetingInfoM, string FileDateBegin, string FileDateEnd, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
try
{
#region sql语句
string sql = "select " +
" mi.ID,mi.MeetingNo,mi.Title," +
" mi.DeptID,isnull(di.DeptName,'') DeptName," +
" mi.Caller,isnull(ei.EmployeeName,'') EmployeeName," +
" CONVERT(varchar(100), mi.StartDate, 23)+' '+mi.StartTime StartDate," +
" mi.Place,mr.RoomName," +
" mi.MeetingStatus," +
" mi.Sender,isnull(eis.EmployeeName,'') SenderName " +
" ,isnull(mrc.MeetingNo,'') ishave" +
" from " +
" officedba.MeetingInfo mi" +
" left join officedba.DeptInfo di on di.id = mi.DeptID" +
" left join officedba.EmployeeInfo ei on ei.id = mi.Caller" +
" left join officedba.MeetingRoom mr on mr.id = mi.Place" +
" left join officedba.EmployeeInfo eis on eis.id = mi.Sender" +
" left join officedba.MeetingRecord mrc on mrc.MeetingNo = mi.MeetingNo" +
" where" +
" mi.CompanyCD = '" + MeetingInfoM.CompanyCD + "'";
if (MeetingInfoM.MeetingNo != "")
{
sql += " and mi.MeetingNo like '%" + MeetingInfoM.MeetingNo + "%'";
}
if (MeetingInfoM.MeetingStatus != "0")
{
sql += " and mi.MeetingStatus = '" + MeetingInfoM.MeetingStatus + "'";
}
if (MeetingInfoM.Place != 0)
{
sql += " and mi.Place = " + MeetingInfoM.Place + "";
}
if (MeetingInfoM.DeptID != 0)
{
sql += " and mi.DeptID = " + MeetingInfoM.DeptID + "";
}
if (MeetingInfoM.Title != "")
{
sql += " and mi.Title like '%" + MeetingInfoM.Title + "%'";
}
if (MeetingInfoM.Caller != 0)
{
sql += " and mi.Caller = " + MeetingInfoM.Caller + "";
}
if (MeetingInfoM.Sender != 0)
{
sql += " and mi.Sender = " + MeetingInfoM.Sender + "";
}
if (FileDateBegin != "")
{
sql += " and mi.StartDate >= '" + FileDateBegin.ToString() + "'";
}
if (FileDateEnd != "")
{
sql += " and mi.StartDate <= '" + FileDateEnd.ToString() + "'";
}
#endregion
//return SqlHelper.ExecuteSql(sql);
return(SqlHelper.CreateSqlByPageExcuteSql(sql.ToString(), pageIndex, pageCount, ord, null, ref TotalCount));
}
catch
{
return(null);
}
}
/// <summary>
/// 根据会议通知ID修改会议通知信息
/// </summary>
/// <param name="MeetingInfoM">会议通知信息</param>
/// <returns>bool值</returns>
public static bool UpdateMeetingInfo(MeetingInfoModel MeetingInfoM)
{
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_MEETINGINFO_LIST;
//操作单据编号 编号
logModel.ObjectID = MeetingInfoM.MeetingNo;
//操作对象 操作的表信息
logModel.ObjectName = ConstUtil.TABLE_NAME_MEETINGINFO;
//涉及关键元素 涉及其他业务、表关系
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//备注 操作类型
logModel.Remark = ConstUtil.LOG_PROCESS_UPDATE;
#endregion
try
{
isSucc = MeetingInfoDBHelper.UpdateMeetingInfo(MeetingInfoM);
}
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_MEETINGINFO_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="MeetingInfoM"></param>
/// <param name="FileDateBegin"></param>
/// <param name="FileDateEnd"></param>
/// <param name="ord"></param>
/// <returns></returns>
public static DataTable ExportMeetingInfo(MeetingInfoModel MeetingInfoM, string FileDateBegin, string FileDateEnd, string ord)
{
return(MeetingInfoDBHelper.ExportMeetingInfo(MeetingInfoM, FileDateBegin, FileDateEnd, ord));
}
/// <summary>
/// 根据条件检索会议信息
/// </summary>
/// <param name="MeetingInfoM">会议信息</param>
/// <param name="FileDateBegin">开始时间</param>
/// <param name="FileDateEnd">结束时间</param>
/// <returns>会议列表信息</returns>
public static DataTable GetMeetingInfoBycondition(MeetingInfoModel MeetingInfoM, string FileDateBegin, string FileDateEnd, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
return(MeetingInfoDBHelper.GetMeetingInfoBycondition(MeetingInfoM, FileDateBegin, FileDateEnd, pageIndex, pageCount, ord, ref TotalCount));
}
