/// <summary>
/// 得到一个对象实体
/// </summary>
public DTcms.Model.StoreOutGoodsVehicle GetModel(int StoreOutWaitingGoodsId,int VehicleId)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select StoreOutGoodsStoreOutOrderId, StoreOutWaitingGoodsId, VehicleId, Remark, Count ");
strSql.Append(" from StoreOutGoodsVehicle ");
strSql.Append(" where StoreOutWaitingGoodsId=@StoreOutWaitingGoodsId and VehicleId=@VehicleId ");
SqlParameter[] parameters = {
new SqlParameter("@StoreOutWaitingGoodsId", SqlDbType.Int,4),
new SqlParameter("@VehicleId", SqlDbType.Int,4) };
parameters[0].Value = StoreOutWaitingGoodsId;
parameters[1].Value = VehicleId;
DTcms.Model.StoreOutGoodsVehicle model=new DTcms.Model.StoreOutGoodsVehicle();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["StoreOutWaitingGoodsId"].ToString()!="")
{
model.StoreOutWaitingGoodsId=int.Parse(ds.Tables[0].Rows[0]["StoreOutWaitingGoodsId"].ToString());
}
if(ds.Tables[0].Rows[0]["VehicleId"].ToString()!="")
{
model.VehicleId=int.Parse(ds.Tables[0].Rows[0]["VehicleId"].ToString());
}
model.Remark= ds.Tables[0].Rows[0]["Remark"].ToString();
if(ds.Tables[0].Rows[0]["Count"].ToString()!="")
{
model.Count=decimal.Parse(ds.Tables[0].Rows[0]["Count"].ToString());
}
return model;
}
else
{
return null;
}
}
