using MESClassLibrary.BLL.Log; using MESClassLibrary.EFModel; using MESClassLibrary.Model; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Reflection; using System.Text; using System.Threading.Tasks; namespace MESClassLibrary.BLL.BasicInfo { public class FactoryBLL { BasicBLL<tb_Factory> db = new BasicBLL<tb_Factory>(); /// <summary> /// 查询信息 /// </summary> /// <returns></returns> public string SearchInfo(string page, string pagesize, string FactoryName) { try { string jsonStr = "[]"; int total = 0;//总行数 List<tb_Factory> list = db.SearchAllInfo(); if (!String.IsNullOrEmpty(FactoryName)) { list = list.Where(p => p.FactoryName.Contains(FactoryName)).ToList();//按条件分页查询 } if (list.Count > 0) { total = list.Count; int Skipcount = (Convert.ToInt32(page) - 1) * Convert.ToInt32(pagesize); list = list.Skip(Skipcount).Take(Convert.ToInt32(pagesize)).ToList(); JsonDataModel<tb_Factory> md = new JsonDataModel<tb_Factory>(); md.total = total.ToString(); md.rows = list; jsonStr = JSONTools.ScriptSerialize<JsonDataModel<tb_Factory>>(md); } return jsonStr; } catch (Exception ex) { LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod()); return ""; } } /// <summary> /// 添加信息 /// </summary> /// <param name="md">生产线模型对象</param> /// <returns></returns> public bool AddInfo(tb_Factory md) { try { var list = db.SearchInfoByKey("FactoryName", md.FactoryName);//判断是否有重复数据 if (list != null) { if (list.Where(p => p.FactoryID != md.FactoryID).Count() > 0) { return false; } } return db.AddInfo(md); } catch (Exception ex) { LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod()); return false; } } /// <summary> /// 修改信息 /// </summary> /// <param name="md">生产线模型对象</param> /// <returns></returns> public bool UpdateInfo(tb_Factory md) { try { var list = db.SearchAllInfo().Where(p => p.FactoryName == md.FactoryName && p.FactoryID != md.FactoryID).ToList();//判断是否有重复数据 if (list.Count > 0) { return false; } //初始化要更新的字段 string[] proNames = new string[2]; proNames[0] = "FactoryName"; proNames[1] = "Des"; //必填字段初始化,如果不需要更新必填字段则设置为空即可,时间类型无需初始化 //如果没有初始化必填字段,更新会报错 //md.Des = ""; return db.UpdateInfo(md, proNames); } catch (Exception ex) { LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod()); return false; } } /// 删除生产线信息 public bool DelInfo(tb_Factory md) { try { return db.DelInfo(md); } catch (Exception ex) { LogErrBLL.AddInfo(ex.ToString(), MethodBase.GetCurrentMethod()); return false; } } public string GetComboboxData() { try { string jsonStr = "[]"; var list = db.SearchAllInfo().ToList();//判断是否有重复数据 jsonStr = JSONTools.ScriptSerialize<List<tb_Factory>>(list); return jsonStr; } catch (Exception) { return ""; } } } }