public override bool CreatePurchaseOrder(OrderInfo order, DbTransaction dbTran)
{
string str;
PurchaseOrderInfo info = ConvertOrderToPurchaseOrder(order);
if (info == null)
{
return(false);
}
DbCommand sqlStringCommand = database.GetSqlStringCommand(" ");
StringBuilder builder = new StringBuilder();
builder.Append("INSERT INTO Hishop_PurchaseOrders(PurchaseOrderId, OrderId, Remark, ManagerMark, ManagerRemark, AdjustedDiscount,PurchaseStatus, CloseReason, PurchaseDate, DistributorId, Distributorname,DistributorEmail, DistributorRealName, DistributorQQ, DistributorWangwang, DistributorMSN,ShippingRegion, Address, ZipCode, ShipTo, TelPhone, CellPhone, ShippingModeId, ModeName,RealShippingModeId, RealModeName, RegionId, Freight, AdjustedFreight, ShipOrderNumber, Weight,RefundStatus, RefundAmount, RefundRemark, OrderTotal, PurchaseProfit, PurchaseTotal,ExpressCompanyName,ExpressCompanyAbb)VALUES (@PurchaseOrderId, @OrderId, @Remark, @ManagerMark, @ManagerRemark, @AdjustedDiscount,@PurchaseStatus, @CloseReason, @PurchaseDate, @DistributorId, @Distributorname,@DistributorEmail, @DistributorRealName, @DistributorQQ, @DistributorWangwang, @DistributorMSN,@ShippingRegion, @Address, @ZipCode, @ShipTo, @TelPhone, @CellPhone, @ShippingModeId, @ModeName,@RealShippingModeId, @RealModeName, @RegionId, @Freight, @AdjustedFreight, @ShipOrderNumber, @PurchaseWeight,@RefundStatus, @RefundAmount, @RefundRemark, @OrderTotal, @PurchaseProfit, @PurchaseTotal,@ExpressCompanyName,@ExpressCompanyAbb);");
database.AddInParameter(sqlStringCommand, "PurchaseOrderId", DbType.String, info.PurchaseOrderId);
database.AddInParameter(sqlStringCommand, "OrderId", DbType.String, info.OrderId);
database.AddInParameter(sqlStringCommand, "Remark", DbType.String, info.Remark);
if (info.ManagerMark.HasValue)
{
database.AddInParameter(sqlStringCommand, "ManagerMark", DbType.Int32, (int)info.ManagerMark.Value);
}
else
{
database.AddInParameter(sqlStringCommand, "ManagerMark", DbType.Int32, DBNull.Value);
}
database.AddInParameter(sqlStringCommand, "ManagerRemark", DbType.String, info.ManagerRemark);
database.AddInParameter(sqlStringCommand, "AdjustedDiscount", DbType.Currency, info.AdjustedDiscount);
database.AddInParameter(sqlStringCommand, "PurchaseStatus", DbType.Int32, (int)info.PurchaseStatus);
database.AddInParameter(sqlStringCommand, "CloseReason", DbType.String, info.CloseReason);
database.AddInParameter(sqlStringCommand, "PurchaseDate", DbType.DateTime, DateTime.Now);
database.AddInParameter(sqlStringCommand, "DistributorId", DbType.Int32, info.DistributorId);
database.AddInParameter(sqlStringCommand, "Distributorname", DbType.String, info.Distributorname);
database.AddInParameter(sqlStringCommand, "DistributorEmail", DbType.String, info.DistributorEmail);
database.AddInParameter(sqlStringCommand, "DistributorRealName", DbType.String, info.DistributorRealName);
database.AddInParameter(sqlStringCommand, "DistributorQQ", DbType.String, info.DistributorQQ);
database.AddInParameter(sqlStringCommand, "DistributorWangwang", DbType.String, info.DistributorWangwang);
database.AddInParameter(sqlStringCommand, "DistributorMSN", DbType.String, info.DistributorMSN);
database.AddInParameter(sqlStringCommand, "ShippingRegion", DbType.String, info.ShippingRegion);
database.AddInParameter(sqlStringCommand, "Address", DbType.String, info.Address);
database.AddInParameter(sqlStringCommand, "ZipCode", DbType.String, info.ZipCode);
database.AddInParameter(sqlStringCommand, "ShipTo", DbType.String, info.ShipTo);
database.AddInParameter(sqlStringCommand, "TelPhone", DbType.String, info.TelPhone);
database.AddInParameter(sqlStringCommand, "CellPhone", DbType.String, info.CellPhone);
database.AddInParameter(sqlStringCommand, "ShippingModeId", DbType.Int32, info.ShippingModeId);
database.AddInParameter(sqlStringCommand, "ModeName", DbType.String, info.ModeName);
database.AddInParameter(sqlStringCommand, "RealShippingModeId", DbType.Int32, info.RealShippingModeId);
database.AddInParameter(sqlStringCommand, "RealModeName", DbType.String, info.RealModeName);
database.AddInParameter(sqlStringCommand, "RegionId", DbType.Int32, info.RegionId);
database.AddInParameter(sqlStringCommand, "Freight", DbType.Currency, info.Freight);
database.AddInParameter(sqlStringCommand, "AdjustedFreight", DbType.Currency, info.AdjustedFreight);
database.AddInParameter(sqlStringCommand, "ShipOrderNumber", DbType.String, info.ShipOrderNumber);
database.AddInParameter(sqlStringCommand, "PurchaseWeight", DbType.Int32, info.Weight);
database.AddInParameter(sqlStringCommand, "RefundStatus", DbType.Int32, (int)info.RefundStatus);
database.AddInParameter(sqlStringCommand, "RefundAmount", DbType.Currency, info.RefundAmount);
database.AddInParameter(sqlStringCommand, "RefundRemark", DbType.String, info.RefundRemark);
database.AddInParameter(sqlStringCommand, "OrderTotal", DbType.Currency, info.OrderTotal);
database.AddInParameter(sqlStringCommand, "PurchaseProfit", DbType.Currency, info.GetPurchaseProfit());
database.AddInParameter(sqlStringCommand, "PurchaseTotal", DbType.Currency, info.GetPurchaseTotal());
database.AddInParameter(sqlStringCommand, "ExpressCompanyAbb", DbType.String, info.ExpressCompanyAbb);
database.AddInParameter(sqlStringCommand, "ExpressCompanyName", DbType.String, info.ExpressCompanyName);
int num = 0;
foreach (PurchaseOrderItemInfo info2 in info.PurchaseOrderItems)
{
str = num.ToString();
builder.Append("INSERT INTO Hishop_PurchaseOrderItems(PurchaseOrderId, SkuId, ProductId, SKU, Quantity, CostPrice, ").Append("ItemListPrice, ItemPurchasePrice, ItemDescription, ItemHomeSiteDescription, SKUContent, ThumbnailsUrl, Weight) VALUES( @PurchaseOrderId").Append(",@SkuId").Append(str).Append(",@ProductId").Append(str).Append(",@SKU").Append(str).Append(",@Quantity").Append(str).Append(",@CostPrice").Append(str).Append(",@ItemListPrice").Append(str).Append(",@ItemPurchasePrice").Append(str).Append(",@ItemDescription").Append(str).Append(",@ItemHomeSiteDescription").Append(str).Append(",@SKUContent").Append(str).Append(",@ThumbnailsUrl").Append(str).Append(",@Weight").Append(str).Append(");");
database.AddInParameter(sqlStringCommand, "SkuId" + str, DbType.String, info2.SkuId);
database.AddInParameter(sqlStringCommand, "ProductId" + str, DbType.Int32, info2.ProductId);
database.AddInParameter(sqlStringCommand, "SKU" + str, DbType.String, info2.SKU);
database.AddInParameter(sqlStringCommand, "Quantity" + str, DbType.Int32, info2.Quantity);
database.AddInParameter(sqlStringCommand, "CostPrice" + str, DbType.Currency, info2.ItemCostPrice);
database.AddInParameter(sqlStringCommand, "ItemListPrice" + str, DbType.Currency, info2.ItemListPrice);
database.AddInParameter(sqlStringCommand, "ItemPurchasePrice" + str, DbType.Currency, info2.ItemPurchasePrice);
database.AddInParameter(sqlStringCommand, "ItemDescription" + str, DbType.String, info2.ItemDescription);
database.AddInParameter(sqlStringCommand, "ItemHomeSiteDescription" + str, DbType.String, info2.ItemHomeSiteDescription);
database.AddInParameter(sqlStringCommand, "SKUContent" + str, DbType.String, info2.SKUContent);
database.AddInParameter(sqlStringCommand, "ThumbnailsUrl" + str, DbType.String, info2.ThumbnailsUrl);
database.AddInParameter(sqlStringCommand, "Weight" + str, DbType.Int32, info2.ItemWeight);
num++;
}
foreach (PurchaseOrderGiftInfo info3 in info.PurchaseOrderGifts)
{
str = num.ToString();
builder.Append("INSERT INTO Hishop_PurchaseOrderGifts(PurchaseOrderId, GiftId, GiftName, CostPrice, PurchasePrice, ").Append("ThumbnailsUrl, Quantity) VALUES( @PurchaseOrderId,").Append("@GiftId").Append(str).Append(",@GiftName").Append(str).Append(",@CostPrice").Append(str).Append(",@PurchasePrice").Append(str).Append(",@ThumbnailsUrl").Append(str).Append(",@Quantity").Append(str).Append(");");
database.AddInParameter(sqlStringCommand, "GiftId" + str, DbType.Int32, info3.GiftId);
database.AddInParameter(sqlStringCommand, "GiftName" + str, DbType.String, info3.GiftName);
database.AddInParameter(sqlStringCommand, "Quantity" + str, DbType.Int32, info3.Quantity);
database.AddInParameter(sqlStringCommand, "CostPrice" + str, DbType.Currency, info3.CostPrice);
database.AddInParameter(sqlStringCommand, "PurchasePrice" + str, DbType.Currency, info3.PurchasePrice);
database.AddInParameter(sqlStringCommand, "ThumbnailsUrl" + str, DbType.String, info3.ThumbnailsUrl);
num++;
}
foreach (PurchaseOrderOptionInfo info4 in info.PurchaseOrderOptions)
{
str = num.ToString();
builder.Append("INSERT INTO Hishop_PurchaseOrderOptions (PurchaseOrderId, LookupListId, LookupItemId, ListDescription, ItemDescription, AdjustedPrice, CustomerTitle, CustomerDescription)").Append(" VALUES (@PurchaseOrderId, @LookupListId").Append(str).Append(", @LookupItemId").Append(str).Append(", @ListDescription").Append(str).Append(", @ItemDescription").Append(str).Append(", @AdjustedPrice").Append(str).Append(", @CustomerTitle").Append(str).Append(", @CustomerDescription").Append(str).Append(");");
database.AddInParameter(sqlStringCommand, "LookupListId" + str, DbType.Int32, info4.LookupListId);
database.AddInParameter(sqlStringCommand, "LookupItemId" + str, DbType.Int32, info4.LookupItemId);
database.AddInParameter(sqlStringCommand, "ListDescription" + str, DbType.String, info4.ListDescription);
database.AddInParameter(sqlStringCommand, "ItemDescription" + str, DbType.String, info4.ItemDescription);
database.AddInParameter(sqlStringCommand, "AdjustedPrice" + str, DbType.Currency, info4.AdjustedPrice);
database.AddInParameter(sqlStringCommand, "CustomerTitle" + str, DbType.String, info4.CustomerTitle);
database.AddInParameter(sqlStringCommand, "CustomerDescription" + str, DbType.String, info4.CustomerDescription);
num++;
}
sqlStringCommand.CommandText = builder.ToString().Remove(builder.Length - 1);
if (dbTran != null)
{
return(database.ExecuteNonQuery(sqlStringCommand, dbTran) > 0);
}
return(database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public System.Text.StringBuilder GetOrderDetails(string format, string orderitemfomat, PurchaseOrderInfo order)
{
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
string text = string.Empty;
if (order != null)
{
string text2 = "false";
System.Text.StringBuilder stringBuilder2 = new System.Text.StringBuilder();
long num = 0L;
System.Collections.Generic.IList <PurchaseOrderItemInfo> purchaseOrderItems = order.PurchaseOrderItems;
foreach (PurchaseOrderItemInfo current in purchaseOrderItems)
{
text2 = "true";
stringBuilder2.AppendFormat(orderitemfomat, new object[]
{
"0",
order.OrderId,
current.ProductId.ToString(),
current.ItemDescription,
current.SKU,
current.SKUContent,
current.Quantity.ToString(),
current.ItemListPrice.ToString("F2"),
current.ItemPurchasePrice.ToString("F2"),
current.ItemCostPrice.ToString("F2")
});
num += (long)current.Quantity;
}
System.Collections.Generic.Dictionary <string, string> shippingRegion = MessageInfo.GetShippingRegion(order.ShippingRegion);
stringBuilder.AppendFormat(format, new object[]
{
order.OrderId,
"0",
order.Distributorname,
order.DistributorEmail,
order.ShipTo,
shippingRegion["Province"],
shippingRegion["City"].ToString(),
shippingRegion["District"],
order.Address,
order.ZipCode,
order.CellPhone,
order.TelPhone,
order.Remark,
order.ManagerMark,
order.ManagerRemark,
num.ToString(),
order.OrderTotal.ToString("F2"),
order.OrderTotal.ToString("F2"),
order.AdjustedFreight.ToString("F2"),
order.GetPurchaseProfit().ToString("F2"),
order.GetPurchaseTotal().ToString("F2"),
order.PayDate.ToString(),
order.ShippingDate.ToString(),
((int)order.RefundStatus).ToString(),
order.RefundAmount.ToString("F2"),
order.RefundRemark,
((int)order.PurchaseStatus).ToString(),
text2,
stringBuilder2
});
if (!string.IsNullOrEmpty(order.ShippingRegion))
{
text = order.ShippingRegion;
}
if (!string.IsNullOrEmpty(order.Address))
{
text += order.Address;
}
if (!string.IsNullOrEmpty(order.ShipTo))
{
text = text + " " + order.ShipTo;
}
if (!string.IsNullOrEmpty(order.ZipCode))
{
text = text + " " + order.ZipCode;
}
if (!string.IsNullOrEmpty(order.TelPhone))
{
text = text + " " + order.TelPhone;
}
if (!string.IsNullOrEmpty(order.CellPhone))
{
text = text + " " + order.CellPhone;
}
string text3 = "<ShipAddress>{0}</ShipAddress><ModeName>{1}</ModeName><ShipOrderNumber>{2}</ShipOrderNumber><ExpressCompanyName>{3}</ExpressCompanyName>";
text3 = string.Format(text3, new object[]
{
text,
order.RealModeName,
order.ShipOrderNumber,
order.ExpressCompanyName
});
stringBuilder = stringBuilder.Replace("</Status>", "</Status>" + text3);
}
return(stringBuilder);
}
public StringBuilder GetOrderDetails(string format, string orderitemfomat, PurchaseOrderInfo order)
{
StringBuilder builder = new StringBuilder();
string str = string.Empty;
if (order == null)
{
return(builder);
}
string str2 = "false";
StringBuilder builder2 = new StringBuilder();
long num = 0L;
foreach (PurchaseOrderItemInfo info in order.PurchaseOrderItems)
{
str2 = "true";
builder2.AppendFormat(orderitemfomat, new object[] { "0", order.OrderId, info.ProductId.ToString(), info.ItemDescription, info.SKU, info.SKUContent, info.Quantity.ToString(), info.ItemListPrice.ToString("F2"), info.ItemPurchasePrice.ToString("F2"), info.ItemCostPrice.ToString("F2") });
num += info.Quantity;
}
Dictionary <string, string> shippingRegion = MessageInfo.GetShippingRegion(order.ShippingRegion);
builder.AppendFormat(format, new object[] {
order.OrderId, "0", order.Distributorname, order.DistributorEmail, order.ShipTo, shippingRegion["Province"], shippingRegion["City"].ToString(), shippingRegion["District"], order.Address, order.ZipCode, order.CellPhone, order.TelPhone, order.Remark, order.ManagerMark, order.ManagerRemark, num.ToString(),
order.OrderTotal.ToString("F2"), order.OrderTotal.ToString("F2"), order.AdjustedFreight.ToString("F2"), order.GetPurchaseProfit().ToString("F2"), order.GetPurchaseTotal().ToString("F2"), order.PayDate.ToString(), order.ShippingDate.ToString(), ((int)order.RefundStatus).ToString(), order.RefundAmount.ToString("F2"), order.RefundRemark, ((int)order.PurchaseStatus).ToString(), str2, builder2
});
if (!string.IsNullOrEmpty(order.ShippingRegion))
{
str = order.ShippingRegion;
}
if (!string.IsNullOrEmpty(order.Address))
{
str = str + order.Address;
}
if (!string.IsNullOrEmpty(order.ShipTo))
{
str = str + " " + order.ShipTo;
}
if (!string.IsNullOrEmpty(order.ZipCode))
{
str = str + " " + order.ZipCode;
}
if (!string.IsNullOrEmpty(order.TelPhone))
{
str = str + " " + order.TelPhone;
}
if (!string.IsNullOrEmpty(order.CellPhone))
{
str = str + " " + order.CellPhone;
}
string str3 = "<ShipAddress>{0}</ShipAddress><ModeName>{1}</ModeName><ShipOrderNumber>{2}</ShipOrderNumber><ExpressCompanyName>{3}</ExpressCompanyName>";
str3 = string.Format(str3, new object[] { str, order.RealModeName, order.ShipOrderNumber, order.ExpressCompanyName });
return(builder.Replace("</Status>", "</Status>" + str3));
}
public override bool CreatePurchaseOrder(OrderInfo order, System.Data.Common.DbTransaction dbTran)
{
PurchaseOrderInfo purchaseOrderInfo = this.ConvertOrderToPurchaseOrder(order);
bool result;
if (purchaseOrderInfo == null)
{
result = false;
}
else
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(" ");
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("INSERT INTO Hishop_PurchaseOrders(PurchaseOrderId, OrderId, Remark, ManagerMark, ManagerRemark, AdjustedDiscount,PurchaseStatus, CloseReason, PurchaseDate, DistributorId, Distributorname,DistributorEmail, DistributorRealName, DistributorQQ, DistributorWangwang, DistributorMSN,ShippingRegion, Address, ZipCode, ShipTo, TelPhone, CellPhone, ShipToDate, ShippingModeId, ModeName,RealShippingModeId, RealModeName, RegionId, Freight, AdjustedFreight, ShipOrderNumber, Weight,ExpressCompanyName,ExpressCompanyAbb,RefundStatus, RefundAmount, RefundRemark, OrderTotal, PurchaseProfit, PurchaseTotal,Tax,InvoiceTitle)VALUES (@PurchaseOrderId, @OrderId, @Remark, @ManagerMark, @ManagerRemark, @AdjustedDiscount,@PurchaseStatus, @CloseReason, @PurchaseDate, @DistributorId, @Distributorname,@DistributorEmail, @DistributorRealName, @DistributorQQ, @DistributorWangwang, @DistributorMSN,@ShippingRegion, @Address, @ZipCode, @ShipTo, @TelPhone, @CellPhone, @ShipToDate, @ShippingModeId, @ModeName,@RealShippingModeId, @RealModeName, @RegionId, @Freight, @AdjustedFreight, @ShipOrderNumber, @PurchaseWeight,@ExpressCompanyName,@ExpressCompanyAbb,@RefundStatus, @RefundAmount, @RefundRemark, @OrderTotal, @PurchaseProfit, @PurchaseTotal,@Tax,@InvoiceTitle);");
this.database.AddInParameter(sqlStringCommand, "PurchaseOrderId", System.Data.DbType.String, purchaseOrderInfo.PurchaseOrderId);
this.database.AddInParameter(sqlStringCommand, "OrderId", System.Data.DbType.String, purchaseOrderInfo.OrderId);
this.database.AddInParameter(sqlStringCommand, "Remark", System.Data.DbType.String, purchaseOrderInfo.Remark);
if (purchaseOrderInfo.ManagerMark.HasValue)
{
this.database.AddInParameter(sqlStringCommand, "ManagerMark", System.Data.DbType.Int32, (int)purchaseOrderInfo.ManagerMark.Value);
}
else
{
this.database.AddInParameter(sqlStringCommand, "ManagerMark", System.Data.DbType.Int32, DBNull.Value);
}
this.database.AddInParameter(sqlStringCommand, "ManagerRemark", System.Data.DbType.String, purchaseOrderInfo.ManagerRemark);
this.database.AddInParameter(sqlStringCommand, "AdjustedDiscount", System.Data.DbType.Currency, purchaseOrderInfo.AdjustedDiscount);
this.database.AddInParameter(sqlStringCommand, "PurchaseStatus", System.Data.DbType.Int32, (int)purchaseOrderInfo.PurchaseStatus);
this.database.AddInParameter(sqlStringCommand, "CloseReason", System.Data.DbType.String, purchaseOrderInfo.CloseReason);
this.database.AddInParameter(sqlStringCommand, "PurchaseDate", System.Data.DbType.DateTime, DateTime.Now);
this.database.AddInParameter(sqlStringCommand, "DistributorId", System.Data.DbType.Int32, purchaseOrderInfo.DistributorId);
this.database.AddInParameter(sqlStringCommand, "Distributorname", System.Data.DbType.String, purchaseOrderInfo.Distributorname);
this.database.AddInParameter(sqlStringCommand, "DistributorEmail", System.Data.DbType.String, purchaseOrderInfo.DistributorEmail);
this.database.AddInParameter(sqlStringCommand, "DistributorRealName", System.Data.DbType.String, purchaseOrderInfo.DistributorRealName);
this.database.AddInParameter(sqlStringCommand, "DistributorQQ", System.Data.DbType.String, purchaseOrderInfo.DistributorQQ);
this.database.AddInParameter(sqlStringCommand, "DistributorWangwang", System.Data.DbType.String, purchaseOrderInfo.DistributorWangwang);
this.database.AddInParameter(sqlStringCommand, "DistributorMSN", System.Data.DbType.String, purchaseOrderInfo.DistributorMSN);
this.database.AddInParameter(sqlStringCommand, "ShippingRegion", System.Data.DbType.String, purchaseOrderInfo.ShippingRegion);
this.database.AddInParameter(sqlStringCommand, "Address", System.Data.DbType.String, purchaseOrderInfo.Address);
this.database.AddInParameter(sqlStringCommand, "ZipCode", System.Data.DbType.String, purchaseOrderInfo.ZipCode);
this.database.AddInParameter(sqlStringCommand, "ShipTo", System.Data.DbType.String, purchaseOrderInfo.ShipTo);
this.database.AddInParameter(sqlStringCommand, "TelPhone", System.Data.DbType.String, purchaseOrderInfo.TelPhone);
this.database.AddInParameter(sqlStringCommand, "CellPhone", System.Data.DbType.String, purchaseOrderInfo.CellPhone);
this.database.AddInParameter(sqlStringCommand, "ShipToDate", System.Data.DbType.String, purchaseOrderInfo.ShipToDate);
this.database.AddInParameter(sqlStringCommand, "ShippingModeId", System.Data.DbType.Int32, purchaseOrderInfo.ShippingModeId);
this.database.AddInParameter(sqlStringCommand, "ModeName", System.Data.DbType.String, purchaseOrderInfo.ModeName);
this.database.AddInParameter(sqlStringCommand, "RealShippingModeId", System.Data.DbType.Int32, purchaseOrderInfo.RealShippingModeId);
this.database.AddInParameter(sqlStringCommand, "RealModeName", System.Data.DbType.String, purchaseOrderInfo.RealModeName);
this.database.AddInParameter(sqlStringCommand, "RegionId", System.Data.DbType.Int32, purchaseOrderInfo.RegionId);
this.database.AddInParameter(sqlStringCommand, "Freight", System.Data.DbType.Currency, purchaseOrderInfo.Freight);
this.database.AddInParameter(sqlStringCommand, "AdjustedFreight", System.Data.DbType.Currency, purchaseOrderInfo.AdjustedFreight);
this.database.AddInParameter(sqlStringCommand, "ShipOrderNumber", System.Data.DbType.String, purchaseOrderInfo.ShipOrderNumber);
this.database.AddInParameter(sqlStringCommand, "PurchaseWeight", System.Data.DbType.Int32, (int)purchaseOrderInfo.Weight);
this.database.AddInParameter(sqlStringCommand, "ExpressCompanyAbb", System.Data.DbType.String, purchaseOrderInfo.ExpressCompanyAbb);
this.database.AddInParameter(sqlStringCommand, "ExpressCompanyName", System.Data.DbType.String, purchaseOrderInfo.ExpressCompanyName);
this.database.AddInParameter(sqlStringCommand, "RefundStatus", System.Data.DbType.Int32, (int)purchaseOrderInfo.RefundStatus);
this.database.AddInParameter(sqlStringCommand, "RefundAmount", System.Data.DbType.Currency, purchaseOrderInfo.RefundAmount);
this.database.AddInParameter(sqlStringCommand, "RefundRemark", System.Data.DbType.String, purchaseOrderInfo.RefundRemark);
this.database.AddInParameter(sqlStringCommand, "OrderTotal", System.Data.DbType.Currency, purchaseOrderInfo.OrderTotal);
this.database.AddInParameter(sqlStringCommand, "PurchaseProfit", System.Data.DbType.Currency, purchaseOrderInfo.GetPurchaseProfit());
this.database.AddInParameter(sqlStringCommand, "PurchaseTotal", System.Data.DbType.Currency, purchaseOrderInfo.GetPurchaseTotal());
this.database.AddInParameter(sqlStringCommand, "Tax", System.Data.DbType.Currency, purchaseOrderInfo.Tax);
this.database.AddInParameter(sqlStringCommand, "InvoiceTitle", System.Data.DbType.String, purchaseOrderInfo.InvoiceTitle);
int num = 0;
foreach (PurchaseOrderItemInfo current in purchaseOrderInfo.PurchaseOrderItems)
{
string text = num.ToString();
stringBuilder.Append("INSERT INTO Hishop_PurchaseOrderItems(PurchaseOrderId, SkuId, ProductId, SKU, Quantity, CostPrice, ").Append("ItemListPrice, ItemPurchasePrice, ItemDescription, ItemHomeSiteDescription, SKUContent, ThumbnailsUrl, Weight) VALUES( @PurchaseOrderId").Append(",@SkuId").Append(text).Append(",@ProductId").Append(text).Append(",@SKU").Append(text).Append(",@Quantity").Append(text).Append(",@CostPrice").Append(text).Append(",@ItemListPrice").Append(text).Append(",@ItemPurchasePrice").Append(text).Append(",@ItemDescription").Append(text).Append(",@ItemHomeSiteDescription").Append(text).Append(",@SKUContent").Append(text).Append(",@ThumbnailsUrl").Append(text).Append(",@Weight").Append(text).Append(");");
this.database.AddInParameter(sqlStringCommand, "SkuId" + text, System.Data.DbType.String, current.SkuId);
this.database.AddInParameter(sqlStringCommand, "ProductId" + text, System.Data.DbType.Int32, current.ProductId);
this.database.AddInParameter(sqlStringCommand, "SKU" + text, System.Data.DbType.String, current.SKU);
this.database.AddInParameter(sqlStringCommand, "Quantity" + text, System.Data.DbType.Int32, current.Quantity);
this.database.AddInParameter(sqlStringCommand, "CostPrice" + text, System.Data.DbType.Currency, current.ItemCostPrice);
this.database.AddInParameter(sqlStringCommand, "ItemListPrice" + text, System.Data.DbType.Currency, current.ItemListPrice);
this.database.AddInParameter(sqlStringCommand, "ItemPurchasePrice" + text, System.Data.DbType.Currency, current.ItemPurchasePrice);
this.database.AddInParameter(sqlStringCommand, "ItemDescription" + text, System.Data.DbType.String, current.ItemDescription);
this.database.AddInParameter(sqlStringCommand, "ItemHomeSiteDescription" + text, System.Data.DbType.String, current.ItemHomeSiteDescription);
this.database.AddInParameter(sqlStringCommand, "SKUContent" + text, System.Data.DbType.String, current.SKUContent);
this.database.AddInParameter(sqlStringCommand, "ThumbnailsUrl" + text, System.Data.DbType.String, current.ThumbnailsUrl);
this.database.AddInParameter(sqlStringCommand, "Weight" + text, System.Data.DbType.Int32, current.ItemWeight);
num++;
}
foreach (PurchaseOrderGiftInfo current2 in purchaseOrderInfo.PurchaseOrderGifts)
{
string text = num.ToString();
stringBuilder.Append("INSERT INTO Hishop_PurchaseOrderGifts(PurchaseOrderId, GiftId, GiftName, CostPrice, PurchasePrice, ").Append("ThumbnailsUrl, Quantity) VALUES( @PurchaseOrderId,").Append("@GiftId").Append(text).Append(",@GiftName").Append(text).Append(",@CostPrice").Append(text).Append(",@PurchasePrice").Append(text).Append(",@ThumbnailsUrl").Append(text).Append(",@Quantity").Append(text).Append(");");
this.database.AddInParameter(sqlStringCommand, "GiftId" + text, System.Data.DbType.Int32, current2.GiftId);
this.database.AddInParameter(sqlStringCommand, "GiftName" + text, System.Data.DbType.String, current2.GiftName);
this.database.AddInParameter(sqlStringCommand, "Quantity" + text, System.Data.DbType.Int32, current2.Quantity);
this.database.AddInParameter(sqlStringCommand, "CostPrice" + text, System.Data.DbType.Currency, current2.CostPrice);
this.database.AddInParameter(sqlStringCommand, "PurchasePrice" + text, System.Data.DbType.Currency, current2.PurchasePrice);
this.database.AddInParameter(sqlStringCommand, "ThumbnailsUrl" + text, System.Data.DbType.String, current2.ThumbnailsUrl);
num++;
}
sqlStringCommand.CommandText = stringBuilder.ToString().Remove(stringBuilder.Length - 1);
if (dbTran != null)
{
result = (this.database.ExecuteNonQuery(sqlStringCommand, dbTran) > 0);
}
else
{
result = (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
}
return(result);
}
