/// <summary> /// 得到一个对象实体 /// </summary> public Gymnasium_APP.Model.SellCastModel DataRowToModel(DataRow row) { Gymnasium_APP.Model.SellCastModel model=new Gymnasium_APP.Model.SellCastModel(); if (row != null) { if(row["CastId"]!=null && row["CastId"].ToString()!="") { model.CastId=int.Parse(row["CastId"].ToString()); } if(row["MemberId"]!=null) { model.MemberId=row["MemberId"].ToString(); } if(row["PriceAmount"]!=null && row["PriceAmount"].ToString()!="") { model.PriceAmount=decimal.Parse(row["PriceAmount"].ToString()); } if(row["PaymentAmount"]!=null && row["PaymentAmount"].ToString()!="") { model.PaymentAmount=decimal.Parse(row["PaymentAmount"].ToString()); } if(row["ChangeAmount"]!=null && row["ChangeAmount"].ToString()!="") { model.ChangeAmount=decimal.Parse(row["ChangeAmount"].ToString()); } if(row["CreateTime"]!=null) { model.CreateTime=row["CreateTime"].ToString(); } if(row["AddUserName"]!=null) { model.AddUserName=row["AddUserName"].ToString(); } if(row["AddTypeName"]!=null) { model.AddTypeName=row["AddTypeName"].ToString(); } if(row["CardID"]!=null) { model.CardID=row["CardID"].ToString(); } if(row["TypeName"]!=null) { model.TypeName=row["TypeName"].ToString(); } if(row["Peoples"]!=null) { model.Peoples=row["Peoples"].ToString(); } if(row["Des"]!=null) { model.Des=row["Des"].ToString(); } if(row["Prices"]!=null) { model.Prices=row["Prices"].ToString(); } if(row["CusType"]!=null) { model.CusType=row["CusType"].ToString(); } if(row["CusNum"]!=null) { model.CusNum=row["CusNum"].ToString(); } if(row["CusCount"]!=null) { model.CusCount=row["CusCount"].ToString(); } if(row["CusState"]!=null && row["CusState"].ToString()!="") { model.CusState=int.Parse(row["CusState"].ToString()); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Gymnasium_APP.Model.SellCastModel GetModel(int CastId) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 CastId,MemberId,PriceAmount,PaymentAmount,ChangeAmount,CreateTime,AddUserName,AddTypeName,CardID,TypeName,Peoples,Des,Prices,CusType,CusNum,CusCount,CusState from SellCast "); strSql.Append(" where CastId=@CastId"); SqlParameter[] parameters = { new SqlParameter("@CastId", SqlDbType.Int,4) }; parameters[0].Value = CastId; Gymnasium_APP.Model.SellCastModel model=new Gymnasium_APP.Model.SellCastModel(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }