public string CreateOrderSubmitDAL(ConsigneeSearchCondition consignee) { string result = string.Empty; using (SqlConnection conn = new SqlConnection(connStr)) { try { SqlCommand cmd = new SqlCommand("pro_wms_CreateOrderConsignee", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserName", consignee.UserName); cmd.Parameters[0].SqlDbType = SqlDbType.NVarChar; cmd.Parameters[0].Size = 50; cmd.Parameters.AddWithValue("@UserPhone", consignee.UserPhone); cmd.Parameters[1].SqlDbType = SqlDbType.NVarChar; cmd.Parameters[1].Size = 100; cmd.Parameters.AddWithValue("@UserAddress", consignee.UserAddress); cmd.Parameters[2].SqlDbType = SqlDbType.NVarChar; cmd.Parameters[2].Size = 100; cmd.Parameters.AddWithValue("@UserEmail", consignee.UserEmail); cmd.Parameters[3].SqlDbType = SqlDbType.NVarChar; cmd.Parameters[3].Size = 100; cmd.Parameters.AddWithValue("@DeliveryDate", consignee.DeliveryDate); cmd.Parameters[4].SqlDbType = SqlDbType.NVarChar; cmd.Parameters[4].Size = 50; cmd.Parameters.AddWithValue("@ReturnDate", consignee.ReturnDate); cmd.Parameters[5].SqlDbType = SqlDbType.NVarChar; cmd.Parameters[5].Size = 50; cmd.Parameters.AddWithValue("@Result", ""); cmd.Parameters[6].Direction = ParameterDirection.Output; cmd.Parameters[6].SqlDbType = SqlDbType.VarChar; cmd.Parameters[6].Size = 8000; conn.Open(); cmd.CommandTimeout = 180; cmd.ExecuteNonQuery(); result = cmd.Parameters[6].Value.ToString(); conn.Close(); } catch (Exception) { throw; } } return(result); }
public string CreateOrderSubmitBLL(ConsigneeSearchCondition consignee) { return(accessor.CreateOrderSubmitDAL(consignee)); }