/// <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)
{
return(idal.GetList(PageSize, PageIndex, ref RecordCount, CompanyId, SearchInfo));
}
protected void Page_Load(object sender, EventArgs e)
{
PageIndex = Utils.GetInt(Request.QueryString["Page"], 1);
string method = Utils.GetQueryStringValue("Method");
int WorkerID = Utils.GetInt(Request.QueryString["WorkerID"], -1);
if (!IsPostBack && method == "") //查询
{
if (CheckGrant(global::Common.Enum.TravelPermission.行政中心_劳动合同管理_修改合同))
{
EditFlag = true;
}
if (CheckGrant(global::Common.Enum.TravelPermission.行政中心_劳动合同管理_删除合同))
{
DeleteFlag = true;
}
string WorkerNo = Utils.GetQueryStringValue("WorkerNo");
string WorkerName = Utils.GetQueryStringValue("WorkerName");
DateTime?TimeOfSigningStart = Utils.GetDateTimeNullable(Request.QueryString["TimeOfSigningStart"]);
DateTime?TimeOfSigningEnd = Utils.GetDateTimeNullable(Request.QueryString["TimeOfSigningEnd"]);
DateTime?ComeDueStart = Utils.GetDateTimeNullable(Request.QueryString["ComeDueStart"]);
DateTime?ComeDueEnd = Utils.GetDateTimeNullable(Request.QueryString["ComeDueEnd"]);
EyouSoft.BLL.AdminCenterStructure.ContractInfo bllContractInfo = new EyouSoft.BLL.AdminCenterStructure.ContractInfo();
EyouSoft.Model.AdminCenterStructure.ContractSearchInfo searchInfo = new EyouSoft.Model.AdminCenterStructure.ContractSearchInfo();
searchInfo.StaffNo = WorkerNo;
searchInfo.StaffName = WorkerName;
searchInfo.BeginFrom = TimeOfSigningStart;
searchInfo.BeginTo = TimeOfSigningEnd;
searchInfo.EndFrom = ComeDueStart;
searchInfo.EndTo = ComeDueEnd;
IList <EyouSoft.Model.AdminCenterStructure.ContractInfo> listContractInfo = bllContractInfo.GetList(PageSize, PageIndex, ref RecordCount, CurrentUserCompanyID, searchInfo);
if (listContractInfo != null && listContractInfo.Count > 0)
{
this.crptContractList.DataSource = listContractInfo;
this.crptContractList.DataBind();
BindPage();
}
else
{
this.crptContractList.EmptyText = "<tr><td colspan=\"8\"><div style=\"text-align:center; margin-top:75px; margin-bottom:75px;\">没有相关的数据!</span></div></td></tr>";
this.ExporPageInfoSelect1.Visible = false;
}
}
if (method == "DeleteContract" && WorkerID != -1) //删除
{
if (!CheckGrant(global::Common.Enum.TravelPermission.行政中心_劳动合同管理_删除合同)) //删除权限判断
{
Response.Clear();
Response.Write("NoPermission");
Response.End();
}
else
{
EyouSoft.BLL.AdminCenterStructure.ContractInfo bllContractInfo = new EyouSoft.BLL.AdminCenterStructure.ContractInfo();
if (bllContractInfo.Delete(CurrentUserCompanyID, WorkerID))
{
Response.Clear();
Response.Write("True");
Response.End();
}
else
{
Response.Clear();
Response.Write("False");
Response.End();
}
}
}
}
/// <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);
}
