/// <summary>
/// 修改
/// </summary>
/// <param name="model">会议记录管理实体</param>
/// <returns></returns>
public bool Update(EyouSoft.Model.AdminCenterStructure.MeetingInfo model)
{
bool IsTrue = false;
EyouSoft.Data.MeetingInfo DataModel = dcDal.MeetingInfo.FirstOrDefault(item =>
item.Id == model.Id && item.CompanyId == model.CompanyId
);
if (DataModel != null)
{
DataModel.Location = model.Location;
DataModel.MetttingNo = model.MetttingNo;
DataModel.Personal = model.Personal;
DataModel.Remark = model.Remark;
DataModel.Title = model.Title;
DataModel.BeginDate = model.BeginDate;
DataModel.EndDate = model.EndDate;
dcDal.SubmitChanges();
if (dcDal.ChangeConflicts.Count == 0)
{
IsTrue = true;
}
}
DataModel = null;
return(IsTrue);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model">会议记录管理实体</param>
/// <returns></returns>
public bool Add(EyouSoft.Model.AdminCenterStructure.MeetingInfo model)
{
bool IsTrue = false;
EyouSoft.Data.MeetingInfo DataModel = new EyouSoft.Data.MeetingInfo()
{
EndDate = model.EndDate,
BeginDate = model.BeginDate,
CompanyId = model.CompanyId,
Title = model.Title,
Remark = model.Remark,
Personal = model.Personal,
MetttingNo = model.MetttingNo,
Location = model.Location,
OperatorId = model.OperatorId,
IssueTime = System.DateTime.Now
};
dcDal.MeetingInfo.InsertOnSubmit(DataModel);
dcDal.SubmitChanges();
if (dcDal.ChangeConflicts.Count == 0)
{
IsTrue = true;
}
DataModel = null;
return(IsTrue);
}
/// <summary>
/// 获取会议记录管理信息
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="RecordCount"></param>
/// <param name="CompanyId">公司编号</param>
/// <param name="MeetingNo">会议编号</param>
/// <param name="MeetingTile">会议主题</param>
/// <param name="BeginStart">会议时间开始</param>
/// <param name="BeginEnd">会议时间结束</param>
/// <returns></returns>
public IList <EyouSoft.Model.AdminCenterStructure.MeetingInfo> GetList(int PageSize, int PageIndex, ref int RecordCount, int CompanyId, string MeetingNo, string MeetingTile, DateTime?BeginStart, DateTime?BeginEnd)
{
IList <EyouSoft.Model.AdminCenterStructure.MeetingInfo> ResultList = null;
string tableName = "tbl_MeetingInfo";
string identityColumnName = "Id";
string fields = " [Id],[MetttingNo],[Title],[Personal],[BeginDate],[EndDate],[Location],[Remark] ";
string query = string.Format("[CompanyId]={0}", CompanyId);
if (!string.IsNullOrEmpty(MeetingNo))
{
query = query + string.Format(" AND MetttingNo LIKE'%{0}%'", EyouSoft.Toolkit.Utils.ReplaceXmlSpecialCharacter(MeetingNo));
}
if (!string.IsNullOrEmpty(MeetingTile))
{
query = query + string.Format(" AND Title LIKE'%{0}%'", EyouSoft.Toolkit.Utils.ReplaceXmlSpecialCharacter(MeetingTile));
}
if (BeginStart.HasValue)
{
query = query + string.Format(" AND DATEDIFF(mi,'{0}',BeginDate)>=0", BeginStart);
}
if (BeginEnd.HasValue)
{
query = query + string.Format(" AND DATEDIFF(mi,BeginDate,'{0}')>=0", BeginEnd);
}
string orderByString = " IssueTime DESC";
using (IDataReader dr = DbHelper.ExecuteReader(_db, PageSize, PageIndex, ref RecordCount, tableName, identityColumnName, fields, query, orderByString))
{
ResultList = new List <EyouSoft.Model.AdminCenterStructure.MeetingInfo>();
while (dr.Read())
{
EyouSoft.Model.AdminCenterStructure.MeetingInfo model = new EyouSoft.Model.AdminCenterStructure.MeetingInfo()
{
Id = dr.GetInt32(dr.GetOrdinal("Id")),
BeginDate = dr.GetDateTime(dr.GetOrdinal("BeginDate")),
EndDate = dr.GetDateTime(dr.GetOrdinal("EndDate")),
Location = dr.IsDBNull(dr.GetOrdinal("Location")) ? "" : dr.GetString(dr.GetOrdinal("Location")),
MetttingNo = dr.IsDBNull(dr.GetOrdinal("MetttingNo")) ? "" : dr.GetString(dr.GetOrdinal("MetttingNo")),
Personal = dr.IsDBNull(dr.GetOrdinal("Personal")) ? "" : dr.GetString(dr.GetOrdinal("Personal")),
Title = dr.IsDBNull(dr.GetOrdinal("Title")) ? "" : dr.GetString(dr.GetOrdinal("Title")),
Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark"))
};
ResultList.Add(model);
model = null;
}
};
return(ResultList);
}
/// <summary>
/// 获取会议记录管理实体信息
/// </summary>
/// <param name="CompanyId"></param>
/// <param name="Id"></param>
/// <returns></returns>
public EyouSoft.Model.AdminCenterStructure.MeetingInfo GetModel(int CompanyId, int Id)
{
EyouSoft.Model.AdminCenterStructure.MeetingInfo model = null;
model = (from item in dcDal.MeetingInfo
where item.CompanyId == CompanyId && item.Id == Id
select new EyouSoft.Model.AdminCenterStructure.MeetingInfo
{
Id = item.Id,
BeginDate = item.BeginDate,
EndDate = item.EndDate,
Location = item.Location,
MetttingNo = item.MetttingNo,
Personal = item.Personal,
Remark = item.Remark,
Title = item.Title
}).FirstOrDefault();
return(model);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model">会议记录管理实体</param>
/// <returns></returns>
public bool Add(EyouSoft.Model.AdminCenterStructure.MeetingInfo model)
{
bool IsTrue = false;
IsTrue = idal.Add(model);
#region LGWR
if (IsTrue)
{
EyouSoft.Model.CompanyStructure.SysHandleLogs logInfo = new EyouSoft.Model.CompanyStructure.SysHandleLogs();
logInfo.CompanyId = 0;
logInfo.DepatId = 0;
logInfo.EventCode = EyouSoft.Model.CompanyStructure.SysHandleLogsNO.EventCode;
logInfo.EventIp = string.Empty;
logInfo.EventMessage = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "{0}在" + EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.行政中心_会议记录.ToString() + "新增了会议记录信息数据。";
logInfo.EventTime = DateTime.Now;
logInfo.EventTitle = "新增会议记录信息";
logInfo.ModuleId = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.行政中心_会议记录;
logInfo.OperatorId = 0;
this.Logwr(logInfo);
logInfo = null;
}
#endregion
return(IsTrue);
}
protected void Page_Load(object sender, EventArgs e)
{
int MeetingID = Utils.GetInt(Request.QueryString["MeetingID"], -1);
string Method = Utils.GetFormValue("hidMethod");
if (!IsPostBack && MeetingID != -1)
{
EyouSoft.BLL.AdminCenterStructure.MeetingInfo bllMeetingInfo = new EyouSoft.BLL.AdminCenterStructure.MeetingInfo();
EyouSoft.Model.AdminCenterStructure.MeetingInfo modelMeetingInfo = bllMeetingInfo.GetModel(CurrentUserCompanyID, MeetingID);
if (modelMeetingInfo != null)
{
this.hidMeetingID.Value = modelMeetingInfo.Id.ToString();
MeetingNum = modelMeetingInfo.MetttingNo;
MeetingSubject = modelMeetingInfo.Title;
JoinPersonnel = modelMeetingInfo.Personal;
MeetingTimeBegin = modelMeetingInfo.BeginDate;
MeetingTimeEnd = modelMeetingInfo.EndDate;
MeetingLocale = modelMeetingInfo.Location;
Remark = modelMeetingInfo.Remark;
}
}
if (Method == "save")
{
if (this.hidMeetingID.Value != "")
{
if (!CheckGrant(global::Common.Enum.TravelPermission.行政中心_会议记录_修改记录))
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.行政中心_会议记录_修改记录, true);
}
}
else
{
if (!CheckGrant(global::Common.Enum.TravelPermission.行政中心_会议记录_新增记录))
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.行政中心_会议记录_新增记录, true);
}
}
MeetingNum = Utils.GetFormValue("txt_MeetingNum");
MeetingSubject = Utils.GetFormValue("txt_MeetingSubject");
JoinPersonnel = Utils.GetFormValue("txt_JoinPersonnel");
MeetingTimeBegin = Utils.GetDateTime(Request.Form["txt_MeetingTimeBegin"], Utils.GetDateTime("1900-01-01"));
MeetingTimeEnd = Utils.GetDateTime(Request.Form["txt_MeetingTimeEnd"], Utils.GetDateTime("1900-01-01"));
MeetingLocale = Utils.GetFormValue("txt_MeetingLocale");
Remark = Utils.GetFormValue("txt_Remark");
EyouSoft.BLL.AdminCenterStructure.MeetingInfo bllMeetingInfo = new EyouSoft.BLL.AdminCenterStructure.MeetingInfo();
EyouSoft.Model.AdminCenterStructure.MeetingInfo modelMeetingInfo = new EyouSoft.Model.AdminCenterStructure.MeetingInfo();
modelMeetingInfo.CompanyId = CurrentUserCompanyID;
modelMeetingInfo.MetttingNo = MeetingNum;
modelMeetingInfo.Title = MeetingSubject;
modelMeetingInfo.Personal = JoinPersonnel;
modelMeetingInfo.BeginDate = (MeetingTimeBegin);
modelMeetingInfo.EndDate = (MeetingTimeEnd);
modelMeetingInfo.Location = MeetingLocale;
modelMeetingInfo.Remark = Remark;
modelMeetingInfo.IssueTime = DateTime.Now;
if (this.hidMeetingID.Value != "") //修改
{
modelMeetingInfo.Id = Utils.GetInt(this.hidMeetingID.Value);
if (bllMeetingInfo.Update(modelMeetingInfo))
{
MessageBox.ResponseScript(this, string.Format("alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();window.parent.location='{2}';", "修改成功！", Utils.GetQueryStringValue("iframeId"), "/administrativeCenter/cahierManage/Default.aspx"));
}
else
{
MessageBox.Show(this.Page, "修改失败！");
}
}
else //新增
{
if (bllMeetingInfo.Add(modelMeetingInfo))
{
MessageBox.ResponseScript(this, string.Format("alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();window.parent.location='{2}';", "新增成功！", Utils.GetQueryStringValue("iframeId"), "/administrativeCenter/cahierManage/Default.aspx"));
}
else
{
MessageBox.Show(this.Page, "新增失败！");
}
}
}
}
