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 bool GetUserPower(string value, string authKey)
{
string name = GetName(authKey);
BLL.Data_Centre.Link bll = new BLL.Data_Centre.Link();
bll.ChangeDBShop();
string sql = string.Format(@"DECLARE @role VARCHAR(200)
SELECT @role = role
FROM yxs_administrators
WHERE name = '{0}'
SELECT operatecode
FROM dbo.yxs_roles_permissions
WHERE id IN ( SELECT *
FROM dbo.f_split(@role, ',') )", name);
DataTable dt = bll.ExecuteTable(sql);
foreach (DataRow dr in dt.Rows)
{
string v = dr["operatecode"].ToString();
if (value.Equals(v))
{
return(true);
}
}
return(false);
}
public DataSet GetCheckDataInfo(int iden, int PageSize, int PageIndex, bool order, string orderField, bool like, string whereField, string whereString, string authKey)
{
if (islogin(authKey))
{
string tablename = "View_CheckDataInfo";
BLL.Data_Centre.Link bll = new BLL.Data_Centre.Link();
int recordCount, pageCount;
string sql = " AND iden=" + iden + " ";
if (!string.IsNullOrEmpty(whereString))
{
sql += whereString;
}
whereString = null;
DataSet ds = bll.Data_CentreGetList(PageSize, PageIndex, order, orderField, like, whereField, whereString, out recordCount, out pageCount, sql, tablename).DataSet;
if (ds != null && ds.Tables.Count > 0)
{
ds.Tables[0].Columns.Add("strStockTypes");
ds.Tables[0].Columns.Add("strPriceTypes");
foreach (DataRow item in ds.Tables[0].Rows)
{
item["Erp_DrugName"] = item["Erp_DrugName"].ToString().Trim();
item["Erp_Manufacturer"] = item["Erp_Manufacturer"].ToString().Trim();
item["Erp_ApprovalNumber"] = item["Erp_ApprovalNumber"].ToString().Trim();
//库存含义
int iType = 0;
if (int.TryParse(item["StockTypes"].ToString(), out iType))
{
item["strStockTypes"] = GetUnit(iType);
}
//价格含义
iType = 0;
if (int.TryParse(item["PriceTypes"].ToString(), out iType))
{
item["strPriceTypes"] = GetUnit(iType);
}
}
}
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 bool DelCompleteLink(string t_id, int iden, string authKey)
{
if (islogin(authKey))
{
BLL.Data_Centre.Link bll = new BLL.Data_Centre.Link();
string sql = string.Format("DELETE dbo.Link WHERE t_id='{0}' AND iden={1}", t_id, iden);
bll.ExecuteNonQuery(sql);
return(true);
}
return(false);
}
public DataSet GetCompleteLink(string t_id, int iden, string authKey)
{
if (islogin(authKey))
{
string sql = string.Format("SELECT * FROM [Link] where t_id='{0}' and iden={1}", t_id, iden);
BLL.Data_Centre.Link bll = new BLL.Data_Centre.Link();
var dr = bll.ExecuteTable(sql).Rows[0];
bll.ChangeDBShop();
sql = string.Format("SELECT * FROM dbo._ViewDrugsBaseAndGoods WHERE Product_ID={0} ", dr["id"]);
return(bll.ExecuteDataSet(sql));
}
return(null);
}
public bool SetDefaultShop(int iden, string t_id, string is_default, string authKey)
{
if (islogin(authKey))
{
string sql = string.Format("UPDATE Link SET is_default={0} WHERE t_id='{1}' and iden={2}", is_default, t_id, iden);
BLL.Data_Centre.Link bll = new BLL.Data_Centre.Link();
bll.ExecuteNonQuery(sql);
return(true);
}
else
{
return(false);
}
}
public bool AddLink(Model.Data_Centre.Link model, string authKey)
{
if (islogin(authKey))
{
model.created = DateTime.Now;
model.updated = model.created;
BLL.Data_Centre.Link bll = new BLL.Data_Centre.Link();
if (!bll.Exists(model.id, model.t_id, model.iden))
{
if (bll.Exists(model.id, model.iden))
{
return(false);
}
bll.Add(model);
return(true);
}
}
return(false);
}
public string SetData(Model.Data_Centre.Link_Mid mid, int col, string authKey)
{
if (islogin(authKey))
{
int x = 0;
BLL.Data_Centre.Link_Mid bll = new BLL.Data_Centre.Link_Mid();
Product_Centre pc = new Product_Centre();
int spid = new BLL.Data_Centre.Link().GetSpid(mid.id, mid.iden);
if (mid.PriceType == mid.StockType && mid.StockType == 1)
{
//删除库存和价格同时为最小单位的数据
if (bll.Exists(mid.id, mid.iden))
{
if (bll.ExecuteNonQuery(string.Format("delete from link_mid where id={0} and iden={1}", mid.id, mid.iden)) > 0)
{
}
}
}
else
{
if (bll.Exists(mid.id, mid.iden))
{
//修改
if (bll.Update(mid))
{
}
}
else
{
//新增
if (bll.Add(mid))
{
}
}
}
pc.UpdateStock(spid, mid.iden);
new BLL.Data_Centre.Price().Updates((string)pc.ExecuteScalar("SELECT t_id FROM dbo.Link WHERE id=" + mid.id));
}
return("");
}
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);
}
}
public DataSet GetMaptoolList(int PageSize, int PageIndex, bool order, string orderField, bool like, string whereField, string whereString, int BinType, string authKey, int iden)
{
if (islogin(authKey))
{
string tablename = "View_Product1";
BLL.Data_Centre.Link bll = new BLL.Data_Centre.Link();
int recordCount, pageCount;
string sql = " and iden=" + iden + " ";
switch (BinType)
{
//未映射
case 1:
{
//orderField = "Stock";
//order = !order;
sql += "and id not in (SELECT t_id FROM dbo.Link WHERE iden=" + iden + ")";
break;
}
//全部
case 0:
{
//sql += "and iden =" + iden;
break;
}
//已映射
case 2:
{
sql += "and id in (SELECT t_id FROM dbo.Link WHERE iden=" + iden + ")";
break;
}
}
if (!string.IsNullOrEmpty(whereString))
{
sql += whereString;
}
whereString = null;
var ds = bll.Data_CentreGetList(PageSize, PageIndex, order, orderField, like, whereField, whereString, out recordCount, out pageCount, sql, tablename).DataSet;
ds.Tables[0].Columns.Add("StockToolTipText", typeof(string));
ds.Tables[0].Columns.Add("remark", typeof(string));
if (ds.Tables[0].Rows.Count > 0)
{
sql = string.Format("SELECT * FROM View_Stock1 WHERE iden={0} and id IN ({1})", iden, string.Join(",", ds.Tables[0].AsEnumerable().Select(x => "'" + x.Field <object>("id") + "'")));
var dtTemp = bll.ExecuteTable(sql);
sql = string.Format("SELECT id,tab FROM dbo.tags_2 WHERE iden={0} and id IN ({1})", iden, string.Join(",", ds.Tables[0].AsEnumerable().Select(x => "'" + x.Field <object>("id") + "'")));
DataTable dtT2 = bll.ExecuteTable(sql);
foreach (DataRow item in ds.Tables[0].Rows)
{
item["DrugsBase_DrugName"] = item["DrugsBase_DrugName"].ToString().Trim();
item["DrugsBase_Manufacturer"] = item["DrugsBase_Manufacturer"].ToString().Trim();
item["DrugsBase_ApprovalNumber"] = item["DrugsBase_ApprovalNumber"].ToString().Trim();
var temp = dtT2.Select("id='" + item["id"] + "'").ToArray();
if (temp.Count() > 0)
{
item["remark"] = temp[0]["tab"];
continue;
}
var drTemp = dtTemp.Select("id='" + item["id"] + "'").OrderBy(x => x.Field <string>("pihao")).ToArray();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
for (int i = 0; i < drTemp.Count(); i++)
{
sb.AppendFormat("批号:{0} 效期:{1} 库存:{2}\r\n", drTemp[i]["pihao"].ToString().Trim(), drTemp[i]["sxrq"].ToString().Trim().Replace(" 0:00:00", ""), drTemp[i]["Stock"].ToString().Trim());
if (Library.Lang.DataValidator.IsDateTime(drTemp[i]["sxrq"].ToString()))
{
if (DateTime.Parse(drTemp[i]["sxrq"].ToString()) < DateTime.Now.AddYears(1))
{
item["remark"] = "近效期";
}
}
else
{
item["remark"] = "效期异常";
}
}
item["StockToolTipText"] = sb.ToString();
}
}
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);
}
}
