/// <summary>
/// 修改
/// </summary>
/// <param name="model">培训计划实体</param>
/// <returns></returns>
public bool Update(EyouSoft.Model.AdminCenterStructure.TrainPlan model)
{
bool IsTrue = false;
string TrainPlanAcceptXML = CreateTrainPlanAcceptXML(model.AcceptList);
DbCommand dc = this._db.GetStoredProcCommand("proc_TrainPlan_Update");
this._db.AddInParameter(dc, "TrainPlanId", DbType.Int32, model.Id);
this._db.AddInParameter(dc, "CompanyId", DbType.Int32, model.CompanyId);
this._db.AddInParameter(dc, "PlanTitle", DbType.AnsiString, model.PlanTitle);
this._db.AddInParameter(dc, "PlanContent", DbType.AnsiString, model.PlanContent);
this._db.AddInParameter(dc, "TrainPlanFile", DbType.AnsiString, model.TrainPlanFile);
this._db.AddInParameter(dc, "OperatorId", DbType.Int32, model.OperatorId);
this._db.AddInParameter(dc, "OperatorName", DbType.AnsiString, model.OperatorName);
this._db.AddInParameter(dc, "TrainPlanAcceptXML", DbType.AnsiString, TrainPlanAcceptXML);
this._db.AddInParameter(dc, "IssueTime", DbType.DateTime, model.IssueTime);
this._db.AddInParameter(dc, "Result", DbType.Int32, 4);
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="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="RecordCount"></param>
/// <param name="CompanyId">公司编号</param>
/// <param name="UserId">当前用户编号</param>
/// <param name="DepartmentId">部门编号</param>
/// <returns></returns>
public IList <EyouSoft.Model.AdminCenterStructure.TrainPlan> GetList(int PageSize, int PageIndex, ref int RecordCount, int CompanyId, int UserId, int DepartmentId)
{
IList <EyouSoft.Model.AdminCenterStructure.TrainPlan> ResultList = null;
string tableName = "tbl_TrainPlan";
string identityColumnName = "Id";
string fields = "[Id],[PlanTitle],[PlanContent],[OperatorName],IssueTime,(SELECT [AcceptType],[AcceptId] FROM [tbl_TrainPlanAccepts] WHERE TrainPlanId=[tbl_TrainPlan].[Id] FOR XML Raw,Root('Root')) AS TrainPlanAcceptXML";
StringBuilder query = new StringBuilder();
query.AppendFormat(" [CompanyId]={0} AND ", CompanyId);
query.Append(" ( exists(SELECT 1 FROM tbl_TrainPlanAccepts WHERE TrainPlanId=[tbl_TrainPlan].[id] AND AcceptType=0) OR ");
query.AppendFormat(" exists(SELECT 1 FROM tbl_TrainPlanAccepts WHERE TrainPlanId=[tbl_TrainPlan].[id] AND AcceptType=1 AND AcceptId={0}) OR ", DepartmentId);
query.AppendFormat(" exists(SELECT 1 FROM tbl_TrainPlanAccepts WHERE TrainPlanId=[tbl_TrainPlan].[id] AND AcceptType=2 AND AcceptId={0})) ", UserId);
string orderByString = " IssueTime DESC";
using (IDataReader dr = DbHelper.ExecuteReader(_db, PageSize, PageIndex, ref RecordCount, tableName, identityColumnName, fields, query.ToString(), orderByString))
{
ResultList = new List <EyouSoft.Model.AdminCenterStructure.TrainPlan>();
while (dr.Read())
{
EyouSoft.Model.AdminCenterStructure.TrainPlan model = new EyouSoft.Model.AdminCenterStructure.TrainPlan()
{
Id = dr.GetInt32(dr.GetOrdinal("Id")),
OperatorName = dr.IsDBNull(dr.GetOrdinal("OperatorName")) ? "" : dr.GetString(dr.GetOrdinal("OperatorName")),
PlanContent = dr.IsDBNull(dr.GetOrdinal("PlanContent")) ? "" : dr.GetString(dr.GetOrdinal("PlanContent")),
PlanTitle = dr.IsDBNull(dr.GetOrdinal("PlanTitle")) ? "" : dr.GetString(dr.GetOrdinal("PlanTitle")),
IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")),
AcceptList = GetAcceptList(dr["TrainPlanAcceptXML"].ToString())
};
ResultList.Add(model);
model = null;
}
};
return(ResultList);
}
/// <summary>
/// 获取培训计划实体信息
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="Id">培训编号（主键）</param>
/// <returns></returns>
public EyouSoft.Model.AdminCenterStructure.TrainPlan GetModel(int CompanyId, int Id)
{
EyouSoft.Model.AdminCenterStructure.TrainPlan model = null;
string StrSql = "SELECT [Id],[PlanTitle],[PlanContent],[OperatorName],IssueTime,TrainPlanFile,(SELECT [AcceptType],[AcceptId] FROM [tbl_TrainPlanAccepts] WHERE TrainPlanId=[tbl_TrainPlan].[Id] FOR XML Raw,Root('Root')) AS TrainPlanAcceptXML FROM tbl_TrainPlan WHERE CompanyId=@CompanyId AND Id=@Id";
DbCommand dc = this._db.GetSqlStringCommand(StrSql);
this._db.AddInParameter(dc, "CompanyId", DbType.Int32, CompanyId);
this._db.AddInParameter(dc, "Id", DbType.Int32, Id);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db))
{
while (dr.Read())
{
model = new EyouSoft.Model.AdminCenterStructure.TrainPlan()
{
CompanyId = CompanyId,
IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")),
TrainPlanFile = dr.IsDBNull(dr.GetOrdinal("TrainPlanFile")) ? "" : dr.GetString(dr.GetOrdinal("TrainPlanFile")),
Id = dr.GetInt32(dr.GetOrdinal("Id")),
OperatorName = dr.IsDBNull(dr.GetOrdinal("OperatorName")) ? "" : dr.GetString(dr.GetOrdinal("OperatorName")),
PlanContent = dr.IsDBNull(dr.GetOrdinal("PlanContent")) ? "" : dr.GetString(dr.GetOrdinal("PlanContent")),
PlanTitle = dr.IsDBNull(dr.GetOrdinal("PlanTitle")) ? "" : dr.GetString(dr.GetOrdinal("PlanTitle")),
AcceptList = GetAcceptList(dr["TrainPlanAcceptXML"].ToString())
};
foreach (EyouSoft.Model.AdminCenterStructure.TrainPlanAccepts item in model.AcceptList)
{
if (item.AcceptType != EyouSoft.Model.EnumType.AdminCenterStructure.AcceptType.所有)
{
if (item.AcceptType == EyouSoft.Model.EnumType.AdminCenterStructure.AcceptType.指定部门)
{
EyouSoft.Model.CompanyStructure.Department Depart = null;
EyouSoft.IDAL.CompanyStructure.IDepartment idal = new EyouSoft.DAL.CompanyStructure.Department();
Depart = idal.GetModel(item.AcceptId);
if (Depart != null)
{
item.AcceptName = Depart.DepartName;
}
Depart = null;
idal = null;
}
else
{
EyouSoft.Model.CompanyStructure.ContactPersonInfo Person = null;
EyouSoft.IDAL.CompanyStructure.ICompanyUser idal = new EyouSoft.DAL.CompanyStructure.CompanyUser();
Person = idal.GetUserBasicInfo(item.AcceptId);
if (Person != null)
{
item.AcceptName = Person.ContactName;
}
Person = null;
idal = null;
}
}
}
}
}
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int TrainPlanID = EyouSoft.Common.Utils.GetInt(Request.QueryString["TrainPlanID"]);
EyouSoft.BLL.AdminCenterStructure.TrainPlan bllTrainPlan = new EyouSoft.BLL.AdminCenterStructure.TrainPlan();
EyouSoft.Model.AdminCenterStructure.TrainPlan modelTrainPlan = bllTrainPlan.GetModel(CurrentUserCompanyID, TrainPlanID);
if (modelTrainPlan != null)
{
this.lbl_PlanTitle.Text = modelTrainPlan.PlanTitle;
this.lbl_PlanContent.Text = modelTrainPlan.PlanContent;
this.lbl_OperatorName.Text = modelTrainPlan.OperatorName;
this.lbl_IssueTime.Text = string.Format("{0:yyyy-MM-dd}", modelTrainPlan.IssueTime);
this.lbl_AcceptPersonnel.Text = GetAcceptList(modelTrainPlan.AcceptList);
}
else
{
MessageBox.ShowAndRedirect(this.Page, "没有该数据！", "/administrativeCenter/trainingPlan/Default.aspx");
}
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">培训计划实体</param>
/// <returns></returns>
public bool Update(EyouSoft.Model.AdminCenterStructure.TrainPlan model)
{
bool IsTrue = false;
IsTrue = idal.Update(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() + "修改了培训计划信息数据，编号为：" + model.Id;
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 TrainPlanID = Utils.GetInt(Request.QueryString["TrainPlanID"], -1);
string Method = Utils.GetFormValue("hidMethod");
this.selectDepartment1.SetPicture = "/images/sanping_04.gif";
Publisher = this.SiteUserInfo.UserName; //默认当前帐号，可以修改
PublishTime = DateTime.Now; //默认当前时间
if (!IsPostBack && TrainPlanID != -1) //初始化
{
EyouSoft.BLL.AdminCenterStructure.TrainPlan bllTrainPlan = new EyouSoft.BLL.AdminCenterStructure.TrainPlan();
EyouSoft.Model.AdminCenterStructure.TrainPlan modelTrainPlan = bllTrainPlan.GetModel(CurrentUserCompanyID, TrainPlanID);
if (modelTrainPlan != null)
{
this.hidTrainPlanID.Value = modelTrainPlan.Id.ToString();
PlanTitle = modelTrainPlan.PlanTitle;
PlanContent = modelTrainPlan.PlanContent;
AcceptListInit(modelTrainPlan.AcceptList);
Publisher = modelTrainPlan.OperatorName;
PublishTime = modelTrainPlan.IssueTime;
}
else
{
MessageBox.ShowAndRedirect(this.Page, "没有该条数据", "/administrativeCenter/trainingPlan/Default.aspx");
}
}
if (Method == "save")
{
if (TrainPlanID == -1)
{
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);
}
}
EyouSoft.BLL.AdminCenterStructure.TrainPlan bllTrainPlan = new EyouSoft.BLL.AdminCenterStructure.TrainPlan();
EyouSoft.Model.AdminCenterStructure.TrainPlan ModelTrainPlan = new EyouSoft.Model.AdminCenterStructure.TrainPlan();
ModelTrainPlan.CompanyId = CurrentUserCompanyID;
ModelTrainPlan.PlanTitle = Utils.GetFormValue("txt_PlanTitle");
ModelTrainPlan.PlanContent = Utils.EditInputText(Request.Form["txt_PlanContent"]);
ModelTrainPlan.AcceptList = this.GetListTrainPlanAccepts();
ModelTrainPlan.IssueTime = Utils.GetDateTimeNullable(Request.Form["txt_PublishTime"]);
ModelTrainPlan.OperatorName = Utils.GetFormValue("txt_Publisher");
if (ModelTrainPlan.OperatorName == this.SiteUserInfo.UserName)
{
ModelTrainPlan.OperatorId = this.SiteUserInfo.ID;
}
if (TrainPlanID == -1) //添加
{
if (bllTrainPlan.Add(ModelTrainPlan))
{
MessageBox.ResponseScript(this, string.Format("alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();window.parent.location='{2}';", "保存成功！", Utils.GetQueryStringValue("iframeId"), "/administrativeCenter/trainingPlan/Default.aspx"));
}
else
{
MessageBox.Show(this.Page, "保存失败！");
}
}
if (TrainPlanID != -1) //修改
{
ModelTrainPlan.Id = TrainPlanID;
if (bllTrainPlan.Update(ModelTrainPlan))
{
MessageBox.ResponseScript(this, string.Format("alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();window.parent.location='{2}';", "修改成功！", Utils.GetQueryStringValue("iframeId"), "/administrativeCenter/trainingPlan/Default.aspx"));
}
else
{
MessageBox.Show(this.Page, "修改失败！");
}
}
}
}
