public List <ColumnInfo> GetColumnInfoListSP(string DbName, string TableName)
{
SqlParameter[] parameters =
{
new SqlParameter("@table_name", SqlDbType.NVarChar, 384),
new SqlParameter("@table_owner", SqlDbType.NVarChar, 384),
new SqlParameter("@table_qualifier", SqlDbType.NVarChar, 384),
new SqlParameter("@column_name", SqlDbType.VarChar, 100)
};
parameters[0].Value = TableName;
parameters[1].Value = null;
parameters[2].Value = null;
parameters[3].Value = null;
DataSet ds = RunProcedure(DbName, "sp_columns", parameters, "ds");
int n = ds.Tables.Count;
if (n > 0)
{
DataTable dt = ds.Tables[0];
int r = dt.Rows.Count;
DataTable dtkey = CreateColumnTable();
for (int m = 0; m < r; m++)
{
DataRow nrow = dtkey.NewRow();
nrow["colorder"] = dt.Rows[m]["ORDINAL_POSITION"];
nrow["ColumnName"] = dt.Rows[m]["COLUMN_NAME"];
string tn = dt.Rows[m]["TYPE_NAME"].ToString().Trim();
nrow["TypeName"] = (tn == "int identity") ? "int" : tn;
nrow["Length"] = dt.Rows[m]["LENGTH"];
nrow["Preci"] = dt.Rows[m]["PRECISION"];
nrow["Scale"] = dt.Rows[m]["SCALE"];
nrow["IsIdentity"] = (tn == "int identity") ? "√" : "";
nrow["isPK"] = "";
nrow["IsNull"] = (dt.Rows[m]["NULLABLE"].ToString().Trim() == "1") ? "√" : "";
nrow["defaultVal"] = dt.Rows[m]["COLUMN_DEF"];
nrow["deText"] = dt.Rows[m]["REMARKS"];
dtkey.Rows.Add(nrow);
}
return(CodeCommon.GetColumnInfos(dtkey));
}
else
{
return(null);
}
}
public List <ColumnInfo> GetColumnInfoListSP(string DbName, string TableName)
{
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@table_name", SqlDbType.NVarChar, 384),
new SqlParameter("@table_owner", SqlDbType.NVarChar, 384),
new SqlParameter("@table_qualifier", SqlDbType.NVarChar, 384),
new SqlParameter("@column_name", SqlDbType.VarChar, 100)
};
array[0].Value = TableName;
array[1].Value = null;
array[2].Value = null;
array[3].Value = null;
DataSet dataSet = this.RunProcedure(DbName, "sp_columns", array, "ds");
int count = dataSet.Tables.Count;
if (count > 0)
{
DataTable dataTable = dataSet.Tables[0];
int count2 = dataTable.Rows.Count;
DataTable dataTable2 = this.CreateColumnTable();
for (int i = 0; i < count2; i++)
{
DataRow dataRow = dataTable2.NewRow();
dataRow["colorder"] = dataTable.Rows[i]["ORDINAL_POSITION"];
dataRow["ColumnName"] = dataTable.Rows[i]["COLUMN_NAME"];
string text = dataTable.Rows[i]["TYPE_NAME"].ToString().Trim();
dataRow["TypeName"] = ((text == "int identity") ? "int" : text);
dataRow["Length"] = dataTable.Rows[i]["LENGTH"];
dataRow["Preci"] = dataTable.Rows[i]["PRECISION"];
dataRow["Scale"] = dataTable.Rows[i]["SCALE"];
dataRow["IsIdentity"] = ((text == "int identity") ? "√" : "");
dataRow["isPK"] = "";
dataRow["cisNull"] = ((dataTable.Rows[i]["NULLABLE"].ToString().Trim() == "1") ? "√" : "");
dataRow["defaultVal"] = dataTable.Rows[i]["COLUMN_DEF"].ToString().Replace("(", "").Replace(")", "");
dataRow["deText"] = dataTable.Rows[i]["REMARKS"];
dataTable2.Rows.Add(dataRow);
}
return(CodeCommon.GetColumnInfos(dataTable2));
}
return(null);
}
public string GetPROCCode(string dbname, string tablename)
{
this.dbobj.DbConnectStr = this._dbconnectStr;
this.Fieldlist = this.dbobj.GetColumnInfoList(dbname, tablename);
DataTable keyName = this.dbobj.GetKeyName(dbname, tablename);
this.DbName = dbname;
this.TableName = tablename;
this.Keys = CodeCommon.GetColumnInfos(keyName);
foreach (ColumnInfo current in this.Keys)
{
this._key = current.ColumnName;
this._keyType = current.TypeName;
if (current.IsIdentity)
{
this._key = current.ColumnName;
this._keyType = CodeCommon.DbTypeToCS(current.TypeName);
break;
}
}
return(this.GetPROCCode(true, true, true, true, true, true, true));
}
/// <summary>
/// 得到某个表的存储过程
/// </summary>
/// <param name="dbname">库名</param>
/// <param name="tablename">表名</param>
/// <returns></returns>
public string GetPROCCode(string dbname, string tablename)
{
dbobj.DbConnectStr = _dbconnectStr;
Fieldlist = dbobj.GetColumnInfoList(dbname, tablename);
DataTable dtkey = dbobj.GetKeyName(dbname, tablename);
DbName = dbname;
TableName = tablename;
//Fieldlist = CodeCommon.GetColumnInfos(dt);
Keys = CodeCommon.GetColumnInfos(dtkey);
foreach (ColumnInfo key in Keys)
{
_key = key.ColumnName;
_keyType = key.TypeName;
if (key.IsIdentity)
{
_key = key.ColumnName;
_keyType = CodeCommon.DbTypeToCS(key.TypeName);
break;
}
}
return(GetPROCCode(true, true, true, true, true, true, true));
}