//添加transitOrder数据 public void AddtransitOrder(ZcProcessOrder obj) { string sql = "insert into ZC_ORDER_TRANSIT values " + " (:id ,:createTime, :updateTime, :BRANCHID , :CANSIGNPHONE, :CONSIGNEE, :GOODSNUM, :ISGIFT, :MEMBERCARDNUMBER, :ORDERAMOUNT,:ORDERCOME, :ORDERDATE, :ORDERNUM , :ORDERREDUCEAMOUNT, :ORDERSTATUS, :ORDERTOTALVALUE, :PULLFLAG, :MEMBER_ID, :ZCZONING_ID)"; OracleConnection conn = null; OracleCommand cmd = new OracleCommand(); OracleTransaction tran = null; try { conn = OracleUtil.OpenConn(); tran = conn.BeginTransaction(); cmd.CommandText = sql; cmd.Connection = conn; cmd.Parameters.Add(":id", obj.id); cmd.Parameters.Add(":createTime", obj.createTime); cmd.Parameters.Add(":updateTime", obj.updateTime); cmd.Parameters.Add(":BRANCHID", obj.branchId); cmd.Parameters.Add(":CANSIGNPHONE", obj.cansignPhone); cmd.Parameters.Add(":CONSIGNEE", obj.consignee); cmd.Parameters.Add(":GOODSNUM", obj.goodsNum); cmd.Parameters.Add(":ISGIFT", obj.isGift); cmd.Parameters.Add(":MEMBERCARDNUMBER", obj.memberCardNumber); cmd.Parameters.Add(":ORDERAMOUNT", obj.orderAmount); cmd.Parameters.Add(":ORDERCOME", obj.orderCome); cmd.Parameters.Add(":ORDERDATE", obj.orderDate); cmd.Parameters.Add(":ORDERNUM", obj.orderNum); cmd.Parameters.Add(":ORDERREDUCEAMOUNT", obj.orderReduceAmount); cmd.Parameters.Add(":ORDERSTATUS", obj.orderStatus); cmd.Parameters.Add(":ORDERTOTALVALUE", obj.orderTotalValue); cmd.Parameters.Add(":PULLFLAG", obj.pullFlag); cmd.Parameters.Add(":MEMBER_ID", obj.associator); cmd.Parameters.Add(":ZCZONING_ID", obj.zcZoning); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); } finally { cmd.Dispose(); cmd.Dispose(); OracleUtil.CloseConn(conn); } }
/// <summary> /// 从线上服务器获取所有的用户 /// </summary> /// <returns></returns> public List <ZcProcessOrder> FindAll(string branchId) { List <ZcProcessOrder> list = new List <ZcProcessOrder>(); OracleConnection conn = null; try { conn = OracleUtil.OpenConn(); string sql = "select * from zc_order_process where branchid='" + branchId + "'"; OracleCommand command = new OracleCommand(sql); command.Connection = conn; var reader = command.ExecuteReader(); while (reader.Read()) { ZcProcessOrder user = new ZcProcessOrder(); user.id = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); user.createTime = reader.IsDBNull(1) ? default(DateTime) : reader.GetDateTime(1); user.updateTime = reader.IsDBNull(2) ? default(DateTime) : reader.GetDateTime(2); user.branchId = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); user.cansignPhone = reader.IsDBNull(4) ? string.Empty : reader.GetString(4); user.consignee = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); user.goodsNum = reader.IsDBNull(6) ? default(int) : reader.GetInt32(6); user.isGift = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); user.memberCardNumber = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); user.orderAmount = reader.IsDBNull(9) ? default(double) : reader.GetDouble(9); user.orderCome = reader.IsDBNull(10) ? string.Empty : reader.GetString(10); user.orderDate = reader.IsDBNull(11) ? default(DateTime) : reader.GetDateTime(11); user.orderNum = reader.IsDBNull(12) ? string.Empty : reader.GetString(12); user.orderReduceAmount = reader.IsDBNull(13) ? default(double) : reader.GetDouble(13); user.orderStatus = reader.IsDBNull(14) ? string.Empty : reader.GetString(14); user.orderTotalValue = reader.IsDBNull(15) ? default(double) : reader.GetDouble(15); user.pullFlag = reader.IsDBNull(16) ? string.Empty : reader.GetString(16); user.associator = reader.IsDBNull(17) ? string.Empty : reader.GetString(17); user.zcZoning = reader.IsDBNull(18) ? string.Empty : reader.GetString(18); list.Add(user); } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { OracleUtil.CloseConn(conn); } return(list); }