public static bool CreateTable(bool bAutoInc, string sSqlConn, string sTableName, string[] sFieldName, string[] sDataType, int[] iMaxLen, string[] sAllowNull)
{
bool bRet = true;
try
{
string strSql = "Select * From sysobjects Where Type = 'U' and Name = '" + sTableName + "'";
if (IsTblExist(sSqlConn, strSql) == false)
{
string sqlCreateTbl = "Create Table " + sTableName + "(";
if (bAutoInc == true)
{
sqlCreateTbl += "ID INT PRIMARY KEY IDENTITY(1,1),";
}
for (int k = 0; k < sFieldName.Length; k++)
{
sqlCreateTbl += sFieldName[k] + " "; //字段名
sqlCreateTbl += sDataType[k]; //数据类型
if (iMaxLen[k] > 0)
{
sqlCreateTbl += "(" + iMaxLen[k].ToString() + ")";
}
sqlCreateTbl += " ";
if (k == 0 && bAutoInc == false)
{
sqlCreateTbl += "Primary Key"; //规定第一个为主键
}
else
{
sqlCreateTbl += sAllowNull[k]; //是否允许为空
}
if (k == sFieldName.Length - 1)
{
sqlCreateTbl += ")";
}
else
{
sqlCreateTbl += ", ";
}
}
TSqlDbClass.ExecuteNonQuerySql(sSqlConn, sqlCreateTbl);
}
}
catch
{
bRet = false;
}
return(bRet);
}
public static bool CreateTableByDateTime(string sSqlConn, string sTableName, string[] sFieldName, string[] sDataType, int[] iMaxLen, string[] sAllowNull)
{
bool bRet = true;
try
{
string strSql = "Select * From sysobjects Where Type = 'U' and Name = '" + sTableName + "'";
if (IsTblExist(sSqlConn, strSql) == false)
{
string sqlCreateTbl = "Create Table " + sTableName + "(ID_DateTime Varchar(32) Primary Key,";
for (int k = 0; k < sFieldName.Length; k++)
{
sqlCreateTbl += sFieldName[k] + " "; //字段名
sqlCreateTbl += sDataType[k]; //数据类型
if (iMaxLen[k] > 0)
{
sqlCreateTbl += "(" + iMaxLen[k].ToString() + ")";
}
sqlCreateTbl += " ";
sqlCreateTbl += sAllowNull[k]; //是否允许为空
if (k == sFieldName.Length - 1)
{
sqlCreateTbl += ")";
}
else
{
sqlCreateTbl += ", ";
}
}
TSqlDbClass.ExecuteNonQuerySql(sSqlConn, sqlCreateTbl);
}
//else //Drop Table TblName
}
catch
{
bRet = false;
}
return(bRet);
}
