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