public XPeCodeViewModel Ddlpe(int page, int size, int supplier, int store, string status)
{
var model = new XPeCodeViewModel();
var paramss = new DynamicParameters();
paramss.Add("page", page);
paramss.Add("size", size);
paramss.Add("supplier", supplier);
paramss.Add("store", store);
paramss.Add("status", status);
paramss.Add("out", dbType: DbType.Int32, direction: ParameterDirection.Output);
using (var sql = GetSqlConnection())
{
var data = sql.Query <V3_DDL_PE>("V3_GetPEDDL", paramss, commandType: CommandType.StoredProcedure);
sql.Close();
model.PEs = data.ToList();
var total = paramss.Get <int>("out");
model.TotalRecords = total;
}
return(model);
}
public XPeCodeViewModel Ddlpe(int page, int size, int supplier, int store, string status)
{
var model = new XPeCodeViewModel();
var paramss = new DynamicParameters();
paramss.Add("page", page);
paramss.Add("size", size);
paramss.Add("supplier", supplier);
paramss.Add("store", store);
paramss.Add("status", status);
paramss.Add("out", dbType: DbType.Int32, direction: ParameterDirection.Output);
using (var sql = GetSqlConnection())
{
var data = sql.Query<V3_DDL_PE>("V3_GetPEDDL", paramss, commandType: CommandType.StoredProcedure);
sql.Close();
model.PEs = data.ToList();
var total = paramss.Get<int>("out");
model.TotalRecords = total;
}
return model;
}
