public virtual void getList <T, P>()
where T : class
where P : class
{
try
{
string record = this.Request["record"];
Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record);
List <ColumnInfo> list = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(ht["params"].ToString());
int start = Convert.ToInt32(this.Request["start"]);
int limit = Convert.ToInt32(this.Request["limit"]);
T bll = (T)typeof(T).GetConstructor(new Type[] { }).Invoke(new object[] { });
BaseBll baseBll = bll as BaseBll;
int total = 0;
List <P> dataList = baseBll.GetSelectedRecords <P>(list, true, start, start + limit, ref total);
string json = JavaScriptConvert.SerializeObject(BuildAnonymousObject(dataList));
Response.Write("{results:" + total + ",rows:" + json + "}");
}
catch (Exception ex)
{
string message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_QueryFail, ex, true) + "'}";
Response.Output.Write(message);
}
}
public virtual void getExportExcel <T, P>() where T : class where P : class
{
try
{
string record = this.Request["record"];
Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record);
List <ColumnInfo> records = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(ht["params"].ToString());
List <ColumnInfo> headers = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(ht["headers"].ToString());
T bll = (T)typeof(T).GetConstructor(new Type[] { }).Invoke(new object[] { });
BaseBll baseBll = bll as BaseBll;
int total = 0;
List <P> obj = baseBll.GetSelectedRecords <P>(records, false, 0, 0, ref total);
if ((obj != null) && (total > 0))
{
List <object> finalObj = BuildAnonymousObject(obj).Cast <object>().ToList();
UtilExcel.ExportToExcel(finalObj[0].GetType(), Response, this.GetType().Name.GetPageName(), headers, finalObj);
}
}
catch (Exception ex)
{
string message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_QueryFail, ex, true) + "'}";
Response.Output.Write(message);
}
}
public void getSalaryItems()
{
try
{
string record = this.Request["record"];
BaseBll bll = new BaseBll();
List <tprsalitm> list = bll.GetSelectedRecords <tprsalitm>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "bkal", ColumnValue = "Y"
}
});
var finList = (from p in list
select new ValueInfo {
ValueField = p.itcd, DisplayField = p.itnm
}).ToList();
string json = JavaScriptConvert.SerializeObject(finList);
json = "{results:" + finList.Count + ",rows:" + json + "}";
Response.Output.Write(json);
}
catch (Exception ex)
{
throw ex;
}
}
public void DeletePriRuleSet(List <ColumnInfo> _parameters)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
BaseBll baseBll = new BaseBll();
List <tprprirst> lstDtl = baseBll.GetSelectedRecords <tprprirst>(_parameters);
for (int i = 0; i < lstDtl.Count; i++)
{
if (lstDtl[i].vtyp == "Sum")
{
//delete rel item
List <ColumnInfo> relparams = new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rlcd", ColumnValue = lstDtl[i].rlcd
}
};
DoMultiDelete <tprrstsit>(relparams);
}
DoDelete <tprprirst>(lstDtl[i]);
}
scope.Complete();
}
}
catch (UtilException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new UtilException(ex.Message, ex);
}
}
private void LoadData(string rpcd, List <ColumnInfo> lstParameters)
{
BaseBll bll = new BaseBll();
trpexrpdf def = bll.GetSelectedObject <trpexrpdf>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rpcd", ColumnValue = rpcd
}
});
List <trpexrpdd> lstDtl = bll.GetSelectedRecords <trpexrpdd>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rpcd", ColumnValue = rpcd
}
});
rpexrpdpBll rpbll = new rpexrpdpBll();
DataSet ds = null;
switch (def.rpty)
{
case "Personnel":
ds = rpbll.GetPersonalData(rpcd, lstDtl, lstParameters);
break;
case "Payroll":
ds = rpbll.GetPayrollData(rpcd, lstDtl, lstParameters);
break;
case "PayrollBankAlloc":
ds = rpbll.GetPayrollBankAllocData(rpcd, lstDtl, lstParameters);
break;
}
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//Title
this.GridView1.Caption = "<B>" + def.rptt + "</B>";
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
//Merge Column
MergeGridView mergeGV = new MergeGridView();
for (int i = 0; i < lstDtl.Count; i++)
{
if (lstDtl[i].isme == "Y")
{
mergeGV.Merge(this.GridView1, i);
}
}
//Summary
var q = (from p in lstDtl
where p.issu == "Y"
select p).ToList();
for (int i = 0; i < q.Count; i++)
{
//GridViewSummary sum = new GridViewSummary(q[i].itnm, SummaryOperation.Sum);
}
}
else
{
}
}
public void UpdatePriRuleSet(string _emno, List <tprprirst> list)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
//delete first
List <ColumnInfo> parameters = new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "emno", ColumnValue = _emno
}
};
BaseBll baseBll = new BaseBll();
List <tprprirst> lstDtl = baseBll.GetSelectedRecords <tprprirst>(parameters, true);
for (int i = 0; i < lstDtl.Count; i++)
{
if (lstDtl[i].vtyp == "Sum")
{
//delete rel item
List <ColumnInfo> relparams = new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rlcd", ColumnValue = lstDtl[i].rlcd
}
};
DoMultiDelete <tprrstsit>(relparams);
}
//DoDelete<tprprirst>(lstDtl[i]);
}
DoMultiDelete <tprprirst>(parameters);
for (int i = 0; i < list.Count; i++)
{
string rlcd = UtilDatetime.FormatTime4(DateTime.Now);
if (list[i].vtyp == "Sum")
{
list[i].rlcd = rlcd;
}
DoInsert <tprprirst>(list[i]);
if (list[i].vtyp == "Sum")
{
string[] arr = list[i].valu.Split(',');
for (int j = 0; j < arr.Length; j++)
{
tprrstsit sit = new tprrstsit();
sit.itcd = arr[j].Substring(1, arr[j].Length - 2);
sit.lmtm = list[i].lmtm;
sit.lmur = list[i].lmur;
sit.rlcd = rlcd;
DoInsert <tprrstsit>(sit);
}
}
}
scope.Complete();
}
}
catch (UtilException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new UtilException(ex.Message, ex);
}
}
public void CarryForward(List <ColumnInfo> _carryforwardParameters,
List <ColumnInfo> _personalParameters)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
int CarryStartYear = Convert.ToDateTime(_carryforwardParameters[0].ColumnValue).Year;
int CarryEndYear = Convert.ToDateTime(_carryforwardParameters[1].ColumnValue).Year;
List <vw_employment> lstStaff = null;
string sSqlStaff = string.Empty;
//期间内所有离职员工都不进行结转
atanaattBll bll = new atanaattBll();
bll.GetPersonals(_personalParameters, ref lstStaff, ref sSqlStaff, new DateTime(CarryEndYear, 12, 31).AddDays(1));
//得到休假类型
List <ColumnInfo> parameters = new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "iscf", ColumnValue = "Y"
}
};
BaseBll bBll = new BaseBll();
List <tlvleatyp> lstLeaveType = bBll.GetSelectedRecords <tlvleatyp>(parameters);
for (int i = 0; i < (CarryEndYear - CarryStartYear) + 1; i++)
{
//结转前删除所有的结转年度数据
parameters = new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "year", ColumnValue = (CarryStartYear + i).ToString()
}
};
dal.DoMultiDelete <tlvcryfwd>(parameters);
for (int n = 0; n < lstLeaveType.Count; n++)
{
string ltcd = lstLeaveType[n].ltcd;
for (int j = 0; j < lstStaff.Count; j++)
{
DoCarryforward(lstStaff[j], ltcd, CarryStartYear + i);
}
}
}
scope.Complete();
}
}
catch (UtilException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new UtilException(ex.Message, ex);
}
}
