public DataSet GetListAll101(int PageSize, int PageIndex, bool order, string orderField, bool like, string whereField, string whereString, string sql, string authKey)
{
if (islogin(authKey))
{
BLL.Data_Centre.Link bll = new BLL.Data_Centre.Link();
int recordCount, pageCount;
if (!string.IsNullOrEmpty(whereString))
{
sql += " and beactive='是' and (DrugsBase_ApprovalNumber='" + whereString + "' or DrugsBase_ID in (SELECT DrugsBase_ID FROM dbo.DrugsBase_ApprovalNumber_MadeIn_Foreign WHERE Registration_No='" + whereString + "'))";
whereString = " and beactive='是'";
}
var ds = bll.GetList1012(PageSize, PageIndex, order, orderField, like, whereField, whereString, out recordCount, out pageCount, sql).DataSet;
DataTable dt = new DataTable();
dt.Columns.Add("recordCount");
dt.Columns.Add("pageCount");
var dr = dt.NewRow();
dr["recordCount"] = recordCount;
dr["pageCount"] = pageCount;
dt.Rows.Add(dr);
ds.Tables.Add(dt);
return(ds);
}
else
{
return(null);
}
}
public DataSet GetShopList(int PageSize, int PageIndex, bool order, string orderField, bool like, string whereField, string whereString, int BinType, string authKey, int iden = 0)
{
if (islogin(authKey))
{
BLL.Data_Centre.Link bll = new BLL.Data_Centre.Link();
bll.ChangeDBData_Centre();
int recordCount, pageCount;
string sql = "";
if (iden == 0)
{
switch (BinType)
{
//未映射
case 1:
{
sql += "and Product_ID NOT IN (SELECT id FROM Data.Data_Centre.dbo.Link)";
break;
}
//已经映射
case 2:
{
sql += "and Product_ID IN (SELECT id FROM Data.Data_Centre.dbo.Link)";
break;
}
//全部
case 0:
{
break;
}
}
}
if (!string.IsNullOrEmpty(whereString))
{
sql += whereString;
}
whereString = null;
DataSet ds;
if (BinType == 1)
{
//取101可映射的产品数据
ds = bll.GetList1012(PageSize, PageIndex, order, orderField, like, whereField, whereString, out recordCount, out pageCount, sql).DataSet;
}
else
{
//取101的商品数据
ds = bll.GetList1013(PageSize, PageIndex, order, orderField, like, whereField, whereString, out recordCount, out pageCount, sql).DataSet;
ds.Tables[0].Columns.Add("foreColor", typeof(int));
foreach (DataRow item in ds.Tables[0].Rows)
{
item["iden"] = iden;
}
}
DataTable dt = new DataTable();
dt.Columns.Add("recordCount");
dt.Columns.Add("pageCount");
var dr = dt.NewRow();
dr["recordCount"] = recordCount;
dr["pageCount"] = pageCount;
dt.Rows.Add(dr);
ds.Tables.Add(dt);
return(ds);
}
else
{
return(null);
}
}