Beispiel #1
0
        /// <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);
        }
Beispiel #3
0
        /// <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);
        }
Beispiel #5
0
 //查询视图信息
 public static DataSet LEDShow(string sql)
 {
     return(LinQBaseDao.Query(sql));
 }