示例#1
0
        public static bool UpdateOrderInfo(BatchShipping o)
        {
            try
            {
                string query = @"update BatchShipping 
                                set OrderNo = @OrderNo,subOrderNo = @subOrderNo,yunDanNo = @yunDanNo,commpany = @commpany
                                where id = @id";

                SqlParameter[] param = new SqlParameter[]
                {
                    new SqlParameter("@OrderNo", o.OrderNo),
                    new SqlParameter("@subOrderNo", o.SubOrderNo),
                    new SqlParameter("@yunDanNo", o.YunDanNo),
                    new SqlParameter("@commpany", o.Commpany),
                    new SqlParameter("@id", o.Id)
                };
                DataBase.ExecuteSql(query, param);
                return(true);
            }
            catch (Exception ex)
            {
                ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
                return(false);
            }
        }
示例#2
0
        public static bool AddBatchShipping(BatchShipping o)
        {
            try
            {
                string query = @"insert into BatchShipping(sellerNick,OrderNo,subOrderNo,yunDanNo,commpany,status,createDate)
                                values(@sellerNick,@OrderNo,@subOrderNo,@yunDanNo,@commpany,@status,@createDate)";

                SqlParameter[] param = new SqlParameter[]
                {
                    new SqlParameter("@sellerNick", o.SellerNick),
                    new SqlParameter("@OrderNo", o.OrderNo),
                    new SqlParameter("@subOrderNo", o.SubOrderNo),
                    new SqlParameter("@yunDanNo", o.YunDanNo),
                    new SqlParameter("@commpany", o.Commpany),
                    new SqlParameter("@status", o.Status),
                    new SqlParameter("@createDate", DateTime.Now.ToShortDateString())
                };
                DataBase.ExecuteSql(query, param);
                return(true);
            }
            catch (Exception ex)
            {
                ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
                return(false);
            }
        }
示例#3
0
 public static bool AddBatchShipping(BatchShipping o)
 {
     return(BatchShippingDAL.AddBatchShipping(o));
 }
示例#4
0
 public static bool UpdateOrderInfo(BatchShipping o)
 {
     return(BatchShippingDAL.UpdateOrderInfo(o));
 }