/// <summary>
/// 1.1 获取一栏数据
/// </summary>
/// <returns></returns>
public ActionResult initSumGrantDataList()
{
string unitID = Helper.ToString(Request["unitID"]);
if (string.IsNullOrEmpty(unitID))
{
return(null);
}
string a0101 = Helper.ToString(Request["a0101"]);
string dateStart = Helper.ToString(Request["dateStart"]);
string dateEnd = Helper.ToString(Request["dateEnd"]);
int page = Helper.ToInt(Request["page"]);
int rows = Helper.ToInt(Request["rows"]);
HCQ2_Model.SelectModel.WGJG02ByUnitID model = new HCQ2_Model.SelectModel.WGJG02ByUnitID()
{
UnitID = unitID,
A0101 = a0101,
DateStart = dateStart,
DateEnd = dateEnd,
page = page,
rows = rows
};
List <WGJG02Model> list = operateContext.bllSession.WGJG02.GetWageDetailByUnitID(model);
TableModel tModel = new TableModel()
{
total = operateContext.bllSession.WGJG02.CountPersonsByModel(model),
rows = list
};
return(Json(tModel, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 1.2 导出Excel
/// </summary>
/// <returns></returns>
public void ExportToExcel()
{
string unitID = Helper.ToString(Request["unitID"]);
string a0101 = Helper.ToString(Request["a0101"]);
string dateStart = Helper.ToString(Request["dateStart"]);
string dateEnd = Helper.ToString(Request["dateEnd"]);
HCQ2_Model.SelectModel.WGJG02ByUnitID model = new HCQ2_Model.SelectModel.WGJG02ByUnitID()
{
UnitID = unitID,
A0101 = a0101,
DateStart = dateStart,
DateEnd = dateEnd
};
// 写入到客户端
operateContext.bllSession.WGJG02.ExportToExcel(model);
}
