/// <summary>
/// 获取人事工资信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="year">年份</param>
/// <param name="month">月份</param>
/// <param name="query">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.AdminCenterStructure.MWageInfo> GetWages(int companyId, int year, int month, EyouSoft.Model.AdminCenterStructure.MWageSearchInfo query)
{
IList <EyouSoft.Model.AdminCenterStructure.MWageInfo> items = new List <EyouSoft.Model.AdminCenterStructure.MWageInfo>();
DbCommand cmd = _db.GetSqlStringCommand("SELECT * FROM tbl_Wage WHERE CompanyId=@CompanyId AND [Year]=@Year AND [Month]=@Month");
_db.AddInParameter(cmd, "CompanyId", DbType.Int32, companyId);
_db.AddInParameter(cmd, "Year", DbType.Int32, year);
_db.AddInParameter(cmd, "Month", DbType.Byte, month);
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, _db))
{
while (rdr.Read())
{
items.Add(new EyouSoft.Model.AdminCenterStructure.MWageInfo()
{
BingJia = rdr.GetDecimal(rdr.GetOrdinal("BingJia")),
ChiDao = rdr.GetDecimal(rdr.GetOrdinal("ChiDao")),
CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId")),
FanBu = rdr.GetDecimal(rdr.GetOrdinal("FanBu")),
GangWeiGongZi = rdr.GetDecimal(rdr.GetOrdinal("GangWeiGongZi")),
HuaBu = rdr.GetDecimal(rdr.GetOrdinal("HuaBu")),
IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")),
JiaBanFei = rdr.GetDecimal(rdr.GetOrdinal("JiaBanFei")),
JiangJin = rdr.GetDecimal(rdr.GetOrdinal("JiangJin")),
Month = rdr.GetByte(rdr.GetOrdinal("Month")),
OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId")),
QianKuan = rdr.GetDecimal(rdr.GetOrdinal("QianKuan")),
QuanQinJiang = rdr.GetDecimal(rdr.GetOrdinal("QuanQinJiang")),
RegId = rdr.GetInt32(rdr.GetOrdinal("Id")),
SheBao = rdr.GetDecimal(rdr.GetOrdinal("SheBao")),
ShiJia = rdr.GetDecimal(rdr.GetOrdinal("ShiJia")),
ShiFaGongZi = rdr.GetDecimal(rdr.GetOrdinal("ShiFaGongZi")),
WuXian = rdr.GetDecimal(rdr.GetOrdinal("WuXian")),
XingMing = rdr["XingMing"].ToString(),
XingZhengFaKuan = rdr.GetDecimal(rdr.GetOrdinal("XingZhengFaKuan")),
Year = rdr.GetInt32(rdr.GetOrdinal("Year")),
YeWuFaKuan = rdr.GetDecimal(rdr.GetOrdinal("YeWuFaKuan")),
YingFaGongZi = rdr.GetDecimal(rdr.GetOrdinal("YingFaGongZi")),
YouBu = rdr.GetDecimal(rdr.GetOrdinal("YouBu")),
ZhiWei = rdr["ZhiWei"].ToString()
});
}
}
return(items);
}
/// <summary>
/// 获取人事工资信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="year">年份</param>
/// <param name="month">月份</param>
/// <param name="query">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.AdminCenterStructure.MWageInfo> GetWages(int companyId, int year, int month, EyouSoft.Model.AdminCenterStructure.MWageSearchInfo query)
{
if (companyId < 1 || year < 1900 || month < 1 || month > 12)
{
return(null);
}
return(idal.GetWages(companyId, year, month, query));
}
