/// <summary>
/// 将ZcOrderTransitItem 转换为 ZcOrderHistoryItem
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public List <ZcOrderHistoryItem> Transform(List <ZcOrderTransitItem> list)
{
List <ZcOrderHistoryItem> rlist = new List <ZcOrderHistoryItem>();
foreach (ZcOrderTransitItem obj in list)
{
ZcOrderHistoryItem item = new ZcOrderHistoryItem();
item.Id = obj.Id;
item.CreateTime = obj.CreateTime;
item.UpdateTime = obj.UpdateTime;
item.AddOn = obj.AddOn;
item.Amount = obj.Amount;
item.Bn = obj.Bn;
item.Cost = obj.Cost;
item.GPrice = obj.GPrice;
item.GoodsState = obj.GoodsState;
item.ItemType = obj.ItemType;
item.Name = obj.Name;
item.Nums = obj.Nums;
item.ObjId = obj.ObjId;
item.OrderId = obj.OrderId;
item.Price = obj.Price;
item.ProductId = obj.ProductId;
item.Score = obj.Score;
item.SendNum = obj.SendNum;
item.TypeId = obj.TypeId;
item.Weight = obj.Weight;
item.GoodsFileId = obj.GoodsFileId;
item.ProviderId = obj.ProviderId;
rlist.Add(item);
}
return(rlist);
}
public bool AddZcOrderHistoryItemI(ZcOrderHistoryItem obj)
{
bool flag = false;
string sql = "insert into zc_order_history_item values (:id,:createTime,:updateTime, :actual_money, :actual_nums,:addOn,:amount,:bn,:cost,:gPrice,:goodsState,:itemType,"
+ ":name,:nums,:objId,:orderId,:price,:productId,:score,:sendNum,:TypeId,:weight,:fileId,:providerId)";
OracleConnection conn = null;
OracleTransaction tran = null;
OracleCommand cmd = new OracleCommand();
try
{
conn = OracleUtil.OpenConn();
tran = conn.BeginTransaction();
cmd.CommandText = sql;
cmd.Connection = conn;
cmd.Parameters.Add(new OracleParameter(":id", obj.Id));
cmd.Parameters.Add(new OracleParameter(":createTime", obj.CreateTime));
cmd.Parameters.Add(new OracleParameter(":updateTime", obj.UpdateTime));
cmd.Parameters.Add(":actual_money", obj.actualMoney);
cmd.Parameters.Add(":actual_nums", obj.actualNums);
cmd.Parameters.Add(new OracleParameter(":addOn", obj.AddOn));
cmd.Parameters.Add(new OracleParameter(":amount", obj.Amount));
cmd.Parameters.Add(new OracleParameter(":bn", obj.Bn));
cmd.Parameters.Add(new OracleParameter(":cost", obj.Cost));
cmd.Parameters.Add(new OracleParameter(":gPrice", obj.GPrice));
cmd.Parameters.Add(new OracleParameter(":goodsState", obj.GoodsState));
cmd.Parameters.Add(new OracleParameter(":itemType", obj.ItemType));
cmd.Parameters.Add(new OracleParameter(":name", obj.Name));
cmd.Parameters.Add(new OracleParameter(":nums", obj.Nums));
cmd.Parameters.Add(new OracleParameter(":objId", obj.ObjId));
cmd.Parameters.Add(new OracleParameter(":orderId", obj.OrderId));
cmd.Parameters.Add(new OracleParameter(":price", obj.Price));
cmd.Parameters.Add(new OracleParameter(":productId", obj.ProductId));
cmd.Parameters.Add(new OracleParameter(":score", obj.Score));
cmd.Parameters.Add(new OracleParameter(":sendNum", obj.SendNum));
cmd.Parameters.Add(new OracleParameter(":TypeId", obj.TypeId));
cmd.Parameters.Add(new OracleParameter(":weight", obj.Weight));
cmd.Parameters.Add(new OracleParameter(":fileId", obj.GoodsFileId));
cmd.Parameters.Add(new OracleParameter(":providerId", obj.ProviderId));
cmd.ExecuteNonQuery();
tran.Commit();
flag = true;
}
catch (Exception ex)
{
tran.Rollback();
flag = false;
log.Error("新增zc_order_history_item发生异常", ex);
}
finally
{
cmd.Dispose();
tran.Dispose();
OracleUtil.CloseConn(conn);
}
return(flag);
}
public ZcOrderHistoryItem FindById(string p)
{
ZcOrderHistoryItem obj = new ZcOrderHistoryItem();
MySqlConnection conn = null;
MySqlCommand cmd = new MySqlCommand();
try
{
conn = GetConnection();
string sql = "select * from ZC_ORDER_history_ITEM where id = @id ";
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@id", p);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
obj.Id = reader.IsDBNull(0) ? string.Empty : reader.GetString(0);
obj.CreateTime = reader.IsDBNull(1) ? default(DateTime) : reader.GetDateTime(1);
obj.UpdateTime = reader.IsDBNull(2) ? default(DateTime) : reader.GetDateTime(2);
obj.AddOn = reader.IsDBNull(3) ? default(float) : reader.GetFloat(3);
obj.Amount = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
obj.Bn = reader.IsDBNull(5) ? string.Empty : reader.GetString(5);
obj.Cost = reader.IsDBNull(6) ? string.Empty : reader.GetString(6);
obj.GPrice = reader.IsDBNull(7) ? string.Empty : reader.GetString(7);
obj.GoodsState = reader.IsDBNull(8) ? string.Empty : reader.GetString(8);
obj.ItemType = reader.IsDBNull(9) ? string.Empty : reader.GetString(9);
obj.Name = reader.IsDBNull(10) ? string.Empty : reader.GetString(10);
obj.Nums = reader.IsDBNull(11) ? string.Empty : reader.GetString(11);
obj.ObjId = reader.IsDBNull(12) ? string.Empty : reader.GetString(12);
obj.OrderId = reader.IsDBNull(13) ? string.Empty : reader.GetString(13);
obj.Price = reader.IsDBNull(14) ? string.Empty : reader.GetString(14);
obj.ProductId = reader.IsDBNull(15) ? string.Empty : reader.GetString(15);
obj.Score = reader.IsDBNull(16) ? string.Empty : reader.GetString(16);
obj.SendNum = reader.IsDBNull(17) ? string.Empty : reader.GetString(17);
obj.TypeId = reader.IsDBNull(18) ? string.Empty : reader.GetString(18);
obj.Weight = reader.IsDBNull(19) ? string.Empty : reader.GetString(19);
obj.GoodsFileId = reader.IsDBNull(20) ? string.Empty : reader.GetString(20);
obj.ProviderId = reader.IsDBNull(21) ? string.Empty : reader.GetString(21);
obj.actualMoney = reader.IsDBNull(22) ? string.Empty : reader.GetString(22);
obj.actualNums = reader.IsDBNull(23) ? string.Empty : reader.GetString(23);
}
}
catch (Exception ex)
{
log.Error("查询订单历史表失败", ex);
}
finally
{
cmd.Dispose();
CloseConnection(conn);
}
return(obj);
}
public bool AddZcOrderHistoryItemI(ZcOrderHistoryItem item)
{
ZcOrderHistoryItemDao dao = new ZcOrderHistoryItemDao();
return(dao.AddZcOrderHistoryItemI(item));
}
/// <summary>
/// 网络连通时，上传数据
/// </summary>
public static void Upload()
{
UploadDao dao = new UploadDao();
int count = dao.QueryCount();
if (count != 0)
{
List <UploadInfo> list = dao.FindAll();
foreach (UploadInfo obj in list)
{
if (obj.Type == Constant.DAILY_RECEIVE_GOODS)
{
BranchDailyReceiveGoodsDao dailyDao = new BranchDailyReceiveGoodsDao();
DailyReceiveGoods drg = dailyDao.FindById(obj.Id);
drg.CreateTime = DateTime.Now;
drg.UpdateTime = DateTime.Now;
DailyReceiveGoodsService service = new DailyReceiveGoodsService();
bool flag = service.AddDailyReceiveGoods(drg);
if (flag)
{
dao.DeleteByIdAndType(obj.Id, obj.Type);
}
}
else if (obj.Type == Constant.ZC_ORDER_TRANSIT_UPDATE)
{
ZcOrderTransitService service = new ZcOrderTransitService();
bool flag = service.UpdateStatus(obj.Id, Constant.ORDER_STATUS_RECEIPT);
if (flag)
{
dao.DeleteByIdAndType(obj.Id, obj.Type);
}
}
else if (obj.Type == Constant.PAY_INFO)
{
BranchPayInfoService service = new BranchPayInfoService();
PayInfo payInfo = service.FindById(obj.Id);
PayInfoService masterService = new PayInfoService();
bool flag = masterService.AddPayInfoI(payInfo);
if (flag)
{
dao.DeleteByIdAndType(obj.Id, obj.Type);
}
}
else if (obj.Type == Constant.ZC_ORDER_HISTORY)
{
BranchZcOrderHistoryService branchService = new BranchZcOrderHistoryService();
ZcOrderHistory history = branchService.FindById(obj.Id);
ZcOrderHistoryService service = new ZcOrderHistoryService();
bool flag = service.AddZcOrderHistoryI(history);
if (flag)
{
dao.DeleteByIdAndType(obj.Id, obj.Type);
}
}
else if (obj.Type == Constant.ZC_ORDER_HISTORY_ITEM)
{
BranchZcOrderHistoryItemService branchService = new BranchZcOrderHistoryItemService();
ZcOrderHistoryItem item = branchService.FindById(obj.Id);
ZcOrderHistoryItemService service = new ZcOrderHistoryItemService();
bool flag = service.AddZcOrderHistoryItemI(item);
if (flag)
{
dao.DeleteByIdAndType(obj.Id, obj.Type);
}
}
else if (obj.Type == Constant.ZC_ORDER_TRANSIT_DELETE)
{
ZcOrderTransitService service = new ZcOrderTransitService();
bool flag = service.DeleteById(obj.Id);
if (flag)
{
dao.DeleteByIdAndType(obj.Id, obj.Type);
}
}
else if (obj.Type == Constant.ZC_ORDER_TRANSIT_ITEM_DELETE)
{
ZcOrderTransitItemService service = new ZcOrderTransitItemService();
bool flag = service.DeleteByOrderIdI(obj.Id);
if (flag)
{
dao.DeleteByIdAndType(obj.Id, obj.Type);
}
}
else if (obj.Type == Constant.ZC_ORDER_REFUSE)
{
BranchZcOrderRefuseService branchService = new BranchZcOrderRefuseService();
ZcOrderRefuse refuse = branchService.FindById(obj.Id);
ZcOrderRefuseService service = new ZcOrderRefuseService();
bool flag = service.AddZcOrderRefuseI(refuse);
if (flag)
{
dao.DeleteByIdAndType(obj.Id, obj.Type);
}
}
else if (obj.Type == Constant.ZC_ORDER_REFUSE_ITEM)
{
BranchZcOrderRefuseItemService branchService = new BranchZcOrderRefuseItemService();
ZcOrderRefuseItem item = branchService.FindById(obj.Id);
ZcOrderRefuseItemService service = new ZcOrderRefuseItemService();
bool flag = service.AddZcOrderRefuseItemI(item);
if (flag)
{
dao.DeleteByIdAndType(obj.Id, obj.Type);
}
}
else if (obj.Type == Constant.ZC_ORDER_REFUND)
{
BranchZcOrderRefundService branchService = new BranchZcOrderRefundService();
ZcOrderRefund refund = branchService.FindById(obj.Id);
RefundInfoService service = new RefundInfoService();
bool flag = service.AddZcOrderRefundI(refund);
if (flag)
{
dao.DeleteByIdAndType(obj.Id, obj.Type);
}
}
else if (obj.Type == Constant.ZC_ORDER_REFUND_ITEM)
{
BranchZcOrderRefundItemService branchService = new BranchZcOrderRefundItemService();
ZcOrderRefundItem item = branchService.FindById(obj.Id);
RefundInfoService service = new RefundInfoService();
bool flag = service.AddZcOrderRefundItemI(item);
if (flag)
{
dao.DeleteByIdAndType(obj.Id, obj.Type);
}
}
else if (obj.Type == Constant.ZC_ORDER_HISTORY_UPDATE)
{
BranchZcOrderHistoryService branchService = new BranchZcOrderHistoryService();
ZcOrderHistory history = branchService.FindById(obj.Id);
ZcOrderHistoryService service = new ZcOrderHistoryService();
bool flag = service.UpdateOrderStatusByIdsI(obj.Id, history.OrderStatus);
if (flag)
{
dao.DeleteByIdAndType(obj.Id, obj.Type);
}
}
}
}
}
