110,538
社区成员
发帖
与我相关
我的任务
分享
string tableName = TextBox1.Text;
string query = "select top 1 * from " + tableName;
DataTable table = BookDAL.SqlHelper.ExecuteDataTable(BookDAL.SqlHelper.GetConnSting(), CommandType.Text, query);
string data = "";
foreach (DataColumn col in table.Columns)
{
string colName = col.ColumnName;
string colNameUpper = colName.ToUpper();
Type colType = col.DataType;
string colTypeName = colType.Name;
#region===String===
if (colTypeName == "String")
{
data = @"///<summary>
/// " + colName + "-" + colTypeName + @"
/// </summary>
public string " + colName + @" { get; set; }
";
}
#endregion
#region===DateTime===
else if (colTypeName == "DateTime")
{
data = @"///<summary>
/// " + colName + "-" + colTypeName + @"
/// </summary>
public DateTime? " + colName + @" { get; set; }
";
}
#endregion
#region===Double===
else if (colTypeName == "Double")
{
data = @"///<summary>
/// " + colName + "-" + colTypeName + @"
/// </summary>
public Double " + colName + @" { get; set; }
";
}
#endregion
#region===Int32===
else if (colTypeName == "Int32")
{
data = @"///<summary>
/// " + colName + "-" + colTypeName + @"
/// </summary>
public int " + colName + @" { get; set; }
";
}
#endregion
#region===Boolean===
else if (colTypeName == "Boolean")
{
data = @"///<summary>
/// " + colName + "-" + colTypeName + @"
/// </summary>
public Boolean " + colName + @" { get; set; }
";
}
#endregion
#region===Decimal===
else if (colTypeName == "Decimal")
{
data = @"///<summary>
/// " + colName + "-" + colTypeName + @"
/// </summary>
public Double " + colName + @" { get; set; }
";
}
#endregion
#region===其它===
else
{
data = @"///<summary>
/// " + colName + "-" + colTypeName + @"
/// </summary>
public string " + colNameUpper + @" { get; set; }
";
}