/// <summary>
/// 获得会议管理信息列表
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="MSearchMeeting">会议查询实体</param>
/// <param name="PageSize">页面数据总记录数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">每页显示的记录数</param>
/// <returns></returns>
public IList <Model.GovStructure.MGovMeeting> GetGovMeetingList(string CompanyId, EyouSoft.Model.GovStructure.MSearchMeeting MSearchMeeting, int PageSize, int PageIndex, ref int RecordCount)
{
IList <EyouSoft.Model.GovStructure.MGovMeeting> ResultList = null;
//string tableName = "view_GovMeeting";
//string identityColumnName = "MeetingId";
//string fields = "MeetingId,CompanyID,Number,Category,Theme,StartTime,EndTime,Venue,Minutes,OperatorId,IssueTime,GovMeetingStaff ";
string tableName = "tbl_GovMeeting";
string identityColumnName = "MeetingId";
string fields = "MeetingId,CompanyID,Number,Category,Theme,MeetingStaff,StartTime,EndTime,Venue,Minutes,OperatorId,IssueTime ";
string query = string.Format(" CompanyId='{0}'", CompanyId);
if (MSearchMeeting != null)
{
if (!string.IsNullOrEmpty(MSearchMeeting.Number))
{
query = query + string.Format(" AND [Number] LIKE '%{0}%'", MSearchMeeting.Number);
}
if (!string.IsNullOrEmpty(MSearchMeeting.Theme))
{
query = query + string.Format(" AND [Theme] LIKE '%{0}%'", MSearchMeeting.Theme);
}
if (MSearchMeeting.StartTime != null)
{
query = query + string.Format(" AND StartTime >='{0}' ", MSearchMeeting.StartTime);
}
if (MSearchMeeting.EndTime != null)
{
query = query + string.Format(" AND EndTime <='{0}' ", MSearchMeeting.EndTime);
}
}
string orderByString = " IssueTime DESC";
using (IDataReader dr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(_db, PageSize, PageIndex, ref RecordCount, tableName, identityColumnName, fields, query, orderByString))
{
ResultList = new List <EyouSoft.Model.GovStructure.MGovMeeting>();
while (dr.Read())
{
EyouSoft.Model.GovStructure.MGovMeeting model = new EyouSoft.Model.GovStructure.MGovMeeting()
{
MeetingId = dr.GetString(dr.GetOrdinal("MeetingId")),
CompanyID = dr.GetString(dr.GetOrdinal("CompanyId")),
Number = dr.IsDBNull(dr.GetOrdinal("Number")) ? "" : dr.GetString(dr.GetOrdinal("Number")),
//Category = (EyouSoft.Model.EnumType.GovStructure.Category)Enum.Parse(typeof(EyouSoft.Model.EnumType.GovStructure.Category), dr.GetByte(dr.GetOrdinal("Category"))),
Category = (EyouSoft.Model.EnumType.GovStructure.Category)dr.GetByte(dr.GetOrdinal("Category")),
Theme = dr.IsDBNull(dr.GetOrdinal("Theme")) ? "" : dr.GetString(dr.GetOrdinal("Theme")),
StartTime = dr.GetDateTime(dr.GetOrdinal("StartTime")),
EndTime = dr.GetDateTime(dr.GetOrdinal("EndTime")),
Venue = dr.IsDBNull(dr.GetOrdinal("Venue")) ? "" : dr.GetString(dr.GetOrdinal("Venue")),
Minutes = dr.IsDBNull(dr.GetOrdinal("Minutes")) ? "" : dr.GetString(dr.GetOrdinal("Minutes")),
OperatorId = dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? "" : dr.GetString(dr.GetOrdinal("OperatorId")),
IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")),
//MGovMeetingStaff = this.GetMeetingStaffListXML(dr["GovMeetingStaff"].ToString(), dr.GetString(dr.GetOrdinal("MeetingId")))
MeetingStaff = dr.IsDBNull(dr.GetOrdinal("MeetingStaff")) ? "" : dr.GetString(dr.GetOrdinal("MeetingStaff"))
};
ResultList.Add(model);
model = null;
}
};
return(ResultList);
}
/// <summary>
/// 增加一条会议管理
/// </summary>
/// <param name="model">会议管理model</param>
/// <returns></returns>
public bool AddGovMeeting(EyouSoft.Model.GovStructure.MGovMeeting model)
{
bool IsTrue = false;
DbCommand dc = this._db.GetStoredProcCommand("proc_GovMeeting_Add");
this._db.AddInParameter(dc, "MeetingId", DbType.AnsiStringFixedLength, model.MeetingId);
this._db.AddInParameter(dc, "CompanyID", DbType.AnsiStringFixedLength, model.CompanyID);
this._db.AddInParameter(dc, "Number", DbType.String, model.Number);
this._db.AddInParameter(dc, "Category", DbType.Byte, (int)model.Category);
this._db.AddInParameter(dc, "Theme", DbType.String, model.Theme);
this._db.AddInParameter(dc, "MeetingStaff", DbType.String, model.MeetingStaff);
this._db.AddInParameter(dc, "StartTime", DbType.DateTime, model.StartTime);
this._db.AddInParameter(dc, "EndTime", DbType.DateTime, model.EndTime);
this._db.AddInParameter(dc, "Venue", DbType.String, model.Venue);
this._db.AddInParameter(dc, "Minutes", DbType.String, model.Minutes);
this._db.AddInParameter(dc, "OperatorId", DbType.AnsiStringFixedLength, model.OperatorId);
this._db.AddInParameter(dc, "IssueTime", DbType.DateTime, model.IssueTime);
//this._db.AddInParameter(dc, "MeetingStaffListXML", DbType.Xml, CreateMeetingStaffListXML(model.MGovMeetingStaff));
this._db.AddInParameter(dc, "MeetingStaffListXML", DbType.Xml, null);
this._db.AddOutParameter(dc, "Result", DbType.Int32, 4);
EyouSoft.Toolkit.DAL.DbHelper.RunProcedure(dc, this._db);
object Result = this._db.GetParameterValue(dc, "Result");
if (!Result.Equals(null))
{
IsTrue = int.Parse(Result.ToString()) > 0 ? true : false;
}
return(IsTrue);
}
/// <summary>
/// 获得会议管理实体
/// </summary>
/// <param name="MeetingId">会议管理ID</param>
/// <returns></returns>
public EyouSoft.Model.GovStructure.MGovMeeting GetGovMeetingModel(string MeetingId)
{
EyouSoft.Model.GovStructure.MGovMeeting model = null;
StringBuilder StrSql = new StringBuilder();
StrSql.Append("SELECT MeetingId,CompanyID,Number,Category,Theme,MeetingStaff,StartTime,EndTime,Venue,Minutes,OperatorId,IssueTime ");
//StrSql.Append(" (SELECT ID,Name FROM tbl_GovFile WHERE ID IN(SELECT AcceptTypeID from tbl_GovMeetingStaff WHERE MeetingId=a.MeetingId) FOR XML RAW,ROOT('ROOT'))AS GovMeetingStaff ");
StrSql.AppendFormat(" FROM tbl_GovMeeting a WHERE MeetingId='{0}' ", MeetingId);
DbCommand dc = this._db.GetSqlStringCommand(StrSql.ToString());
using (IDataReader dr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(dc, this._db))
{
if (dr.Read())
{
model = new EyouSoft.Model.GovStructure.MGovMeeting()
{
MeetingId = dr.GetString(dr.GetOrdinal("MeetingId")),
CompanyID = dr.GetString(dr.GetOrdinal("CompanyId")),
Number = dr.IsDBNull(dr.GetOrdinal("Number")) ? "" : dr.GetString(dr.GetOrdinal("Number")),
//Category = (EyouSoft.Model.EnumType.GovStructure.Category)Enum.Parse(typeof(EyouSoft.Model.EnumType.GovStructure.Category), dr.GetString(dr.GetOrdinal("Category"))),
Category = (EyouSoft.Model.EnumType.GovStructure.Category)dr.GetByte(dr.GetOrdinal("Category")),
Theme = dr.IsDBNull(dr.GetOrdinal("Theme")) ? "" : dr.GetString(dr.GetOrdinal("Theme")),
StartTime = dr.GetDateTime(dr.GetOrdinal("StartTime")),
EndTime = dr.GetDateTime(dr.GetOrdinal("EndTime")),
Venue = dr.IsDBNull(dr.GetOrdinal("Venue")) ? "" : dr.GetString(dr.GetOrdinal("Venue")),
Minutes = dr.IsDBNull(dr.GetOrdinal("Minutes")) ? "" : dr.GetString(dr.GetOrdinal("Minutes")),
OperatorId = dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? "" : dr.GetString(dr.GetOrdinal("OperatorId")),
IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")),
//MGovMeetingStaff = this.GetMeetingStaffListXML(dr["GovMeetingStaff"].ToString(), dr.GetString(dr.GetOrdinal("MeetingId")))
MeetingStaff = dr.IsDBNull(dr.GetOrdinal("MeetingStaff")) ? "" : dr.GetString(dr.GetOrdinal("MeetingStaff"))
};
}
};
return(model);
}
/// <summary>
/// 获得会议管理实体
/// </summary>
/// <param name="MeetingId">会议管理ID</param>
/// <returns></returns>
public EyouSoft.Model.GovStructure.MGovMeeting GetGovMeetingModel(string MeetingId)
{
EyouSoft.Model.GovStructure.MGovMeeting model = null;
if (!string.IsNullOrEmpty(MeetingId))
{
model = new EyouSoft.Model.GovStructure.MGovMeeting();
model = dal.GetGovMeetingModel(MeetingId);
}
return(model);
}
/// <summary>
/// 更新一条会议管理
/// </summary>
/// <param name="model">会议管理model</param>
/// <returns></returns>
public bool UpdateGovMeeting(EyouSoft.Model.GovStructure.MGovMeeting model)
{
if (model != null && !string.IsNullOrEmpty(model.MeetingId) && !string.IsNullOrEmpty(model.CompanyID) && !string.IsNullOrEmpty(model.Number) && model.Category != null &&
!string.IsNullOrEmpty(model.Theme) && model.StartTime != null && model.EndTime != null && !string.IsNullOrEmpty(model.Venue) && !string.IsNullOrEmpty(model.OperatorId))
{
if (model.MGovMeetingStaff != null && model.MGovMeetingStaff.Count > 0)
{
for (int i = 0; i < model.MGovMeetingStaff.Count; i++)
{
model.MGovMeetingStaff[i].MeetingId = model.MeetingId;
}
}
bool result = dal.UpdateGovMeeting(model);
if (result)
{
SysStructure.BSysLogHandle.Insert("更新一条会议管理：编号为：" + model.MeetingId);
}
return(result);
}
return(false);
}