| | |
| | | { |
| | | unitPricePar = new SqlParameter("@UnitPrice", DBNull.Value); |
| | | } |
| | | SqlParameter DeliveryTime = null; |
| | | if (trueModel.DeliveryTime.HasValue) |
| | | { |
| | | DeliveryTime = new SqlParameter("@DeliveryTime", trueModel.DeliveryTime); |
| | | } |
| | | else |
| | | { |
| | | DeliveryTime = new SqlParameter("@DeliveryTime", DBNull.Value); |
| | | } |
| | | IList<SqlParameter> sqlParms = new List<SqlParameter>() |
| | | { |
| | | new SqlParameter(){ ParameterName ="@Keyid", SqlDbType=System.Data.SqlDbType.Int, DbType=System.Data.DbType.Int32, Direction=ParameterDirection.Output}, |
| | |
| | | new SqlParameter("@OrderTypeId",trueModel.OrderTypeId), |
| | | new SqlParameter("@PrintTypeId",trueModel.PrintTypeId), |
| | | new SqlParameter("@DocumentName",trueModel.DocumentName), |
| | | new SqlParameter("@DeliveryTime",trueModel.DeliveryTime), |
| | | DeliveryTime,//new SqlParameter("@DeliveryTime",trueModel.DeliveryTime), |
| | | new SqlParameter("@SellerId",trueModel.SellerId), |
| | | new SqlParameter("@BuyerId",trueModel.BuyerId), |
| | | new SqlParameter("@SellerName",trueModel.SellerName){SqlDbType=SqlDbType.VarChar,Size=200}, |
| | |
| | | { |
| | | unitPricePar = new SqlParameter("@UnitPrice", DBNull.Value); |
| | | } |
| | | SqlParameter DeliveryTime = null; |
| | | if (trueModel.DeliveryTime.HasValue) |
| | | { |
| | | DeliveryTime = new SqlParameter("@DeliveryTime", trueModel.DeliveryTime); |
| | | } |
| | | else |
| | | { |
| | | DeliveryTime = new SqlParameter("@DeliveryTime", DBNull.Value); |
| | | } |
| | | |
| | | |
| | | IList<SqlParameter> sqlParms = new List<SqlParameter>() |
| | | { |
| | |
| | | new SqlParameter("@SellerId",trueModel.SellerId), |
| | | new SqlParameter("@SellerName",trueModel.SellerName), |
| | | new SqlParameter("@DocumentName",trueModel.DocumentName), |
| | | new SqlParameter("@DeliveryTime",trueModel.DeliveryTime), |
| | | unitPricePar, |
| | | DeliveryTime,//new SqlParameter("@DeliveryTime",trueModel.DeliveryTime), |
| | | unitPricePar, |
| | | new SqlParameter("@SumPrice",trueModel.SumPrice), |
| | | new SqlParameter("@PayState",trueModel.PayState), |
| | | new SqlParameter("@Operator",trueModel.Operator), |