/// <summary> /// summary> /// 按条件查询信息SmsSend /// </summary> /// <returns></returns> public static IEnumerable <SmsSend> Query(Expression <Func <SmsSend, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.SmsSend.Where(fun).ToList()); } }
/// <summary> /// summary> /// 按条件查询信息LogInfo /// </summary> /// <returns></returns> public static IEnumerable <LogInfo> Query(Expression <Func <LogInfo, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.LogInfo.Where(fun).ToList()); } }
/// <summary> /// summary> /// 按条件查询信息View_LogInfo_Dictionary /// </summary> /// <returns></returns> public static IEnumerable <View_LogInfo_Dictionary> QueryView_LogInfo_Dictionary(Expression <Func <View_LogInfo_Dictionary, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.View_LogInfo_Dictionary.Where(fun).ToList()); } }
/// <summary> /// summary> /// 按条件查询信息View_Menu_ControlRole /// </summary> /// <returns></returns> public static IEnumerable <View_Menu_ControlRole> QueryView_Menu_ControlRole(Expression <Func <View_Menu_ControlRole, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.View_Menu_ControlRole.Where(fun).ToList()); } }
/// <summary> /// LINQ更新方法 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="dc"></param> /// <param name="fun"></param> /// <param name="tentity"></param> /// <param name="action"></param> public static bool Update(Expression <Func <LogInfo, bool> > fun, Action <LogInfo> action) { bool rbool = true; DCQUALITYDataContext dc = new DCQUALITYDataContext(); try { var table = dc.LogInfo.Where(fun).ToList(); foreach (var item in table) { action(item); } dc.SubmitChanges(); } catch { dc.ChangeConflicts.ResolveAll(RefreshMode.KeepCurrentValues); dc.SubmitChanges(); rbool = false; } finally { dc.Connection.Close(); } return(rbool); }
/// <summary> /// 查询所有信息 /// </summary> /// <returns></returns> public static IEnumerable <Unusualstandard> Query() { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.Unusualstandard.ToList()); } }
/// <summary> /// 查询单条 返回实体 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="fun"></param> /// <returns></returns> public static Unusualstandard Single(Expression <Func <Unusualstandard, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.Unusualstandard.SingleOrDefault(fun)); } }
/// <summary> /// 查询单条 返回实体 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="fun"></param> /// <returns></returns> public static Packets Single(Expression <Func <Packets, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.Packets.SingleOrDefault(fun)); } }
public static List <Dictionary> GetListDictionary() { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.Dictionary.ToList()); } }
{ /// <summary> /// 查询所有信息 /// </summary> /// <returns></returns> public static IEnumerable <Packets> Query() { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.Packets.ToList()); } }
/// <summary> /// summary> /// 按条件查询信息Packets /// </summary> /// <returns></returns> public static IEnumerable <Packets> Query(Expression <Func <Packets, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.Packets.Where(fun).ToList()); } }
/// <summary> /// 查询所有信息 /// </summary> /// <returns></returns> public static IEnumerable <DRAW_EXAM_INTERFACE> Query(Expression <Func <DRAW_EXAM_INTERFACE, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.DRAW_EXAM_INTERFACE.Where(fun).ToList()); } }
/// <summary> /// summary> /// </summary> /// <returns></returns> public static IEnumerable <View_Collection> Query(Expression <Func <View_Collection, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.View_Collection.Where(fun).ToList()); } }
/// <summary> /// 查询单条 返回实体 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="fun"></param> /// <returns></returns> public static SmsSend Single(Expression <Func <SmsSend, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.SmsSend.SingleOrDefault(fun)); } }
/// <summary> /// 查询单条 返回实体 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="fun"></param> /// <returns></returns> public static WaterTestConfigureSet Single(Expression <Func <WaterTestConfigureSet, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.WaterTestConfigureSet.SingleOrDefault(fun)); } }
/// <summary> /// 根据启动状态和字典值获取字典信息 /// </summary> /// <param name="strValue">字典值</param> /// <returns></returns> public static List <Dictionary> GetValueStateDictionary(string strValue) { List <Dictionary> list = new List <Dictionary>(); using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { try { int itemid = db.Dictionary.First(d => (d.Dictionary_Value == strValue && d.Dictionary_State == true)).Dictionary_ID; var v = (from c in db.Dictionary where (c.Dictionary_ID == itemid || c.Dictionary_OtherID.Value == itemid) && c.Dictionary_State == true select c.Dictionary_ID).ToArray(); list = (from c in db.Dictionary where c.Dictionary_State == true && v.Contains(c.Dictionary_OtherID.Value) select c).ToList(); Dictionary dic = new Dictionary(); dic.Dictionary_ID = 0; dic.Dictionary_Name = "全部"; list.Add(dic); } catch (Exception ex) { } finally { db.Connection.Close(); } } return(list); }
/// <summary> /// 修改客户端信息 /// 注意:请在编写实体之前先获取实体再进行修改的字段编写 /// </summary> /// <param name="record">客户端实体(ClientInfo)</param> /// <returns></returns> public static bool UpdateOneQcRecord(ClientInfo client) { bool rbool = false; using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { try { ClientInfo qInfo = db.ClientInfo.First(c => c.Client_ID == client.Client_ID); qInfo.Client_ADDRESS = client.Client_ADDRESS; qInfo.Client_Dictionary_ID = client.Client_Dictionary_ID; qInfo.Client_NAME = client.Client_NAME; qInfo.Client_Phone = client.Client_Phone; qInfo.Client_REMARK = client.Client_REMARK; qInfo.Client_TestItems_ID = client.Client_TestItems_ID; db.SubmitChanges(); rbool = true; } catch (Exception ex) { } finally { db.Connection.Close(); } } return(rbool); }
/// <summary> /// 多项更改 /// 使用SubmitChanges将对检索到的进行的更新保持回数据库 /// </summary> /// <param name="dictionary">Dictionary实体对象</param> /// <returns></returns> public static bool UpdateMore(Dictionary dictionary) { bool rbool = true; try { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { var q = from p in db.Dictionary where p.Dictionary_ID == dictionary.Dictionary_ID select p; foreach (var p in q) { p.Dictionary_Name = dictionary.Dictionary_Name; p.Dictionary_OtherID = dictionary.Dictionary_OtherID; p.Dictionary_Remark = dictionary.Dictionary_Remark; p.Dictionary_State = dictionary.Dictionary_State; p.Dictionary_Value = dictionary.Dictionary_Value; } db.SubmitChanges(); } } catch (Exception ex) { rbool = false; } return(rbool); }
/// <summary> /// summary> /// 按条件查询信息Unusualstandard /// </summary> /// <returns></returns> public static IEnumerable <Unusualstandard> Query(Expression <Func <Unusualstandard, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.Unusualstandard.Where(fun).ToList()); } }
/// <summary> /// 查询所有信息 /// </summary> /// <returns></returns> public static IEnumerable <Beonduty> Query() { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.Beonduty.ToList()); } }
/// <summary> /// 查询所有信息View_Menu_ControlRole /// </summary> /// <returns></returns> public static IEnumerable <View_Menu_ControlRole> QueryView_Menu_ControlRole() { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.View_Menu_ControlRole.ToList()); } }
/// <summary> /// 查询单条 返回实体 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="fun"></param> /// <returns></returns> public static Beonduty Single(Expression <Func <Beonduty, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.Beonduty.SingleOrDefault(fun)); } }
private void BindState() { Expression <Func <ClientInfo, bool> > expr = n => n.Client_Dictionary_ID == 2; cmbClient.DataSource = ClientDAL.Query(expr); this.cmbClient.DisplayMember = "Client_NAME"; cmbClient.ValueMember = "Client_ID"; if (cmbClient.DataSource != null) { cmbClient.SelectedIndex = 0; } DCQUALITYDataContext dc = new DCQUALITYDataContext(); List <ClientInfo> client = new List <ClientInfo>(); client = (from c in dc.ClientInfo where c.Client_Dictionary_ID == 2 select c).ToList(); //Expression<Func<ClientInfo, bool>> exp = n => n.Client_Dictionary_ID == 2; //var client = ClientDAL.Query(exp); ClientInfo dic = new ClientInfo(); dic.Client_ID = 0; dic.Client_NAME = "全部"; client.Insert(0, dic); cmbSClient.DataSource = client; this.cmbSClient.DisplayMember = "Client_NAME"; cmbSClient.ValueMember = "Client_ID"; if (cmbSClient.DataSource != null) { cmbSClient.SelectedIndex = 0; } }
/// <summary> /// 查询所有信息 /// </summary> /// <returns></returns> public static IEnumerable <WaterTestConfigureSet> Query() { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.WaterTestConfigureSet.ToList()); } }
/// <summary> /// 查询所有信息 /// </summary> /// <returns></returns> public static IEnumerable <LogInfo> Query() { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.LogInfo.ToList()); } }
/// <summary> /// summary> /// 按条件查询信息WaterTestConfigureSet /// </summary> /// <returns></returns> public static IEnumerable <WaterTestConfigureSet> Query(Expression <Func <WaterTestConfigureSet, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.WaterTestConfigureSet.Where(fun).ToList()); } }
/// <summary> /// 查询所有信息View_LogInfo_Dictionary /// </summary> /// <returns></returns> public static IEnumerable <View_LogInfo_Dictionary> QueryView_LogInfo_Dictionary() { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.View_LogInfo_Dictionary.ToList()); } }
/// <summary> /// summary> /// 按条件查询信息View_Beonduty_D_Q /// </summary> /// <returns></returns> public static IEnumerable <View_Beonduty_D_Q> Query(Expression <Func <View_Beonduty_D_Q, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.View_Beonduty_D_Q.Where(fun).ToList()); } }
/// <summary> /// 查询单条 返回实体 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="fun"></param> /// <returns></returns> public static LogInfo Single(Expression <Func <LogInfo, bool> > fun) { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.LogInfo.SingleOrDefault(fun)); } }
/// <summary> /// 查询所有信息 /// </summary> /// <returns></returns> public static IEnumerable <SmsSend> Query() { using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { return(db.SmsSend.ToList()); } }