/// <summary> /// 获取LED设置 /// </summary> /// <param name="sql"></param> /// <returns></returns> public static PositionLED GetLED(string sql) { DataSet dataset = LinQBaseDao.Query(sql); PositionLED pLED = new PositionLED(); foreach (DataRow dr in dataset.Tables[0].Rows) { pLED.PositionLED_Position_ID = int.Parse(dr["PositionLED_Position_Id"].ToString()); pLED.PositionLED_Type = int.Parse(dr["PositionLED_Type"].ToString()); pLED.PositionLED_ID = int.Parse(dr["PositionLED_ID"].ToString()); pLED.PositionLED_ScreenHeight = int.Parse(dr["PositionLED_ScreenHeight"].ToString()); pLED.PositionLED_ScreenWeight = int.Parse(dr["PositionLED_ScreenWeight"].ToString()); pLED.PositionLED_X = int.Parse(dr["PositionLED_X"].ToString()); pLED.PositionLED_Y = int.Parse(dr["PositionLED_Y"].ToString()); //pLED.PositionLED_IntervalX = int.Parse(dr["PositionLED_IntervalX"].ToString()); //pLED.PositionLED_IntervalY = int.Parse(dr["PositionLED_IntervalY"].ToString()); pLED.PositionLED_Count = int.Parse(dr["PositionLED_Count"].ToString()); pLED.PositionLED_Remark = dr["PositionLED_Remark"].ToString(); pLED.PositionLED_Content = dr["PositionLED_Content"].ToString(); //pLED.PositionLED_PassageState = dr["PositionLED_PassageState"].ToString(); pLED.PositionLED_State = dr["PositionLED_State"].ToString(); pLED.PositionLED_Font = dr["PositionLED_Font"].ToString(); pLED.PositionLED_FontSize = dr["PositionLED_FontSize"].ToString(); pLED.PositionLED_Color = dr["PositionLED_Color"].ToString(); pLED.PositionLED_Operate = dr["PositionLED_Operate"].ToString(); pLED.PositionLED_Time = Convert.ToDateTime(dr["PositionLED_Time"].ToString()); } return(pLED); }
/// <summary> /// 查询可以显示的字段 /// </summary> /// <param name="procName">存储过程名称</param> /// <param name="viewName">视图名称</param> /// <returns></returns> public static List <string> GetShow(string procName, string viewName) { List <string> list = new List <string>(); list = LinQBaseDao.GetView(procName, viewName); return(list); }
public static int LEDcount(string sql) { DataSet dscount = new DataSet(); dscount = LinQBaseDao.Query(sql); return(Convert.ToInt32(dscount.Tables[0].Rows[0][0])); }
/// <summary> /// 获取车辆类型 /// </summary> /// <param name="sql"></param> /// <returns></returns> public static List <DeviceControl> GetDeviceControl(string sql) { DataSet dataset = LinQBaseDao.Query(sql); List <DeviceControl> list = new List <DeviceControl>(); if (dataset != null) { if (dataset.Tables.Count > 0) { foreach (DataRow dr in dataset.Tables[0].Rows) { DeviceControl dcl = new DeviceControl(); dcl.DeviceControl_CardNo = dr["DeviceControl_CardNo"].ToString(); dcl.DeviceControl_CardType = dr["DeviceControl_CardType"].ToString(); dcl.DeviceControl_DrivewayAddress = dr["DeviceControl_DrivewayAddress"].ToString(); dcl.DeviceControl_DrivewayValue = dr["DeviceControl_DrivewayValue"].ToString(); dcl.DeviceControl_FanSate = dr["DeviceControl_FanSate"].ToString(); dcl.DeviceControl_FanValue = dr["DeviceControl_FanValue"].ToString(); dcl.DeviceControl_ID = int.Parse(dr["DeviceControl_ID"].ToString()); dcl.DeviceControl_ISCardRelease = Boolean.Parse(dr["DeviceControl_ISCardRelease"].ToString()); dcl.DeviceControl_OutSate = dr["DeviceControl_OutSate"].ToString(); dcl.DeviceControl_PositionValue = dr["DeviceControl_PositionValue"].ToString(); dcl.DeviceControl_ReadValue = dr["DeviceControl_ReadValue"].ToString(); dcl.DeviceControl_Remark = dr["DeviceControl_Remark"].ToString(); list.Add(dcl); } } } return(list); }
/// <summary> /// 查询 /// </summary> /// <param name="sql">查询sql语句</param> /// <returns></returns> public static DataSet GetCarType(string sql) { DataSet dataset = new DataSet(); dataset = LinQBaseDao.Query(sql); return(dataset); }
public static int MaxID(string sql) { try { return(Convert.ToInt32(LinQBaseDao.Query(sql).Tables[0].Rows[0][0])); } catch { return(0); } }
/// <summary> /// 获取服务器时间 /// </summary> /// <returns></returns> public static DateTime GetServersTime() { try { return(DateTime.Parse(LinQBaseDao.Query("select GETDATE()").Tables[0].Rows[0][0].ToString())); } catch { return(DateTime.Parse("1900-01-01 00:00:00.000")); } }
/// <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(); } } }
/// <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> 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 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> /// <typeparam name="T"></typeparam> /// <param name="dc"></param> /// <param name="tentitys"></param> /// <param name="fun"></param> public static bool DeleteToMany(Expression <Func <SmallTicket, bool> > fun) { bool rbool = true; try { LinQBaseDao.DeleteToMany <SmallTicket>(new DCCarManagementDataContext(), fun); } catch { rbool = false; } return(rbool); }
/// <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 <ManagementStrategyRecord, bool> > fun, Action <ManagementStrategyRecord> action) { bool rbool = true; try { LinQBaseDao.Update <ManagementStrategyRecord>(new DCCarManagementDataContext(), fun, action); } catch { rbool = false; } return(rbool); }
/// <summary> /// 按条件删除多条数据 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="dc"></param> /// <param name="tentitys"></param> /// <param name="fun"></param> public static bool DeleteToMany(Expression <Func <ManagementStrategyRecord, bool> > fun) { bool rbool = true; try { LinQBaseDao.DeleteToMany <ManagementStrategyRecord>(new DCCarManagementDataContext(), fun); } catch { rbool = false; } return(rbool); }
/// <summary> /// 删除多条数据 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="dc"></param> /// <param name="tentitys"></param> public static bool DeleteToManyByCondition(IEnumerable <ManagementStrategyRecord> tentitys) { bool rbool = true; try { LinQBaseDao.DeleteToManyByCondition <ManagementStrategyRecord>(new DCCarManagementDataContext(), tentitys); } catch { rbool = false; } return(rbool); }
/// <summary> /// 根据传入的sql进行验证 /// </summary> /// <param name="sql"></param> /// <returns></returns> public static bool ChkPrintState(string sql) { DataSet dataset = new DataSet(); dataset = LinQBaseDao.Query(sql); if (dataset.Tables[0].Rows.Count > 0) { return(true); } else { return(false); } }
/// <summary> /// 获取车辆类型 /// </summary> /// <param name="sql"></param> /// <returns></returns> public static List <CarType> GetCarType(string sql) { DataSet dataset = LinQBaseDao.Query(sql); List <CarType> list = new List <CarType>(); foreach (DataRow dr in dataset.Tables[0].Rows) { CarType cartype = new CarType(); cartype.CarType_ID = int.Parse(dr["CarType_ID"].ToString()); cartype.CarType_Name = dr["CarType_Name"].ToString(); list.Add(cartype); } return(list); }
/// <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 <Blacklist, bool> > fun, Action <Blacklist> action) { bool rbool = true; try { LinQBaseDao.Update <Blacklist>(new DCCarManagementDataContext(), fun, action); } catch { rbool = false; } return(rbool); }
/// <summary> /// 获取设置 /// </summary> /// <param name="sql"></param> /// <returns></returns> public static PrintInfo GetPrint(string sql) { DataSet dataset = LinQBaseDao.Query(sql); PrintInfo pInfo = new PrintInfo(); foreach (DataRow dr in dataset.Tables[0].Rows) { pInfo.Print_CarType_ID = int.Parse(dr["Print_CarType_ID"].ToString()); pInfo.Print_Content = dr["Print_Content"].ToString(); pInfo.Print_ID = int.Parse(dr["Print_ID"].ToString()); pInfo.Print_State = dr["Print_State"].ToString(); } return(pInfo); }
/// <summary> /// 获取语音设置 /// </summary> /// <param name="sql"></param> /// <returns></returns> public static VoiceCalls GetVoice(string sql) { DataSet dataset = LinQBaseDao.Query(sql); VoiceCalls vc = new VoiceCalls(); foreach (DataRow dr in dataset.Tables[0].Rows) { vc.VoiceCalls_ID = int.Parse(dr["VoiceCalls_ID"].ToString()); vc.VoiceCalls_Number = int.Parse(dr["VoiceCalls_Number"].ToString()); vc.VoiceCalls_Content = dr["VoiceCalls_Content"].ToString(); vc.VoiceCalls_PositionName = dr["VoiceCalls_PositionName"].ToString(); vc.VoiceCalls_PositionValue = dr["VoiceCalls_PositionValue"].ToString(); vc.VoiceCalls_Remark = dr["VoiceCalls_Remark"].ToString(); } return(vc); }
/// <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> /// <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> /// <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="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> /// <typeparam name="T"></typeparam> /// <param name="fun"></param> /// <returns></returns> public static MenuType Single(Expression <Func <MenuType, bool> > fun) { using (DCCarManagementDataContext db = new DCCarManagementDataContext()) { try { return(LinQBaseDao.Single <MenuType>(db, fun)); } catch { return(null); } finally { db.Connection.Close(); } } }
/// <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); } }
/// <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); }