protected void Page_Load(object sender, EventArgs e)
{
var l = tbl_mrItem.GetQueries(dBase);
l.Filter.AndFilters.Add(tbl_mrItem.Fields.trone_id, 0, Shotgun.Model.Filter.EM_DataFiler_Operator.Less);
l.PageSize = 200;
l.Fields = new string[] { tbl_mrItem.Fields.id, tbl_mrItem.Fields.ori_order, tbl_mrItem.Fields.ori_trone,
tbl_mrItem.Fields.sp_api_url_id, tbl_mrItem.Fields.sp_id, tbl_mrItem.Fields.create_date };
l.SortKey.Add(tbl_mrItem.Fields.id, Shotgun.Model.Filter.EM_SortKeyWord.desc);
var urlids = l.GetColumnList <int>("distinct sp_api_url_id");
var url_list = LightDataModel.tbl_sp_api_urlItem.GetQueries(dBase);
url_list.Filter.AndFilters.Add(tbl_sp_api_urlItem.Fields.id, urlids);
url_list.SortKey.Add(tbl_sp_api_urlItem.Fields.name, Shotgun.Model.Filter.EM_SortKeyWord.asc);
url_list.PageSize = int.MaxValue;
rpSel.DataSource = url_list.GetDataList();
int uid;
if (int.TryParse(Request["urlId"], out uid))
{
l.Filter.AndFilters.Add(tbl_mrItem.Fields.sp_api_url_id, uid);
}
PS = new PageSpliter();
PS.NoTotalPage = false;
if (!PS.IsFromURL)
{
PS.CalcPageCount(l.TotalCount, l.PageSize);
}
l.CurrentPage = l.CurrentPage;
rpList.DataSource = l.GetDataList();
}
protected void Page_Load(object sender, EventArgs e)
{
var l = tbl_mrItem.GetQueries(dBase);
l.Filter.AndFilters.Add(tbl_mrItem.Fields.cp_id, new int[] { 0, 34 }).NullToValue = 0;;
l.PageSize = 200;
//l.Fields = new string[] { tbl_mrItem.Fields.id, tbl_mrItem.Fields.ori_order, tbl_mrItem.Fields.ori_trone,
// tbl_mrItem.Fields.sp_api_url_id, tbl_mrItem.Fields.sp_id, tbl_mrItem.Fields.create_date, tbl_mrItem.Fields.cp_id };
l.SortKey.Add(tbl_mrItem.Fields.id, Shotgun.Model.Filter.EM_SortKeyWord.desc);//通过ID进行排序
PS = new PageSpliter();
PS.NoTotalPage = false;
if (!PS.IsFromURL)
{
PS.CalcPageCount(l.TotalCount, l.PageSize);
}
l.CurrentPage = PS.CurrentPage;
var mrData = l.GetDataList();
rpList.DataSource = mrData;
if (mrData.Count == 0)
{
return;
}
//mrData[X].sp_api_url_id
var urlids = mrData.GetFieldValueArray <int>(tbl_mrItem.Fields.sp_api_url_id);
var url_list = LightDataModel.tbl_sp_api_urlItem.GetQueries(dBase); // 查询器
url_list.Filter.AndFilters.Add(tbl_sp_api_urlItem.Fields.id, urlids); //条件 WHERE
url_list.SortKey.Add(tbl_sp_api_urlItem.Fields.id, Shotgun.Model.Filter.EM_SortKeyWord.asc); //通过ID进行排序
url_list.PageSize = int.MaxValue;
urls = url_list.GetDataList();
rpSel.DataSource = urls;
var urlids_sp = mrData.GetFieldValueArray <int>(tbl_mrItem.Fields.sp_id);
var url_list_sp = LightDataModel.tbl_spItem.GetQueries(dBase); // 查询器
url_list_sp.Fields = new string[] { tbl_spItem.Fields.id, "short_name" }; //查询的参数
url_list_sp.Filter.AndFilters.Add(tbl_spItem.Fields.id, urlids_sp); //条件 WHERE
url_list_sp.SortKey.Add(tbl_spItem.Fields.id, Shotgun.Model.Filter.EM_SortKeyWord.asc); //通过ID进行排序
url_list_sp.PageSize = int.MaxValue;
urls_sp = url_list_sp.GetDataList();
var urlids_TDNM = mrData.GetFieldValueArray <int>(tbl_mrItem.Fields.trone_id);
var url_list_td_name = LightDataModel.tbl_troneItem.GetQueries(dBase);// 查询器
//url_list_td_name.Fields = new string[] {"trone_name" };//查询的参数
url_list_td_name.Filter.AndFilters.Add(tbl_troneItem.Fields.id, urlids_TDNM); //条件 WHERE
url_list_td_name.SortKey.Add(tbl_troneItem.Fields.id, Shotgun.Model.Filter.EM_SortKeyWord.asc); //通过ID进行排序
url_list_td_name.PageSize = int.MaxValue;
urls_td = url_list_td_name.GetDataList();
//rpList.DataSource = url_list.GetDataList();
int uid;
if (int.TryParse(Request["urlId"], out uid))
{
l.Filter.AndFilters.Add(tbl_mrItem.Fields.sp_api_url_id, uid);
}
}
