/// <summary>
/// 详情
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public PaySlipID GetListyi(int id)
{
string sql = "select * from PaySlipID where id=" + id;
db.PrepareSql(sql);
DataTable dt = new DataTable();
dt = db.ExecQuery();
if (dt.Rows.Count == 0)
{
return(null);
}
PaySlipID entity = new PaySlipID();
foreach (DataRow item in dt.Rows)
{
entity.id = int.Parse(item["id"].ToString());
entity.UserID = int.Parse(item["UserID"].ToString());
entity.BasicSalary = decimal.Parse(item["BasicSalary"].ToString());
entity.AttendanceBonus = decimal.Parse(item["AttendanceBonus"].ToString());
entity.Fine = decimal.Parse(item["Fine"].ToString());
entity.SalaryTime = DateTime.Parse(item["SalaryTime"].ToString());
entity.SalarySum = decimal.Parse(item["SalarySum"].ToString());
}
return(entity);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Add(PaySlipID entity)
{
string sql = "insert into PaySlipID(UserID,BasicSalary,AttendanceBonus,Fine,SalaryTime,SalarySum) values(@UserID,@BasicSalary,@AttendanceBonus,@Fine,@SalaryTime,@SalarySum)";
db.PrepareSql(sql);
db.SetParameter("UserID", entity.UserID);
db.SetParameter("BasicSalary", entity.BasicSalary);
db.SetParameter("AttendanceBonus", entity.AttendanceBonus);
db.SetParameter("Fine", entity.Fine);
db.SetParameter("SalaryTime", entity.SalaryTime);
db.SetParameter("SalarySum", entity.SalarySum);
return(db.ExecNonQuery());
}
/// <summary>
/// 修改
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Update(PaySlipID entity)
{
string sql = "update PaySlipID set UserID=@UserID,BasicSalary=@BasicSalary,AttendanceBonus=@AttendanceBonus,Fine=@Fine,SalaryTime=@SalaryTime,SalarySum=@SalarySum where id=@id";
db.PrepareSql(sql);
db.SetParameter("id", entity.id);
db.SetParameter("UserID", entity.UserID);
db.SetParameter("BasicSalary", entity.BasicSalary);
db.SetParameter("AttendanceBonus", entity.AttendanceBonus);
db.SetParameter("Fine", entity.Fine);
db.SetParameter("SalaryTime", entity.SalaryTime);
db.SetParameter("SalarySum", entity.SalarySum);
return(db.ExecNonQuery());
}
