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; }