/// <summary> /// 得到一个对象实体 /// </summary> public Danyl.SnnuURP.Model.WageInfo DataRowToModel(DataRow row) { Danyl.SnnuURP.Model.WageInfo model=new Danyl.SnnuURP.Model.WageInfo(); if (row != null) { if(row["Id"]!=null && row["Id"].ToString()!="") { model.Id=int.Parse(row["Id"].ToString()); } if(row["Tid"]!=null && row["Tid"].ToString()!="") { model.Tid=int.Parse(row["Tid"].ToString()); } if(row["Tname"]!=null) { model.Tname=row["Tname"].ToString(); } if(row["Month"]!=null) { model.Month=row["Month"].ToString(); } if(row["BasicWage"]!=null && row["BasicWage"].ToString()!="") { model.BasicWage=decimal.Parse(row["BasicWage"].ToString()); } if(row["JobSubsidies"]!=null && row["JobSubsidies"].ToString()!="") { model.JobSubsidies=decimal.Parse(row["JobSubsidies"].ToString()); } if(row["PersonalIncomeTax"]!=null) { model.PersonalIncomeTax=row["PersonalIncomeTax"].ToString(); } if(row["SocialSecurity"]!=null) { model.SocialSecurity=row["SocialSecurity"].ToString(); } if(row["Remark"]!=null) { model.Remark=row["Remark"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Danyl.SnnuURP.Model.WageInfo GetModel(int Id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 Id,Tid,Tname,Month,BasicWage,JobSubsidies,PersonalIncomeTax,SocialSecurity,Remark from WageInfo "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int,4) }; parameters[0].Value = Id; Danyl.SnnuURP.Model.WageInfo model=new Danyl.SnnuURP.Model.WageInfo(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }