/// <summary>
/// 获取合同信息集合
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="RecordCount"></param>
/// <param name="CompanyId">公司编号</param>
/// <param name="SearchInfo">合同管理查询实体</param>
/// <returns></returns>
public IList <EyouSoft.Model.AdminCenterStructure.ContractInfo> GetList(int PageSize, int PageIndex, ref int RecordCount, int CompanyId, EyouSoft.Model.AdminCenterStructure.ContractSearchInfo SearchInfo)
{
IList <EyouSoft.Model.AdminCenterStructure.ContractInfo> ResultList = null;
string tableName = "tbl_ContractInfo";
string identityColumnName = "Id";
string fields = " [Id],[StaffNo],[StaffName],[BeginDate],[EndDate],[ContractStatus],[Remark] ";
string query = string.Format("[CompanyId]={0}", CompanyId);
if (!string.IsNullOrEmpty(SearchInfo.StaffNo))
{
query = query + string.Format("AND StaffNo LIKE '%{0}%' ", SearchInfo.StaffNo);
}
if (!string.IsNullOrEmpty(SearchInfo.StaffName))
{
query = query + string.Format("AND StaffName LIKE '%{0}%' ", EyouSoft.Toolkit.Utils.ReplaceXmlSpecialCharacter(SearchInfo.StaffName));
}
if (SearchInfo.BeginFrom.HasValue)
{
query = query + string.Format(" AND DATEDIFF(DAY,'{0}',BeginDate)>=0", SearchInfo.BeginFrom);
}
if (SearchInfo.BeginTo.HasValue)
{
query = query + string.Format(" AND DATEDIFF(DAY,BeginDate,'{0}')>=0", SearchInfo.BeginTo);
}
if (SearchInfo.EndFrom.HasValue)
{
query = query + string.Format(" AND DATEDIFF(DAY,'{0}',EndDate)>=0", SearchInfo.EndFrom);
}
if (SearchInfo.EndTo.HasValue)
{
query = query + string.Format(" AND DATEDIFF(DAY,EndDate,'{0}')>=0", SearchInfo.EndTo);
}
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.ContractInfo>();
while (dr.Read())
{
EyouSoft.Model.AdminCenterStructure.ContractInfo model = new EyouSoft.Model.AdminCenterStructure.ContractInfo()
{
Id = dr.GetInt32(dr.GetOrdinal("Id")),
BeginDate = dr.GetDateTime(dr.GetOrdinal("BeginDate")),
EndDate = dr.GetDateTime(dr.GetOrdinal("EndDate")),
ContractStatus = (EyouSoft.Model.EnumType.AdminCenterStructure.ContractStatus)Enum.Parse(typeof(EyouSoft.Model.EnumType.AdminCenterStructure.ContractStatus), dr.GetInt32(dr.GetOrdinal("ContractStatus")).ToString()),
Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")),
StaffName = dr.IsDBNull(dr.GetOrdinal("StaffName")) ? "" : dr.GetString(dr.GetOrdinal("StaffName")),
StaffNo = dr.GetString(dr.GetOrdinal("StaffNo"))
};
ResultList.Add(model);
model = null;
}
};
return(ResultList);
}
/// <summary>
/// 获取合同管理实体信息
/// </summary>
/// <param name="CompanyId"></param>
/// <param name="Id"></param>
/// <returns></returns>
public EyouSoft.Model.AdminCenterStructure.ContractInfo GetModel(int CompanyId, int Id)
{
EyouSoft.Model.AdminCenterStructure.ContractInfo model = null;
model = (from item in dcDal.ContractInfo
where item.CompanyId == CompanyId && item.Id == Id
select new EyouSoft.Model.AdminCenterStructure.ContractInfo
{
Id = item.Id,
BeginDate = item.BeginDate,
EndDate = item.EndDate,
ContractStatus = (EyouSoft.Model.EnumType.AdminCenterStructure.ContractStatus)Enum.Parse(typeof(EyouSoft.Model.EnumType.AdminCenterStructure.ContractStatus), item.ContractStatus.ToString()),
StaffName = item.StaffName,
Remark = item.Remark,
StaffNo = item.StaffNo
}).FirstOrDefault();
return(model);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">合同信息实体</param>
/// <returns></returns>
public bool Update(EyouSoft.Model.AdminCenterStructure.ContractInfo model)
{
bool IsTrue = false;
EyouSoft.Data.ContractInfo DataModel = dcDal.ContractInfo.FirstOrDefault(item =>
item.Id == model.Id && item.CompanyId == model.CompanyId
);
if (DataModel != null)
{
DataModel.BeginDate = model.BeginDate;
DataModel.EndDate = model.EndDate;
DataModel.OperatorId = model.OperatorId;
DataModel.Remark = model.Remark;
DataModel.StaffName = model.StaffName;
DataModel.StaffNo = model.StaffNo;
DataModel.ContractStatus = (int)model.ContractStatus;
dcDal.SubmitChanges();
IsTrue = true;
}
DataModel = null;
return(IsTrue);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model">合同信息实体</param>
/// <returns></returns>
public bool Add(EyouSoft.Model.AdminCenterStructure.ContractInfo model)
{
bool IsTrue = false;
EyouSoft.Data.ContractInfo DataModel = new EyouSoft.Data.ContractInfo()
{
BeginDate = model.BeginDate,
EndDate = model.EndDate,
ContractStatus = (int)model.ContractStatus,
StaffName = model.StaffName,
Remark = model.Remark,
StaffNo = model.StaffNo,
CompanyId = model.CompanyId,
OperatorId = model.OperatorId,
IssueTime = System.DateTime.Now
};
dcDal.ContractInfo.InsertOnSubmit(DataModel);
dcDal.SubmitChanges();
IsTrue = true;
DataModel = null;
return(IsTrue);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model">合同信息实体</param>
/// <returns></returns>
public bool Add(EyouSoft.Model.AdminCenterStructure.ContractInfo model)
{
bool IsTrue = false;
IsTrue = idal.Add(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() + "新增了劳动合同数据。";
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 WorkerID = Utils.GetInt(Request.QueryString["WorkerID"], -1);
string Method = Utils.GetFormValue("hidMethod");
if (!IsPostBack && WorkerID != -1) //初始化
{
EyouSoft.BLL.AdminCenterStructure.ContractInfo bllContractInfo = new EyouSoft.BLL.AdminCenterStructure.ContractInfo();
EyouSoft.Model.AdminCenterStructure.ContractInfo modelContractInfo = bllContractInfo.GetModel(CurrentUserCompanyID, WorkerID);
if (modelContractInfo != null)
{
this.hidWorkerID.Value = modelContractInfo.Id.ToString();
this.dpState.SelectedIndex = (int)modelContractInfo.ContractStatus;
WorkerNO = modelContractInfo.StaffNo;
WorkerName = modelContractInfo.StaffName;
BeginDate = modelContractInfo.BeginDate;
EndDate = modelContractInfo.EndDate;
Reamrk = modelContractInfo.Remark;
}
}
if (Method == "save")
{
if (Utils.GetInt(this.hidWorkerID.Value, -1) != -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.ContractInfo bllContractInfo = new EyouSoft.BLL.AdminCenterStructure.ContractInfo();
EyouSoft.Model.AdminCenterStructure.ContractInfo modelContractInfo = new EyouSoft.Model.AdminCenterStructure.ContractInfo();
modelContractInfo.CompanyId = CurrentUserCompanyID;
modelContractInfo.StaffNo = Utils.GetFormValue("txt_WorkerNO");
modelContractInfo.StaffName = Utils.GetFormValue("txt_WorkerName");
if (Utils.GetDateTime(Request.Form["txt_BeginDate"]) != null)
{
modelContractInfo.BeginDate = Utils.GetDateTime(Request.Form["txt_BeginDate"]);
}
if (Utils.GetDateTime(Request.Form["txt_EndDate"]) != null)
{
modelContractInfo.EndDate = Utils.GetDateTime(Request.Form["txt_EndDate"]);
}
modelContractInfo.Remark = Utils.GetFormValue("txt_Reamrk");
modelContractInfo.ContractStatus = (EyouSoft.Model.EnumType.AdminCenterStructure.ContractStatus) this.dpState.SelectedIndex;
if (Utils.GetInt(this.hidWorkerID.Value, -1) != -1) // 修改
{
modelContractInfo.Id = Utils.GetInt(this.hidWorkerID.Value);
if (bllContractInfo.Update(modelContractInfo))
{
MessageBox.ResponseScript(this, string.Format("alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();window.parent.location='{2}';", "修改成功！", Utils.GetQueryStringValue("iframeId"), "/administrativeCenter/contractManage/Default.aspx"));
}
else
{
MessageBox.Show(this.Page, "修改失败！");
}
}
else //新增
{
if (bllContractInfo.Add(modelContractInfo))
{
MessageBox.ResponseScript(this, string.Format("alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();window.parent.location='{2}';", "新增成功！", Utils.GetQueryStringValue("iframeId"), "/administrativeCenter/contractManage/Default.aspx"));
}
else
{
MessageBox.Show(this.Page, "新增失败！");
}
}
}
}
