/// <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); }