/// <summary>
/// 修改
/// </summary>
/// <param name="model">公司账户信息实体</param>
/// <returns></returns>
public int Update(EyouSoft.Model.AdminCenterStructure.DutyManager model)
{
int EffectedCount = 0;
if (this.IsExists(model.JobName, model.Id, model.CompanyId))
{
EffectedCount = -1;
}
else
{
EyouSoft.Data.DutyManager DataModel = dcDal.DutyManager.FirstOrDefault(item =>
item.Id == model.Id && item.CompanyId == model.CompanyId
);
if (DataModel != null)
{
DataModel.CompanyId = model.CompanyId;
DataModel.Help = model.Help;
DataModel.IssueTime = System.DateTime.Now;
DataModel.JobName = model.JobName;
DataModel.OperatorId = model.OperatorId;
DataModel.Remark = model.Remark;
DataModel.Requirement = model.Requirement;
dcDal.SubmitChanges();
EffectedCount = 1;
}
DataModel = null;
}
return(EffectedCount);
}
/// <summary>
/// 获取公司职务信息集合
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="CompanyId">公司编号</param>
/// <returns></returns>
public IList <EyouSoft.Model.AdminCenterStructure.DutyManager> GetList(int PageSize, int PageIndex, ref int RecordCount, int CompanyId)
{
IList <EyouSoft.Model.AdminCenterStructure.DutyManager> ResultList = null;
string tableName = "tbl_DutyManager";
string identityColumnName = "Id";
string fields = "[Id],[Help],[JobName],[Remark],[Requirement]";
string query = string.Format("[CompanyId]={0}", CompanyId);
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.DutyManager>();
while (dr.Read())
{
EyouSoft.Model.AdminCenterStructure.DutyManager model = new EyouSoft.Model.AdminCenterStructure.DutyManager()
{
Id = dr.GetInt32(dr.GetOrdinal("Id")),
Help = dr.IsDBNull(dr.GetOrdinal("Help")) ? "" : dr.GetString(dr.GetOrdinal("Help")),
JobName = dr.GetString(dr.GetOrdinal("JobName")),
Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")),
Requirement = dr.IsDBNull(dr.GetOrdinal("Requirement")) ? "" : dr.GetString(dr.GetOrdinal("Requirement"))
};
ResultList.Add(model);
model = null;
}
};
return(ResultList);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model">公司账户信息实体</param>
/// <returns>0:失败，1：成功，-1：职务名称重复</returns>
public int Add(EyouSoft.Model.AdminCenterStructure.DutyManager model)
{
int EffectedCount = 0;
if (this.IsExists(model.JobName, 0, model.CompanyId))
{
EffectedCount = -1;
}
else
{
EyouSoft.Data.DutyManager DutyModel = new EyouSoft.Data.DutyManager()
{
CompanyId = model.CompanyId,
Help = model.Help,
IssueTime = System.DateTime.Now,
JobName = model.JobName,
OperatorId = model.OperatorId,
Remark = model.Remark,
Requirement = model.Requirement
};
dcDal.DutyManager.InsertOnSubmit(DutyModel);
dcDal.SubmitChanges();
EffectedCount = 1;
DutyModel = null;
}
return(EffectedCount);
}
/// <summary>
/// 获取职务信息实体
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="DutyId">职务编号</param>
/// <returns></returns>
public EyouSoft.Model.AdminCenterStructure.DutyManager GetModel(int CompanyId, int DutyId)
{
EyouSoft.Model.AdminCenterStructure.DutyManager model = null;
model = (from item in dcDal.DutyManager
where item.CompanyId == CompanyId && item.Id == DutyId
select new EyouSoft.Model.AdminCenterStructure.DutyManager
{
Id = item.Id,
Help = item.Help,
JobName = item.JobName,
Remark = item.Remark,
Requirement = item.Requirement
}).FirstOrDefault();
return(model);
}
/// <summary>
/// 得到职务名称
/// </summary>
protected string GetDutyNameByID(int?dutyID)
{
string strReturn = "";
int id = 0;
if (dutyID != null)
{
id = (int)dutyID;
}
EyouSoft.BLL.AdminCenterStructure.DutyManager bllDutyManager = new EyouSoft.BLL.AdminCenterStructure.DutyManager();
EyouSoft.Model.AdminCenterStructure.DutyManager modelDutyManager = bllDutyManager.GetModel(CurrentUserCompanyID, id);
if (modelDutyManager != null)
{
strReturn = modelDutyManager.JobName;
}
return(strReturn);
}
/// <summary>
/// 获取所有职务信息（职务名称和ID值）
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <returns></returns>
public IList <EyouSoft.Model.AdminCenterStructure.DutyManager> GetList(int CompanyId)
{
IList <EyouSoft.Model.AdminCenterStructure.DutyManager> ResultList = null;
string StrSql = string.Format("SELECT [ID],[JobName] FROM [tbl_DutyManager] WHERE [CompanyId]={0} Order BY IssueTime DESC", CompanyId);
DbCommand dc = this._db.GetSqlStringCommand(StrSql);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db))
{
ResultList = new List <EyouSoft.Model.AdminCenterStructure.DutyManager>();
while (dr.Read())
{
EyouSoft.Model.AdminCenterStructure.DutyManager model = new EyouSoft.Model.AdminCenterStructure.DutyManager()
{
Id = dr.GetInt32(dr.GetOrdinal("Id")),
JobName = dr.GetString(dr.GetOrdinal("JobName")),
};
ResultList.Add(model);
model = null;
}
};
return(ResultList);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model">公司账户信息实体</param>
/// <returns>0:失败，1：成功，-1：职务名称重复</returns>
public int Add(EyouSoft.Model.AdminCenterStructure.DutyManager model)
{
int RowCount = 0;
RowCount = idal.Add(model);
#region LGWR
if (RowCount > 0)
{
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(RowCount);
}
protected void Page_Load(object sender, EventArgs e)
{
EyouSoft.BLL.AdminCenterStructure.DutyManager bllDuty;
EyouSoft.Model.AdminCenterStructure.DutyManager modelDuty;
PositionID = Utils.GetInt(Request.QueryString["PositionID"], -1);
Method = Utils.GetFormValue("hiddenMethod");
if (!IsPostBack)//绑定要修改的数据
{
if (PositionID != -1)
{
if (!CheckGrant(TravelPermission.行政中心_职务管理_修改职务))
{
Utils.ResponseNoPermit(TravelPermission.行政中心_职务管理_修改职务, true);
}
this.hiddenID.Value = PositionID.ToString();
bllDuty = new EyouSoft.BLL.AdminCenterStructure.DutyManager();
modelDuty = bllDuty.GetModel(CurrentUserCompanyID, PositionID);
JobName = modelDuty.JobName;
JobDes = modelDuty.Help;
JobRequire = modelDuty.Requirement;
Remarks = modelDuty.Remark;
}
else
{
if (!CheckGrant(TravelPermission.行政中心_职务管理_新增职务))
{
Utils.ResponseNoPermit(TravelPermission.行政中心_职务管理_新增职务, true);
}
}
}
#region "保存和修改"
if (Method != "")
{
JobName = Utils.GetFormValue("txt_JobName");
JobDes = Utils.GetFormValue("txt_JobDes");
JobRequire = Utils.GetFormValue("txt_JobRequire");
Remarks = Utils.GetFormValue("txt_Remarks");
if (JobName != "")
{
bllDuty = new EyouSoft.BLL.AdminCenterStructure.DutyManager();
modelDuty = new EyouSoft.Model.AdminCenterStructure.DutyManager();
modelDuty.JobName = JobName;
modelDuty.Help = JobDes;
modelDuty.Requirement = JobRequire;
modelDuty.Remark = Remarks;
modelDuty.CompanyId = CurrentUserCompanyID;
if (PositionID == -1 && Method == "saveandadd")//保存并继续添加
{
int result = bllDuty.Add(modelDuty);
if (result == 1)
{
MessageBox.ShowAndRedirect(this, "保存成功！", this.Request.Url.ToString());
}
else if (result == 0)
{
MessageBox.Show(this.Page, "添加失败！");
}
else if (result == -1)
{
MessageBox.Show(this.Page, "该职务已存在，添加失败，请确认！");
}
}
else if (PositionID == -1 && Method == "save")//保存
{
int result = bllDuty.Add(modelDuty);
if (result == 1)
{
MessageBox.ResponseScript(this, string.Format("alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();window.parent.location='{2}';", "保存成功！", Utils.GetQueryStringValue("iframeId"), "/administrativeCenter/positionManage/Default.aspx"));
}
else if (result == 0)
{
MessageBox.Show(this.Page, "添加失败！");
}
else if (result == -1)
{
MessageBox.Show(this.Page, "该职务已存在，添加失败,请确认！");
}
}
else if (PositionID != -1 && Method == "update")//修改
{
modelDuty.Id = PositionID;
int result = bllDuty.Update(modelDuty);
if (result == 1)
{
MessageBox.ResponseScript(this, string.Format("alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();window.parent.location='{2}';", "修改成功！", Utils.GetQueryStringValue("iframeId"), "/administrativeCenter/positionManage/Default.aspx"));
}
else if (result == 0)
{
MessageBox.Show(this.Page, "修改失败！");
}
else if (result == -1)
{
MessageBox.Show(this.Page, "该职务已存在，修改失败,请确认！");
}
}
}
else
{
MessageBox.Show(this.Page, "职务名称不能为空，请确认！");
}
}
#endregion
}
