public void CreateDetainReason(DetainReason dr) { SqlParameter[] param=new SqlParameter[]{ SqlUtilities.GenerateInputIntParameter("@order_id", dr.OrderId), SqlUtilities.GenerateInputNVarcharParameter("@order_encode", 50, dr.OrderEncode), SqlUtilities.GenerateInputNVarcharParameter("@reason", 500, dr.Reason), SqlUtilities.GenerateInputDateTimeParameter("@create_time", dr.CreateTime), SqlUtilities.GenerateInputIntParameter("@user_id", dr.UserId) }; string sql = "INSERT INTO detain_reasons(order_id, order_encode, reason, create_time, user_id) VALUES(@order_id, @order_encode, @reason, @create_time, @user_id)"; SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param); }
public DetainReason GetDetainReasonByOrderId(int orderId) { DetainReason detainReason = null; SqlParameter[] param = new SqlParameter[] { SqlUtilities.GenerateInputIntParameter("@order_id", orderId) }; string sql = "SELECT id, order_id, order_encode, reason, create_time, user_id FROM detain_reasons WHERE order_id = @order_id"; using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param)) { while (dr.Read()) { detainReason = new DetainReason(); detainReason.Id = dr.GetInt32(0); detainReason.OrderId = dr.GetInt32(1); detainReason.OrderEncode = dr.GetString(2); detainReason.Reason = dr.GetString(3); detainReason.CreateTime = dr.GetDateTime(4); detainReason.UserId = dr.GetInt32(5); } } return detainReason; }
public static void CreateDetainReason(DetainReason dr) { dal.CreateDetainReason(dr); }