public void Update(ZcOrderTransit obj) { MySqlConnection conn = null; MySqlCommand cmd = null; try { conn = GetConnection(); string sql = "update zc_order_transit set updateTime = @time, goodsnum = @goodsnum, orderAmount= @orderAmount, orderstatus = @orderstatus where id = @id "; cmd = new MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("@time", obj.UpdateTime); cmd.Parameters.AddWithValue("@goodsnum", obj.GoodSnum); cmd.Parameters.AddWithValue("@orderAmount", obj.OrderAmount); cmd.Parameters.AddWithValue("@orderstatus", obj.OrderStatus); cmd.Parameters.AddWithValue("@id", obj.Id); cmd.ExecuteNonQuery(); } catch (Exception ex) { log.Error("更新zc_order_transit 订单时发生错误", ex); } finally { cmd.Dispose(); CloseConnection(conn); } }
/// <summary> /// 将zcOrderTransit 转化为zcOrderHistory /// </summary> /// <param name="obj"></param> /// <returns></returns> public static ZcOrderHistory Tranform(ZcOrderTransit obj) { ZcOrderHistory history = new ZcOrderHistory(); history.Id = obj.Id; history.CreateTime = obj.CreateTime; history.UpdateTime = DateTime.Now; history.BranchId = obj.BranchId; history.Cansignphone = obj.Cansignphone; history.Consignee = obj.Consignee; history.GoodSnum = obj.GoodSnum; history.IsGift = obj.IsGift; history.MemberCardNumber = obj.MemberCardNumber; history.OrderAmount = obj.OrderAmount; history.OrderCome = obj.OrderCome; history.OrderDate = obj.OrderDate; history.OrderNum = obj.OrderNum; history.OrderRedUceAmount = obj.OrderRedUceAmount; history.OrderStatus = obj.OrderStatus; history.OrderTotalValue = obj.OrderTotalValue; history.PullFlag = obj.PullFlag; history.MemberId = obj.MemberId; history.ZczoingId = obj.ZczoingId; return(history); }
public List <ZcOrderTransit> FindAll() { List <ZcOrderTransit> list = new List <ZcOrderTransit>(); OracleConnection conn = null; try { conn = OracleUtil.OpenConn(); string sql = "select ID, CREATETIME, UPDATETIME, BRANCHID, CANSIGNPHONE, CONSIGNEE, " + " GOODSNUM, ISGIFT, MEMBERCARDNUMBER, ORDERAMOUNT, ORDERCOME, ORDERDATE, ORDERNUM, ORDERREDUCEAMOUNT, " + " ORDERSTATUS, ORDERTOTALVALUE, PULLFLAG, MEMBER_ID, ZCZONING_ID from zc_order_transit where branchid ='" + LoginUserInfo.street + "'"; OracleCommand command = new OracleCommand(sql); command.Connection = conn; var reader = command.ExecuteReader(); while (reader.Read()) { ZcOrderTransit obj = new ZcOrderTransit(); 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.BranchId = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); obj.Cansignphone = reader.IsDBNull(4) ? string.Empty : reader.GetString(4); obj.Consignee = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); obj.GoodSnum = reader.IsDBNull(6) ? default(int) : reader.GetInt32(6); obj.IsGift = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); obj.MemberCardNumber = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); obj.OrderAmount = reader.IsDBNull(9) ? default(float) : reader.GetFloat(9); obj.OrderCome = reader.IsDBNull(10) ? string.Empty : reader.GetString(10); obj.OrderDate = reader.IsDBNull(11) ? default(DateTime) : reader.GetDateTime(11); obj.OrderNum = reader.IsDBNull(12) ? string.Empty : reader.GetString(12); obj.OrderRedUceAmount = reader.IsDBNull(13) ? default(float) : reader.GetFloat(13); obj.OrderStatus = reader.IsDBNull(14) ? string.Empty : reader.GetString(14); obj.OrderTotalValue = reader.IsDBNull(15) ? default(float) : reader.GetFloat(15); obj.PullFlag = reader.IsDBNull(16) ? string.Empty : reader.GetString(16); obj.MemberId = reader.IsDBNull(17) ? string.Empty : reader.GetString(17); obj.ZczoingId = reader.IsDBNull(18) ? string.Empty : reader.GetString(18); list.Add(obj); } } catch (Exception ex) { log.Error("从远处服务器查询订单信息失败", ex); } finally { OracleUtil.CloseConn(conn); } return(list); }
public List <ZcOrderTransit> FindAll() { List <ZcOrderTransit> list = new List <ZcOrderTransit>(); MySqlConnection conn = null; MySqlCommand cmd = new MySqlCommand(); string sql = "select * from zc_order_transit"; try { conn = GetConnection(); cmd.CommandText = sql; cmd.Connection = conn; var reader = cmd.ExecuteReader(); while (reader.Read()) { ZcOrderTransit obj = new ZcOrderTransit(); 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.BranchId = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); obj.Cansignphone = reader.IsDBNull(4) ? string.Empty : reader.GetString(4); obj.Consignee = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); obj.GoodSnum = reader.IsDBNull(6) ? default(int) : reader.GetInt32(6); obj.IsGift = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); obj.MemberCardNumber = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); obj.OrderAmount = reader.IsDBNull(9) ? default(float) : reader.GetFloat(9); obj.OrderCome = reader.IsDBNull(10) ? string.Empty : reader.GetString(10); obj.OrderDate = reader.IsDBNull(11) ? default(DateTime) : reader.GetDateTime(11); obj.OrderNum = reader.IsDBNull(12) ? string.Empty : reader.GetString(12); obj.OrderRedUceAmount = reader.IsDBNull(13) ? default(float) : reader.GetFloat(13); obj.OrderStatus = reader.IsDBNull(14) ? string.Empty : reader.GetString(14); obj.OrderTotalValue = reader.IsDBNull(15) ? default(float) : reader.GetFloat(15); obj.PullFlag = reader.IsDBNull(16) ? string.Empty : reader.GetString(16); obj.MemberId = reader.IsDBNull(17) ? string.Empty : reader.GetString(17); obj.ZczoingId = reader.IsDBNull(18) ? string.Empty : reader.GetString(18); list.Add(obj); } } catch (Exception ex) { log.Error("获取订单信息失败", ex); } finally { cmd.Dispose(); CloseConnection(conn); } return(list); }
public ZcOrderTransit FindById(string id) { ZcOrderTransit obj = new ZcOrderTransit(); MySqlConnection conn = null; MySqlCommand cmd = null; try { conn = GetConnection(); String sql = "select * from zc_order_transit where id = @id"; cmd = new MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("id", id); var 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.BranchId = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); obj.Cansignphone = reader.IsDBNull(4) ? string.Empty : reader.GetString(4); obj.Consignee = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); obj.GoodSnum = reader.IsDBNull(6) ? default(int) : reader.GetInt32(6); obj.IsGift = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); obj.MemberCardNumber = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); obj.OrderAmount = reader.IsDBNull(9) ? default(float) : reader.GetFloat(9); obj.OrderCome = reader.IsDBNull(10) ? string.Empty : reader.GetString(10); obj.OrderDate = reader.IsDBNull(11) ? default(DateTime) : reader.GetDateTime(11); obj.OrderNum = reader.IsDBNull(12) ? string.Empty : reader.GetString(12); obj.OrderRedUceAmount = reader.IsDBNull(13) ? default(float) : reader.GetFloat(13); obj.OrderStatus = reader.IsDBNull(14) ? string.Empty : reader.GetString(14); obj.OrderTotalValue = reader.IsDBNull(15) ? default(float) : reader.GetFloat(15); obj.PullFlag = reader.IsDBNull(16) ? string.Empty : reader.GetString(16); obj.MemberId = reader.IsDBNull(17) ? string.Empty : reader.GetString(17); obj.ZczoingId = reader.IsDBNull(18) ? string.Empty : reader.GetString(18); } } catch (Exception ex) { log.Error("根据id获取订单信息异常", ex); } finally { cmd.Dispose(); CloseConnection(conn); } return(obj); }
public void Update(ZcOrderTransit obj) { BranchZcOrderTransitDao dao = new BranchZcOrderTransitDao(); dao.Update(obj); }