/// <summary>
/// 得到方法输入参数的列表 (例如：用于Exists Delete GetModel 的参数传入)
/// </summary>
/// <param name="keys"></param>
/// <returns></returns>
public static string GetInParameter(List <ColumnInfo> keys)
{
StringPlus strclass = new StringPlus();
foreach (ColumnInfo key in keys)
{
strclass.Append(CodeCommon.DbTypeToCS(key.TypeName) + " " + key.ColumnName + ",");
}
strclass.DelLastComma();
return(strclass.Value);
}
/// <summary>
/// 得到参数的列表(例如：用于Exists Delete GetModel 的参数传入)
/// </summary>
/// <param name="keys"></param>
/// <returns></returns>
public static string GetParameter(List <CodeKey> keys)
{
StringPlus strclass = new StringPlus();
foreach (CodeKey key in keys)
{
strclass.Append(CodeCommon.DbTypeToCS(key.KeyType) + " " + key.KeyName + ",");
}
strclass.DelLastComma();
return(strclass.Value);
}
/// <summary>
/// 得到Where条件语句 - SQL方式 (例如：用于Exists Delete GetModel 的where)
/// </summary>
public static string GetModelWhereExpression(List <ColumnInfo> keys)
{
StringPlus strclass = new StringPlus();
foreach (ColumnInfo key in keys)
{
if (CodeCommon.IsAddMark(key.TypeName))
{
strclass.Append(key.ColumnName + "='\"+ model." + key.ColumnName + "+\"' and ");
}
else
{
strclass.Append(key.ColumnName + "=\"+ model." + key.ColumnName + "+\" and ");
}
}
strclass.DelLastChar("and");
return(strclass.Value);
}
private void BindlistViewCol(string Dbname, string TableName)
{
SetListViewMenu("colum");
//创建列表
this.listView1.Columns.Clear();
this.listView1.Items.Clear();
this.listView1.LargeImageList = imglistView;
this.listView1.SmallImageList = imglistView;
this.listView1.View = View.Details;
this.listView1.GridLines = true;
this.listView1.FullRowSelect = true;
listView1.Columns.Add("序号", 60, HorizontalAlignment.Left);
listView1.Columns.Add("列名", 110, HorizontalAlignment.Left);
listView1.Columns.Add("数据类型", 80, HorizontalAlignment.Left);
listView1.Columns.Add("长度", 40, HorizontalAlignment.Left);
listView1.Columns.Add("小数", 40, HorizontalAlignment.Left);
listView1.Columns.Add("标识", 40, HorizontalAlignment.Center);
listView1.Columns.Add("主键", 40, HorizontalAlignment.Center);
listView1.Columns.Add("允许空", 60, HorizontalAlignment.Center);
listView1.Columns.Add("默认值", 100, HorizontalAlignment.Left);
//listView1.Columns.Add("字段说明", 100, HorizontalAlignment.Left);
var collist = dbObject.GetColumnInfoList(Dbname, TableName);
if ((collist != null) && (collist.Count > 0))
{
foreach (var col in collist)
{
var order = col.ColOrder;
var columnName = col.ColumnName;
var columnType = col.TypeName;
var Length = col.Length;
switch (columnType)
{
case "varchar":
case "nvarchar":
case "char":
case "nchar":
case "varbinary":
{
Length = CodeCommon.GetDataTypeLenVal(columnType, Length);
}
break;
default:
break;
}
var Preci = col.Preci;
var Scale = col.Scale;
var defaultVal = col.DefaultVal;
var description = col.ColDescription;
var IsIdentity = (col.IsIdentity) ? "√" : "";
var ispk = (col.IsPK) ? "√" : "";
var isnull = (col.IsNull) ? "√" : "";
var item1 = new ListViewItem(order, 0);
item1.ImageIndex = 4;
item1.SubItems.Add(columnName);
item1.SubItems.Add(columnType);
item1.SubItems.Add(Length);
item1.SubItems.Add(Scale);
item1.SubItems.Add(IsIdentity);
if ((ispk == "√") && (isnull.Trim() == ""))
{
}
else
{
ispk = "";
}
item1.SubItems.Add(ispk);
item1.SubItems.Add(isnull);
item1.SubItems.Add(defaultVal);
listView1.Items.AddRange(new ListViewItem[] { item1 });
}
}
}