/// <summary> /// 按条件删除多条数据 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="dc"></param> /// <param name="tentitys"></param> /// <param name="fun"></param> public static bool DeleteToMany(Expression <Func <LogInfo, bool> > fun) { bool rbool = true; try { LinQBaseDao.DeleteToMany <LogInfo>(new DCQUALITYDataContext(), fun); } 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 <WaterTestConfigureSet, bool> > fun) { bool rbool = true; try { LinQBaseDao.DeleteToMany <WaterTestConfigureSet>(new DCQUALITYDataContext(), fun); } 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 <MATERIAL_QC_INTERFACE, bool> > fun) { bool rbool = true; try { LinQBaseDao.DeleteToMany <MATERIAL_QC_INTERFACE>(new DCQUALITYDataContext(), fun); } catch { rbool = false; } return(rbool); }
/// <summary> /// 根据质检编号对应的包号 /// </summary> /// <param name="iqcinfoID">质检编号</param> /// <returns>QCInfo</returns> public static List <string> GetBags(int iqcinfoID) { List <string> list = new List <string>(); try { string sql = "select DRAW_ONE,DRAW_TWO,DRAW_THREE,DRAW_FOUR,DRAW_FIVE,DRAW_SIX,DRAW_7,DRAW_8,DRAW_9,DRAW_10,DRAW_11,DRAW_12,DRAW_13,DRAW_14 from dbo.DRAW_EXAM_INTERFACE where DRAW_EXAM_INTERFACE_ID in(select QCInfo_DRAW_EXAM_INTERFACE_ID from QCInfo where QCInfo_ID='" + iqcinfoID + "')"; string ziduan = "DRAW_ONE,DRAW_TWO,DRAW_THREE,DRAW_FOUR,DRAW_FIVE,DRAW_SIX,DRAW_7,DRAW_8,DRAW_9,DRAW_10,DRAW_11,DRAW_12,DRAW_13,DRAW_14"; DataTable dtprt = LinQBaseDao.Query(sql).Tables[0]; string[] danziduan = ziduan.Split(','); for (int j = 0; j < danziduan.Length; j++) { if (hbbh(dtprt, danziduan[j]) != "") { list.Add(hbbh(dtprt, danziduan[j])); } } } catch (Exception) { list = null; } return(list); }
//查询视图信息 public static DataSet LEDShow(string sql) { return(LinQBaseDao.Query(sql)); }