public int UpdateServiceOrder(UpdateServiceOrder order)
{
var sqlParamsList = new List <SqlParameter>();
var properties = order.GetType().GetProperties();
foreach (var pro in properties)
{
sqlParamsList.Add(new SqlParameter()
{
ParameterName = string.Format("@{0}", pro.Name),
Value = pro.GetValue(order, null)
});
}
sqlParamsList.Add(new SqlParameter()
{
ParameterName = "@Ret",
SqlDbType = SqlDbType.Int,
Direction = ParameterDirection.Output,
});
using (System.Data.Common.DbCommand cmd = Context.Database.Connection.CreateCommand())
{
try
{
//
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "P_PAY_UpdatePayOrder";
cmd.Parameters.AddRange(sqlParamsList.ToArray());
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
cmd.ExecuteNonQuery();
return(Convert.ToInt32(sqlParamsList[sqlParamsList.Count - 1].Value));
}
catch (Exception e)
{
LogHelper.Logger.Error(e.Message);
return(-1);
}
}
}
public void FailServiceOrder(UpdateServiceOrder order)
{
_purchaseService.FailServiceOrder(order);
}
public void FailServiceOrder(UpdateServiceOrder order)
{
LogHelper.Logger.Info(JsonHelper.ToJson(order));
_purchaseServiceRepository.UpdateServiceOrder(order);
}
