/// <summary> /// 传入SQL 查询 /// </summary> /// <param name="strsql"></param> /// <returns></returns> public static IEnumerable <T> GetItemsForListing <T>(string strsql) where T : class { using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { return(db.ExecuteQuery <T>(strsql).ToList()); } }
public static List <Dictionary> GetValueDictionary(string strValue) { List <Dictionary> list = new List <Dictionary>(); using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { 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 = -1; dic.Dictionary_Name = "全部"; list.Add(dic); } catch { } finally { db.Connection.Close(); } } return(list); }
/// <summary> /// 多项更改 /// 使用SubmitChanges将对检索到的进行的更新保持回数据库 /// </summary> /// <param name="dictionary">Dictionary实体对象</param> /// <returns></returns> public static bool UpdateMore(Dictionary dictionary) { bool rbool = true; try { using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { 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 { rbool = false; } return(rbool); }
/// <summary> /// 连接Linq To Sql 实例 /// </summary> /// <param name="strsql"></param> /// <returns></returns> public static IEnumerable <Camera> GetCameraForListing(string strsql) { DCCarManagementDataContext db = new DCCarManagementDataContext(); var products = db.ExecuteQuery <Camera>(strsql).AsEnumerable(); return(products); }
/// <summary> /// 连接Linq To Sql 实例 /// </summary> /// <param name="strsql"></param> /// <returns></returns> public static IEnumerable <BusinessType> GetFVNForListing(string strsql) { DCCarManagementDataContext db = new DCCarManagementDataContext(); var products = db.ExecuteQuery <BusinessType>(strsql).AsEnumerable(); return(products); }
/// <summary> /// 根据字典名称获取字典编号 /// </summary> /// <param name="strName">字典值</param> /// <returns></returns> public static int GetDictionaryID1(string strName) { int rint = 0; using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { rint = db.Dictionary.First(d => (d.Dictionary_Name == strName && d.Dictionary_State == true)).Dictionary_ID; } return(rint); }
public static string GetOtherID(string OtherID) { string other = ""; using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { other = db.Dictionary.First(d => (d.Dictionary_ID == int.Parse(OtherID))).Dictionary_Name; } return(other); }
/// <summary> /// Linq根据条件删除数据 /// </summary> /// <param name="fun"></param> public static void DeletePositionLED(Expression <Func <PositionLED, bool> > fun) { using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { try { LinQBaseDao.DeleteToMany <PositionLED>(db, fun); } finally { db.Connection.Close(); } } }
/// <summary> /// Linq的更新方法 /// </summary> /// <param name="fun">条件</param> /// <param name="action">修改的参数</param> public static void UpdateVoiceCalls(Expression <Func <VoiceCalls, bool> > fun, Action <VoiceCalls> action) { using (DCCarManagementDataContext dc = new DCCarManagementDataContext()) { try { LinQBaseDao.Update <VoiceCalls>(dc, fun, action); } finally { dc.Connection.Close(); } } }
public static List <Dictionary> GetListDictionary() { List <Dictionary> list = new List <Dictionary>(); using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { Table <Dictionary> ti = db.GetTable <Dictionary>(); var objTable = from a in ti select a; list = objTable.ToList <Dictionary>(); } return(list); }
/// <summary> /// Linq根据条件删除数据 /// </summary> /// <param name="fun"></param> public static void DeletePrintInfo(Expression <Func <PrintInfo, bool> > fun) { using (DCCarManagementDataContext dc = new DCCarManagementDataContext()) { try { LinQBaseDao.DeleteToMany <PrintInfo>(dc, fun); } finally { dc.Connection.Close(); } } }
/// <summary> /// Linq的更新方法 /// </summary> /// <param name="fun">条件</param> /// <param name="action">修改的参数</param> public static void UpdatePrint(Expression <Func <PrintInfo, bool> > fun, Action <PrintInfo> action) { using (DCCarManagementDataContext dc = new DCCarManagementDataContext()) { try { LinQBaseDao.Update <PrintInfo>(dc, fun, action); } finally { dc.Connection.Close(); } } }
/// <summary> /// Linq的更新方法 /// </summary> /// <param name="fun">条件</param> /// <param name="action">修改的参数</param> public static void UpdateDevice(Expression <Func <DeviceControl, bool> > fun, Action <DeviceControl> action) { using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { try { LinQBaseDao.Update <DeviceControl>(db, fun, action); } finally { db.Connection.Close(); } } }
/// <summary> /// 是否所属项(是否有下级) /// </summary> /// <returns></returns> public static List <Dictionary> GetStateDictionaryOther() { List <Dictionary> list = new List <Dictionary>(); using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { Table <Dictionary> ti = db.GetTable <Dictionary>(); var objTable = from c in ti where c.Dictionary_OtherID == 0 && c.Dictionary_ISLower == true select c; list = objTable.ToList <Dictionary>(); } return(list); }
/// <summary> /// 根据菜单ID返回菜单名称 /// </summary> /// <param name="strValue">菜单ID</param> /// <returns></returns> public static string GetValueState(int MenuID) { using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { try { return(db.MenuInfo.First(d => (d.Menu_ID == MenuID)).Menu_ControlText); } catch { return(""); } finally { db.Connection.Close(); } } }
/// <summary> /// 字典状态名称 /// </summary> /// <returns></returns> public static List <Dictionary> GetStateDictionaryName() { List <Dictionary> list = new List <Dictionary>(); using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { Table <Dictionary> ti = db.GetTable <Dictionary>(); var objTable = from c in ti //where c.Dictionary_State == true && c.Dictionary_ISLower == true select c; //select new { c.Dictionary_ID, c.Dictionary_Value }; list = objTable.ToList <Dictionary>(); } return(list); }
/// <summary> /// 根据菜单名称 返回菜单ID /// </summary> /// <param name="strValue">菜单名称</param> /// <returns></returns> public static int GetMenuID(string strValue) { using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { try { return(db.MenuInfo.First(d => (d.Menu_ControlText == strValue)).Menu_ID); } catch { return(0); } finally { db.Connection.Close(); } } }
/// <summary> /// 添加一条记录 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="dc"></param> /// <param name="tentity"></param> public static bool InsertOne <T>(DCCarManagementDataContext dc, T tentity) where T : class { bool rbool = true; try { var table = dc.GetTable <T>(); table.InsertOnSubmit(tentity); dc.SubmitChanges(); } catch { rbool = false; } return(rbool); }
/// <summary> /// 执行多操作 /// </summary> /// <typeparam name="T">实体</typeparam> /// <param name="dc"></param> /// <param name="intindex">0:添加操作 1:修改操作 2:删除操作 3:添加多条记录 4:删除多条记录</param> /// <param name="tentity">要添加的实体</param> /// <param name="fun">修改或删除的条件</param> /// <param name="action">修改的值</param> /// <param name="rbool">ture:执行操作 FALSE:不执行</param> /// <param name="tentitys">要添加或都要删除的实体集合</param> /// <returns></returns> public static bool ADD_Delete_UpdateMethod <T>(DCCarManagementDataContext dc, int intindex, T tentity, Expression <Func <T, bool> > fun, Action <T> action, bool rbool, IEnumerable <T> tentitys) where T : class { bool falg = true; if (intindex == 0)//添加 { var table = dc.GetTable <T>(); table.InsertOnSubmit(tentity); } if (intindex == 3)//添加多条记录 { var table = dc.GetTable <T>(); table.InsertAllOnSubmit(tentitys); } if (intindex == 1)//修改 { var table = dc.GetTable <T>().Single <T>(fun); action(table); } if (intindex == 2)//删除 { var table = dc.GetTable <T>(); var result = table.Where <T>(fun).AsEnumerable <T>(); table.DeleteAllOnSubmit <T>(result); } if (intindex == 4)//删除多条记录 { var table = dc.GetTable <T>(); table.InsertAllOnSubmit(tentitys); } if (rbool) { try { dc.SubmitChanges(); } catch (ChangeConflictException err) { dc.ChangeConflicts.ResolveAll(RefreshMode.KeepCurrentValues); dc.SubmitChanges(); falg = false; } } return(falg); }
/// <summary> /// 添加多条记录 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="dc"></param> /// <param name="tentitys"></param> public static bool InsertToMany(IEnumerable <ManagementStrategyRecord> tentitys) { bool rbool = true; using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { try { LinQBaseDao.InsertToMany(db, tentitys); } catch { rbool = false; } finally { db.Connection.Close(); } } return(rbool); }
/// <summary> /// 新增一条记录 /// </summary> /// <param name="qcRecord">质检实体</param> /// <returns></returns> public static bool InsertOneQCRecord(ManagementStrategyRecord qcRecord) { bool rbool = true; using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { try { rbool = LinQBaseDao.InsertOne(db, qcRecord); } catch { rbool = false; } finally { db.Connection.Close(); } } return(rbool); }
/// <summary> /// 添加 /// </summary> /// <param name="pr">实体</param> /// <returns>返回执行结果 true or false</returns> public static bool InsertPrint(PrintRecord pr) { bool rbool = false; using (DCCarManagementDataContext dc = new DCCarManagementDataContext()) { try { rbool = LinQBaseDao.InsertOne <PrintRecord>(dc, pr); } catch { rbool = false; } finally { dc.Connection.Close(); } } return(rbool); }
/// <summary> /// 新增一条质检记录 /// </summary> /// <param name="qcRecord">质检实体</param> /// <returns></returns> public static bool InsertOneCamera(Camera eh_Fvn) { bool rbool = true; using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { try { rbool = LinQBaseDao.InsertOne(db, eh_Fvn); } catch { rbool = false; } finally { db.Connection.Close(); } } return(rbool); }
/// <summary> /// 添加一条数据 /// </summary> /// <param name="pLED">LED实体</param> /// <returns>返回执行结果 true or false</returns> public static bool InsertPositionVoice(PositionVoice pv) { bool rbool = false; using (DCCarManagementDataContext dc = new DCCarManagementDataContext()) { try { rbool = LinQBaseDao.InsertOne <PositionVoice>(dc, pv); } catch { rbool = false; } finally { dc.Connection.Close(); } } return(rbool); }
/// <summary> /// 查询单条 返回实体 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="fun"></param> /// <returns></returns> public static Camera Single(Expression <Func <Camera, bool> > fun) { using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { try { return(LinQBaseDao.Single <Camera>(db, fun)); } catch { return(null); } finally { db.Connection.Close(); } } }
/// <summary> /// 按条件删除多条数据 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="dc"></param> /// <param name="tentitys"></param> /// <param name="fun"></param> public static bool DeleteToMany(Expression <Func <Dictionary, bool> > fun) { bool rbool = true; using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { try { LinQBaseDao.DeleteToMany <Dictionary>(new DCCarManagementDataContext(), fun); } catch { rbool = false; } finally { db.Connection.Close(); } } return(rbool); }
/// <summary> /// 添加一条数据 /// </summary> /// <param name="pLED">LED实体</param> /// <returns>返回执行结果 true or false</returns> public static bool InsertVoiceCalls(VoiceCalls vc) { bool rbool = false; using (DCCarManagementDataContext dc = new DCCarManagementDataContext()) { try { rbool = LinQBaseDao.InsertOne <VoiceCalls>(dc, vc); } catch { rbool = false; } finally { dc.Connection.Close(); } } return(rbool); }
/// <summary> /// 新增一条记录 /// </summary> /// <param name="qcRecord">质检实体</param> /// <returns></returns> public static bool InsertOneDevice(DeviceControl dcl) { bool rbool = true; using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { try { rbool = LinQBaseDao.InsertOne(db, dcl); } catch { rbool = false; } finally { db.Connection.Close(); } } return(rbool); }
/// <summary> /// 新增一条记录 /// </summary> /// <param name="qcRecord">实体</param> /// <returns></returns> public static bool InsertOneLogInfo(LogInfo loginfo) { bool rbool = true; using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { try { rbool = LinQBaseDao.InsertOne(db, loginfo); } catch { rbool = false; } finally { db.Connection.Close(); } } return(rbool); }
public static bool DeleteMenuinfo(Expression <Func <MenuType, bool> > fun) { bool rbool = true; using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { try { LinQBaseDao.DeleteToMany <MenuType>(db, fun); } catch { rbool = false; } finally { db.Connection.Close(); } return(rbool); } }