public static void GetDataAndExecute(string tableName, int bigCount, string condition, ExecuteWithDataTable exec)
{
int maxCountEach = 100;
int totalCount = 0;
int remainCount;
do
{
remainCount = bigCount - totalCount;
int topCount = Math.Min(maxCountEach, remainCount);
DataTable dt = TableDAL.GetTopTable(topCount, tableName, condition);
if (dt != null && 0 < dt.Rows.Count)
{
if (null != exec)
{
exec(dt);
}
totalCount += topCount;
remainCount = bigCount - totalCount;
}
else
{
remainCount = 0;
}
}while (remainCount > 0);
}
public static DataRow GetNewNullRow(string tableName)
{
DataTable dtNew = TableDAL.GetNullValueTable(tableName);
DataRow dr = dtNew.NewRow();
dtNew.Rows.Add(dr);
return(dr);
}
public static int GetTableCount(SqlConnection connection, string tableName, string condition)
{
int count = 0;
DataTable dt = TableDAL.GetTable(connection, tableName, condition);
if (null != dt & 0 < dt.Rows.Count)
{
count = dt.Rows.Count;
}
return(count);
}
public static int InsertOneRowDataTable(DataTable table, string tableName)
{
int id = 0;
DataTable tableSchema = TableDAL.GetTableSchema(tableName);
if (string.IsNullOrEmpty(tableSchema.TableName))
{
}
string strSql = " insert into {0}({1}) values({2}); select @@identity";
StringBuilder insertFieldSqlExp = new StringBuilder();
StringBuilder insertValueSqlExp = new StringBuilder();
foreach (DataColumn insertColumn in tableSchema.Columns)
{
if (!insertColumn.AutoIncrement)
{
insertFieldSqlExp.Append(insertColumn.ColumnName + ", ");
insertValueSqlExp.Append("@" + insertColumn.ColumnName + ", ");
}
}
string strInserFieldSqlExp = insertFieldSqlExp.ToString().TrimEnd(new char[]
{
',',
' '
});
string strInsertValueSqlExp = insertValueSqlExp.ToString().TrimEnd(new char[]
{
',',
' '
});
strSql = string.Format(strSql, tableSchema.TableName, strInserFieldSqlExp, strInsertValueSqlExp);
List <SqlParameter> parameters = new List <SqlParameter>();
if (table != null && 0 < table.Rows.Count)
{
DataRow dataRow = table.Rows[0];
foreach (DataColumn schemaColumn in tableSchema.Columns)
{
SqlParameter dbParam = new SqlParameter("@" + schemaColumn.ColumnName, dataRow[schemaColumn.ColumnName]);
parameters.Add(dbParam);
}
}
try
{
id = Convert.ToInt32(SqlHelper.ExecuteScalar(TableDAL.DefaultConnectionString, CommandType.Text, strSql, parameters.ToArray()));
}
catch
{
}
return(id);
}
public static DataTable GetTopTable(int topCount, string tableName, string condition)
{
SqlConnection cn = new SqlConnection(TableDAL.DefaultConnectionString);
return(TableDAL.GetTable(tableName, condition, " top " + topCount + " * "));
}
public static DataTable GetNullValueTable(string tableName)
{
return(TableDAL.GetNullValueTable(TableDAL.DefaultConnectionString, tableName));
}
public static int UpdateDataTable(DataTable tableToUpdate, DataTable schema)
{
return(TableDAL.UpdateDataTable(TableDAL.DefaultConnectionString, tableToUpdate, schema));
}
public static int SaveTable(DataTable table, string tableName)
{
return(TableDAL.UpdateDataTable(table, TableDAL.GetTableSchema(tableName)));
}
public static int InsertDataTable(string connectionString, DataTable tableToInsert, DataTable tableSchema)
{
DataTable schema = TableDAL.GetTableInsertSchema(tableSchema.Copy());
return(TableDAL.Insert(connectionString, tableToInsert, tableSchema));
}
public static int InsertDataTable(DataTable tableToInsert, DataTable tableSchema)
{
return(TableDAL.InsertDataTable(TableDAL.DefaultConnectionString, tableToInsert, tableSchema));
}
public static int InsertDataTable(DataTable tableToInsert, string tableName)
{
return(TableDAL.InsertDataTable(tableToInsert, TableDAL.GetTableSchema(tableName)));
}
public static DataTable GetTableSchema(string tableName)
{
return(TableDAL.GetTableSchema(TableDAL.DefaultConnectionString, tableName));
}
public static int GetTableCount(string tableName, string condition)
{
SqlConnection cn = new SqlConnection(TableDAL.DefaultConnectionString);
return(TableDAL.GetTableCount(cn, tableName, condition));
}
public static DataTable GetTable(SqlConnection connection, string tableName, string condition)
{
return(TableDAL.GetTable(connection, tableName, condition, ""));
}
public static DataTable GetTable(string tableName, string condition, string fieldList)
{
SqlConnection cn = new SqlConnection(TableDAL.DefaultConnectionString);
return(TableDAL.GetTable(cn, tableName, condition, fieldList));
}
