/// <summary>
/// 更新一条培训
/// </summary>
/// <param name="model">培训model</param>
/// <param name="ItemType">附件类型</param>
/// <returns></returns>
public bool UpdateGovTrain(EyouSoft.Model.GovStructure.MGovTrain model, EyouSoft.Model.EnumType.ComStructure.AttachItemType ItemType)
{
bool IsTrue = false;
DbCommand dc = this._db.GetStoredProcCommand("proc_GovTrain_Update");
this._db.AddInParameter(dc, "TrainId", DbType.AnsiStringFixedLength, model.TrainId);
this._db.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyId);
this._db.AddInParameter(dc, "StateTime", DbType.DateTime, model.StateTime);
this._db.AddInParameter(dc, "EndTime", DbType.DateTime, model.EndTime);
this._db.AddInParameter(dc, "Title", DbType.String, model.Title);
this._db.AddInParameter(dc, "TrainPeople", DbType.String, model.TrainPeople);
this._db.AddInParameter(dc, "JoinPeople", DbType.String, model.JoinPeople);
this._db.AddInParameter(dc, "TrainingLocations", DbType.String, model.TrainingLocations);
this._db.AddInParameter(dc, "Training", DbType.String, model.Training);
this._db.AddInParameter(dc, "DepartId", DbType.Int32, model.DepartId);
this._db.AddInParameter(dc, "OperatorId", DbType.AnsiStringFixedLength, model.OperatorId);
this._db.AddInParameter(dc, "IssueTime", DbType.DateTime, model.IssueTime);
this._db.AddInParameter(dc, "ItemType", DbType.Byte, (int)ItemType);
this._db.AddInParameter(dc, "ComAttachXML", DbType.Xml, CreateComNoticeXML(model.ComAttachList));
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="model">培训model</param>
/// <returns></returns>
public bool UpdateGovTrain(EyouSoft.Model.GovStructure.MGovTrain model)
{
if (model != null && !string.IsNullOrEmpty(model.TrainId) && !string.IsNullOrEmpty(model.CompanyId) && model.StateTime != null && !string.IsNullOrEmpty(model.OperatorId))
{
if (model.ComAttachList != null && model.ComAttachList.Count > 0)
{
for (int i = 0; i < model.ComAttachList.Count; i++)
{
model.ComAttachList[i].ItemId = model.TrainId;
model.ComAttachList[i].ItemType = ItemType;
}
}
else
{
model.ComAttachList = null;
}
bool result = dal.UpdateGovTrain(model, ItemType);
if (result)
{
SysStructure.BSysLogHandle.Insert("更新一条培训信息：编号为：" + model.TrainId);
}
return(result);
}
return(false);
}
/// <summary>
/// 获得培训实体
/// </summary>
/// <param name="TrainId">培训ID</param>
/// <returns></returns>
public EyouSoft.Model.GovStructure.MGovTrain GetGovTrainModel(string TrainId)
{
EyouSoft.Model.GovStructure.MGovTrain model = null;
if (!string.IsNullOrEmpty(TrainId))
{
model = new EyouSoft.Model.GovStructure.MGovTrain();
model = dal.GetGovTrainModel(TrainId, ItemType);
}
return(model);
}
/// <summary>
/// 根据培训时间条件获得培训信息列表
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="TimeBegin">开始时间</param>
/// <param name="TimeEnd">结束时间</param>
/// <param name="Title">主题</param>
/// <param name="ItemType">附件类型</param>
/// <param name="PageSize">页面数据总记录数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">每页显示的记录数</param>
/// <returns></returns>
public IList <Model.GovStructure.MGovTrain> GetGovTrainList(string CompanyId, DateTime?TimeBegin, DateTime?TimeEnd, string Title, EyouSoft.Model.EnumType.ComStructure.AttachItemType ItemType, int PageSize, int PageIndex, ref int RecordCount)
{
IList <EyouSoft.Model.GovStructure.MGovTrain> ResultList = null;
string tableName = "view_GovTrain";
string identityColumnName = "OpinionId";
string fields = "TrainId,CompanyId,StateTime,EndTime,Title,JoinPeople,TrainingLocations,DepartId,OperatorId,IssueTime,ComAttachXML ";
string query = string.Format(" CompanyId='{0}' ", CompanyId, (int)ItemType);
if (!string.IsNullOrEmpty(Title))
{
query = query + string.Format(" AND Title like '%{0}%' ", Title);
}
if (!string.IsNullOrEmpty(TimeBegin.ToString()))
{
query = query + string.Format(" AND datediff(dd, '{0}', StateTime) >= 0", TimeBegin);
}
if (!string.IsNullOrEmpty(TimeEnd.ToString()))
{
query = query + string.Format(" AND datediff(dd, '{0}', EndTime) <= 0", TimeEnd);
}
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.MGovTrain>();
EyouSoft.Model.GovStructure.MGovTrain model = null;
while (dr.Read())
{
model = new EyouSoft.Model.GovStructure.MGovTrain();
model.TrainId = dr.GetString(dr.GetOrdinal("TrainId"));
model.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId"));
if (!dr.IsDBNull(dr.GetOrdinal("StateTime")))
{
model.StateTime = dr.GetDateTime(dr.GetOrdinal("StateTime"));
}
if (!dr.IsDBNull(dr.GetOrdinal("EndTime")))
{
model.EndTime = dr.GetDateTime(dr.GetOrdinal("EndTime"));
}
model.Title = dr.IsDBNull(dr.GetOrdinal("Title")) ? "" : dr.GetString(dr.GetOrdinal("Title"));
model.JoinPeople = dr.IsDBNull(dr.GetOrdinal("JoinPeople")) ? "" : dr.GetString(dr.GetOrdinal("JoinPeople"));
model.TrainingLocations = dr.IsDBNull(dr.GetOrdinal("TrainingLocations")) ? "" : dr.GetString(dr.GetOrdinal("TrainingLocations"));
model.DepartId = dr.GetInt32(dr.GetOrdinal("DepartId"));
model.OperatorId = dr.GetString(dr.GetOrdinal("OperatorId"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.ComAttachList = this.GetAttachList(dr["ComAttachXML"].ToString(), dr.GetString(dr.GetOrdinal("TrainId")), ItemType);
ResultList.Add(model);
model = null;
}
};
return(ResultList);
}
/// <summary>
/// 获得培训实体
/// </summary>
/// <param name="TrainId">培训ID</param>
/// <param name="ItemType">附件类型</param>
/// <returns></returns>
public EyouSoft.Model.GovStructure.MGovTrain GetGovTrainModel(string TrainId, EyouSoft.Model.EnumType.ComStructure.AttachItemType ItemType)
{
EyouSoft.Model.GovStructure.MGovTrain model = null;
StringBuilder StrSql = new StringBuilder();
StrSql.Append("SELECT TrainId,CompanyId,StateTime,EndTime,Title,TrainPeople,JoinPeople,TrainingLocations,Training,DepartId,OperatorId,IssueTime, ");
StrSql.AppendFormat(" (SELECT Name,FilePath,Size,Downloads FROM tbl_ComAttach WHERE ItemType={0} AND ItemId=a.TrainId FOR XML RAW,ROOT('ROOT'))AS ComAttachXML ", (int)ItemType);
StrSql.AppendFormat(" FROM tbl_GovTrain a WHERE TrainId='{0}' ", TrainId);
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.MGovTrain();
model.TrainId = dr.GetString(dr.GetOrdinal("TrainId"));
model.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId"));
if (!dr.IsDBNull(dr.GetOrdinal("StateTime")))
{
model.StateTime = dr.GetDateTime(dr.GetOrdinal("StateTime"));
}
if (!dr.IsDBNull(dr.GetOrdinal("EndTime")))
{
model.EndTime = dr.GetDateTime(dr.GetOrdinal("EndTime"));
}
model.Title = dr.IsDBNull(dr.GetOrdinal("Title")) ? "" : dr.GetString(dr.GetOrdinal("Title"));
model.TrainPeople = dr.IsDBNull(dr.GetOrdinal("TrainPeople")) ? "" : dr.GetString(dr.GetOrdinal("TrainPeople"));
model.JoinPeople = dr.IsDBNull(dr.GetOrdinal("JoinPeople")) ? "" : dr.GetString(dr.GetOrdinal("JoinPeople"));
model.TrainingLocations = dr.IsDBNull(dr.GetOrdinal("TrainingLocations")) ? "" : dr.GetString(dr.GetOrdinal("TrainingLocations"));
model.Training = dr.IsDBNull(dr.GetOrdinal("Training")) ? "" : dr.GetString(dr.GetOrdinal("Training"));
model.DepartId = dr.GetInt32(dr.GetOrdinal("DepartId"));
model.OperatorId = dr.GetString(dr.GetOrdinal("OperatorId"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.ComAttachList = this.GetAttachList(dr["ComAttachXML"].ToString(), TrainId, ItemType);
}
};
return(model);
}
