Esempio n. 1
0
        /// <summary>
        /// 查询语句
        /// </summary>
        /// <param name="p_Sql"></param>
        /// <returns></returns>
        private DataTable PicFill(string p_Sql)
        {
            DataTable dt = new DataTable();

            switch (UCDBConnIndex)
            {
            case 1:
                dt = SysUtils.Fill(p_Sql);
                break;

            case 2:
                dt = SysUtilsSecond.Fill(p_Sql);
                break;

            case 3:
                dt = SysUtilsThird.Fill(p_Sql);
                break;

            case 4:
                dt = SysUtilsFourth.Fill(p_Sql);
                break;
            }

            return(dt);
        }
Esempio n. 2
0
        /// <summary>
        /// 执行SQL语句
        /// </summary>
        /// <param name="p_Sql"></param>
        /// <param name="obj"></param>
        private void PicExecuteNonQuery(string p_Sql, object[,] obj)
        {
            switch (UCDBConnIndex)
            {
            case 1:
                SysUtils.ExecuteNonQuery(p_Sql, obj);
                break;

            case 2:
                SysUtilsSecond.ExecuteNonQuery(p_Sql, obj);
                break;

            case 3:
                SysUtilsThird.ExecuteNonQuery(p_Sql, obj);
                break;

            case 4:
                SysUtilsFourth.ExecuteNonQuery(p_Sql, obj);
                break;
            }
        }