//添加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);
}
