public virtual IList <OrdersDeliveryGoodsInfo> GetOrdersDeliveryGoods(int DeliveryID)
{
IList <OrdersDeliveryGoodsInfo> entitys = null;
OrdersDeliveryGoodsInfo entity = null;
string SqlList;
SqlDataReader RdrList = null;
try
{
SqlList = "SELECT * FROM Orders_Delivery_Goods WHERE Orders_Delivery_Goods_DeliveryID = " + DeliveryID;
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <OrdersDeliveryGoodsInfo>();
while (RdrList.Read())
{
entity = new OrdersDeliveryGoodsInfo();
entity.Orders_Delivery_Goods_ID = Tools.NullInt(RdrList["Orders_Delivery_Goods_ID"]);
entity.Orders_Delivery_Goods_DeliveryID = Tools.NullInt(RdrList["Orders_Delivery_Goods_DeliveryID"]);
entity.Orders_Delivery_Goods_GoodsID = Tools.NullInt(RdrList["Orders_Delivery_Goods_GoodsID"]);
entity.Orders_Delivery_Goods_ProductID = Tools.NullInt(RdrList["Orders_Delivery_Goods_ProductID"]);
entity.Orders_Delivery_Goods_ProductCateID = Tools.NullInt(RdrList["Orders_Delivery_Goods_ProductCateID"]);
entity.Orders_Delivery_Goods_ProductCode = Tools.NullStr(RdrList["Orders_Delivery_Goods_ProductCode"]);
entity.Orders_Delivery_Goods_ProductName = Tools.NullStr(RdrList["Orders_Delivery_Goods_ProductName"]);
entity.Orders_Delivery_Goods_ProductImg = Tools.NullStr(RdrList["Orders_Delivery_Goods_ProductImg"]);
entity.Orders_Delivery_Goods_ProductSpec = Tools.NullStr(RdrList["Orders_Delivery_Goods_ProductSpec"]);
entity.Orders_Delivery_Goods_ProductPrice = Tools.NullDbl(RdrList["Orders_Delivery_Goods_ProductPrice"]);
entity.Orders_Delivery_Goods_ProductAmount = Tools.NullInt(RdrList["Orders_Delivery_Goods_ProductAmount"]);
entity.Orders_Delivery_Goods_ReceivedAmount = Tools.NullInt(RdrList["Orders_Delivery_Goods_ReceivedAmount"]);
entity.Orders_Delivery_Goods_brokerage = Tools.NullDbl(RdrList["Orders_Delivery_Goods_brokerage"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual bool EditOrdersDeliveryGoods(OrdersDeliveryGoodsInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT * FROM Orders_Delivery_Goods WHERE Orders_Delivery_Goods_ID = " + entity.Orders_Delivery_Goods_ID;
DtAdd = DBHelper.Query(SqlAdd);
try
{
if (DtAdd.Rows.Count > 0)
{
DrAdd = DtAdd.Rows[0];
DrAdd["Orders_Delivery_Goods_ID"] = entity.Orders_Delivery_Goods_ID;
DrAdd["Orders_Delivery_Goods_DeliveryID"] = entity.Orders_Delivery_Goods_DeliveryID;
DrAdd["Orders_Delivery_Goods_GoodsID"] = entity.Orders_Delivery_Goods_GoodsID;
DrAdd["Orders_Delivery_Goods_ProductID"] = entity.Orders_Delivery_Goods_ProductID;
DrAdd["Orders_Delivery_Goods_ProductCateID"] = entity.Orders_Delivery_Goods_ProductCateID;
DrAdd["Orders_Delivery_Goods_ProductCode"] = entity.Orders_Delivery_Goods_ProductCode;
DrAdd["Orders_Delivery_Goods_ProductName"] = entity.Orders_Delivery_Goods_ProductName;
DrAdd["Orders_Delivery_Goods_ProductImg"] = entity.Orders_Delivery_Goods_ProductImg;
DrAdd["Orders_Delivery_Goods_ProductSpec"] = entity.Orders_Delivery_Goods_ProductSpec;
DrAdd["Orders_Delivery_Goods_ProductPrice"] = entity.Orders_Delivery_Goods_ProductPrice;
DrAdd["Orders_Delivery_Goods_ProductAmount"] = entity.Orders_Delivery_Goods_ProductAmount;
DrAdd["Orders_Delivery_Goods_ReceivedAmount"] = entity.Orders_Delivery_Goods_ReceivedAmount;
DrAdd["Orders_Delivery_Goods_brokerage"] = entity.Orders_Delivery_Goods_brokerage;
DBHelper.SaveChanges(SqlAdd, DtAdd);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
return(true);
}
public virtual bool EditOrdersDeliveryGoods(OrdersDeliveryGoodsInfo entity)
{
return(MyDAL.EditOrdersDeliveryGoods(entity));
}
