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