/// <summary>
/// 增加一条数据
/// </summary>
public static bool InsertAgendaInfo(PersonalDateArrange model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into officedba.PersonalDateArrange(");
strSql.Append("CompanyCD,ArrangeTItle,Critical,Content,StartDate,StartTime,EndTime,Creator,IsPublic,CreateDate,IsMobileNotice,AheadTimes,ModifiedDate,ModifiedUserID,Important)");
strSql.Append(" values (");
strSql.Append("@CompanyCD,@ArrangeTItle,@Critical,@Content,@StartDate,@StartTime,@EndTime,@Creator,@IsPublic,@CreateDate,@IsMobileNotice,@AheadTimes,@ModifiedDate,@ModifiedUserID,@Important)");
strSql.Append("; select @SourceID = @@IDENTITY ");
if (model.IsMobileNotice == "1")
{
strSql.Append("insert into officedba.NoticeHistory(");
strSql.Append(" CompanyCD,SourceFlag,SourceID,PlanNoticeDate ) ");
strSql.Append(" values(@CompanyCD, @SourceFlag,@SourceID,@PlanNoticeDate ) ");
}
SqlParameter[] parameters = {
new SqlParameter("@CompanyCD", SqlDbType.VarChar,8),
new SqlParameter("@ArrangeNo", SqlDbType.VarChar,50),
new SqlParameter("@ArrangeTItle", SqlDbType.VarChar,100),
new SqlParameter("@Critical", SqlDbType.Char,1),
new SqlParameter("@Content", SqlDbType.VarChar,200),
new SqlParameter("@StartDate", SqlDbType.DateTime),
new SqlParameter("@StartTime", SqlDbType.VarChar,4),
new SqlParameter("@EndTime", SqlDbType.VarChar,4),
new SqlParameter("@Creator", SqlDbType.Int,4),
new SqlParameter("@IsPublic", SqlDbType.Char,1),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@IsMobileNotice", SqlDbType.Char,1),
new SqlParameter("@AheadTimes", SqlDbType.Int,4),
new SqlParameter("@ModifiedDate", SqlDbType.DateTime),
new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,10),
new SqlParameter("@SourceFlag", SqlDbType.Char,1),
new SqlParameter("@PlanNoticeDate", SqlDbType.DateTime) ,
new SqlParameter("@SourceID", SqlDbType.Int,4),
new SqlParameter("@Important", SqlDbType.Char,1) };
parameters[0].Value = model.CompanyCD;
parameters[1].Value = "未定义";
parameters[2].Value = model.ArrangeTItle;
parameters[3].Value = model.Critical;
parameters[4].Value = model.Content;
parameters[5].Value = model.StartDate;
parameters[6].Value = model.StartTime;
parameters[7].Value = model.EndTime;
parameters[8].Value = model.Creator;
parameters[9].Value = model.IsPublic;
parameters[10].Value = DateTime.Now;
parameters[11].Value = model.IsMobileNotice;
parameters[12].Value = model.AheadTimes;
parameters[13].Value = DateTime.Now;
parameters[14].Value = model.ModifiedUserID;
parameters[15].Value = '1';
if (model.IsMobileNotice == "1")
{
try
{
double hour = Convert.ToDouble(model.StartTime.Substring(0, 2));
double minite = Convert.ToDouble(model.StartTime.Substring(2, 2));
DateTime datetime = (DateTime)model.StartDate;
datetime = datetime.AddHours(hour);
datetime = datetime.AddMinutes(minite);
double aheadtime = Convert.ToDouble(model.AheadTimes) * -1;
datetime = datetime.AddHours(aheadtime);
parameters[16].Value = datetime;
}
catch
{
parameters[16].Value = DateTime.Now;
}
}
else
{
parameters[16].Value = DateTime.Now;
}
parameters[17].Value = 0;
parameters[18].Value = model.Important;
//定义更新基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = strSql.ToString();
//设置保存的参数
foreach (SqlParameter sqp in parameters)
comm.Parameters.Add(sqp);
//返回操作结果
return SqlHelper.ExecuteTransWithCommand(comm);
}
public static bool SaveAgendaInfo(PersonalDateArrange model)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
model.CompanyCD = userInfo.CompanyCD;
//定义返回变量
bool isSucc = false;
//ID存在时，更新
if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag))
{
try
{
//执行更新操作
isSucc = AgendaInfoDBHelper.UpdateAgendaInfo(model);
LogInfoModel logModel = InitLogInfo("更新日程");
if (isSucc)
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
logModel.ModuleID = "10411";
LogDBHelper.InsertLog(logModel);
}
catch (Exception ex)
{
WriteSystemLog(userInfo, ex, ConstUtil.MODULE_ID_AGENDA_INFO);
}
}
//插入
else
{
try
{
//执行插入操作
isSucc = AgendaInfoDBHelper.InsertAgendaInfo(model);
LogInfoModel logModel = InitLogInfo("新建日程");
if (isSucc)
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
logModel.ModuleID = "10411";
LogDBHelper.InsertLog(logModel);
}
catch (Exception ex)
{
WriteSystemLog(userInfo, ex, ConstUtil.MODULE_ID_AGENDA_INFO);
}
}
return isSucc;
}