/// <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;
}
}
