Exemple #1
0
 public int RowCountWithEF(string strSql, string[] parameterNames, string[] parameterValues)
 {
     using (SqlBLL service = new SqlBLL())
     {
         return(service.RowCountWithEF(strSql, parameterNames, parameterValues));
     }
 }
Exemple #2
0
 public bool ExecuteSqls(string[] strSqLs)
 {
     using (SqlBLL service = new SqlBLL())
     {
         return(service.ExecuteSqls(strSqLs));
     }
 }
Exemple #3
0
 public DateTime GetDataBaseTime()
 {
     using (SqlBLL service = new SqlBLL())
     {
         return(service.GetDataBaseTime());
     }
 }
Exemple #4
0
 public bool ExecuteSqlByParam(string strSQL, string[] parameterNames, string[] parameterValues)
 {
     using (SqlBLL service = new SqlBLL())
     {
         return(service.ExecuteSql(strSQL, parameterNames, parameterValues));
     }
 }
Exemple #5
0
 public bool ExecuteSql(string strSQL)
 {
     using (SqlBLL service = new SqlBLL())
     {
         return(service.ExecuteSql(strSQL, null, null));
     }
 }
Exemple #6
0
 public DataTable GetDataTable(string strSql, string[] parameterNames, string[] parameterValues)
 {
     using (SqlBLL service = new SqlBLL())
     {
         return(service.GetDataTable(strSql, parameterNames, parameterValues));
     }
 }
Exemple #7
0
 public List <string> GetFirstRow(string strSQL, string[] parameterNames, string[] parameterValues)
 {
     using (SqlBLL service = new SqlBLL())
     {
         return(service.GetFirstRow(strSQL, parameterNames, parameterValues));
     }
 }
Exemple #8
0
 public string GetScalar(string strSql, string[] parameterNames, string[] parameterValues)
 {
     using (SqlBLL service = new SqlBLL())
     {
         return(service.GetScalar(strSql, parameterNames, parameterValues));
     }
 }
Exemple #9
0
 public bool ExecuteSqlWithEF(string strSql, string[] parameterNames, string[] parameterValues)
 {
     using (SqlBLL service = new SqlBLL())
     {
         return(service.ExecuteSqlWithEF(strSql, parameterNames, parameterValues));
     }
 }
Exemple #10
0
 public List <string> GetFirstRowWithEF(string type, string strSql, string[] parameterNames, string[] parameterValues)
 {
     using (SqlBLL service = new SqlBLL())
     {
         Type t = Type.GetType(type);
         return(service.GetFirstRowWithEF(t, strSql, parameterNames, parameterValues));
     }
 }
Exemple #11
0
 public string GetScalarWithEF(string type, string strSql, string[] parameterNames, string[] parameterValues)
 {
     using (SqlBLL service = new SqlBLL())
     {
         Type t = Type.GetType(type);
         return(service.GetScalarWithEF(t, strSql, parameterNames, parameterValues));
     }
 }
Exemple #12
0
        public DataTable GetDataTableWithEF(string type, string strSql, string[] parameterNames, string[] parameterValues)
        {
            using (SqlBLL service = new SqlBLL())
            {
                Type t = Type.GetType(type);
                if (t != null)
                {
                    return(service.GetDataTableWithEF(t, strSql, parameterNames, parameterValues));
                }

                return(new DataTable("GetDataTableWithEF"));
            }
        }