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