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