public EntityClassPropertyInfo(DataRow drColumn,codeLanguage codeLanguage)
{
//列名及转换后的属性名
this.ColumnName = drColumn["name"].ToString();
this.PropertyName = ConvertHelper.SplitAndToFirstUpper(this.ColumnName,'_');
//列数据类型及转换成系统的数据类型
this.ColumnDataType = drColumn["DataType"].ToString();
this.PropertyType = ConvertHelper.SqlserverTypeToSys(this.ColumnDataType,codeLanguage);
this.AutoIncrement = drColumn["AutoIncrement"].ToString();
this.IsPk = drColumn["IsPk"].ToString();
this.MaxLength = Convert.ToInt16(drColumn["MaxLength"].ToString());
this.CanNull = drColumn["CanNull"].ToString()=="是" ? "true" :"false";
this.DefaultValue = drColumn["DefaultValue"].ToString();
this.ColumnLabel = drColumn["Label"].ToString();
if (string.IsNullOrEmpty(this.ColumnLabel))
this.ColumnLabel = this.PropertyName;
}
public EntityClassPropertyInfo(DataRow drColumn, codeLanguage codeLanguage)
{
////列名及转换后的属性名
//this.ColumnName = drColumn["name"].ToString();
//this.PropertyName = ConvertHelper.SplitAndToFirstUpper(this.ColumnName, '_');
////列数据类型及转换成系统的数据类型
//this.ColumnDataType = drColumn["DataType"].ToString();
//this.PropertyType = ConvertHelper.SqlserverTypeToSys(this.ColumnDataType, codeLanguage);
//this.AutoIncrement = drColumn["AutoIncrement"].ToString();
//this.IsPk = drColumn["IsPk"].ToString();
//this.MaxLength = Convert.ToInt16(drColumn["MaxLength"].ToString());
//this.CanNull = drColumn["CanNull"].ToString() == "是" ? "true" : "false";
//this.DefaultValue = drColumn["DefaultValue"].ToString();
//this.ColumnLabel = drColumn["Label"].ToString();
//if (string.IsNullOrEmpty(this.ColumnLabel))
// this.ColumnLabel = this.PropertyName;
this.colCode = drColumn["COL_CODE"].ToString();
this.propertyName = ConvertHelper.SplitAndToFirstUpper(this.colCode, '_');
this.colName = drColumn["COL_NAME"].ToString();
this.colType = drColumn["COL_TYPE"].ToString();
this.propertyType = ConvertHelper.SqlserverTypeToSys(this.colType, codeLanguage);
this.colLength = Convert.ToInt16(drColumn["COL_LENGTH"].ToString());
this.primaryKey = Convert.ToInt16(drColumn["PRIMARY_KEY"].ToString());
this.colPrecision = Convert.ToInt16(drColumn["COL_PRECISION"].ToString());
this.colGrid = Convert.ToInt16(drColumn["LIST_DISPLAY"].ToString());
this.colQuickQuery = Convert.ToInt16(drColumn["QUICK_QUERY"].ToString());
this.colExpertQuery = Convert.ToInt16(drColumn["EXPERT_QUERY"].ToString());
this.canEdit = Convert.ToInt16(drColumn["CAN_EDIT"].ToString());
this.canNull = drColumn["CAN_NULL"].ToString() == "1" ? "true" : "false";;
this.orderIndex = Convert.ToInt16(drColumn["ORDER_INDEX"].ToString());
this.dicCode = drColumn["DIC_CODE"].ToString();
this.colDesc = drColumn["COL_DESC"].ToString();
this.tableName = drColumn["TABLE_NAME"].ToString();
this.inputType = drColumn["INPUT_TYPE"].ToString();
}
private void checkLanguage(codeLanguage lang)
{
menuItemVB.Checked = false;
menuItemCSharp.Checked = false;
string btnLanguageText = string.Empty;
if (lang == codeLanguage.vb)
{
menuItemVB.Checked = true;
btnLanguageText = menuItemVB.Text;
}
if (lang == codeLanguage.csharp)
{
menuItemCSharp.Checked = true;
btnLanguageText = menuItemCSharp.Text;
}
btnLanguage.Text = btnLanguageText;
languageIsVB = lang == codeLanguage.vb;
//clear
listBox1.Items.Clear();
btnRecord.Checked = false;
btnRecord.PerformClick();
}
private void checkLanguage(codeLanguage lang)
{
menuItemVB.Checked = false;
menuItemCSharp.Checked = false;
string btnLanguageText = string.Empty;
if (lang == codeLanguage.vb)
{
menuItemVB.Checked = true;
btnLanguageText = menuItemVB.Text;
}
if (lang == codeLanguage.csharp)
{
menuItemCSharp.Checked = true;
btnLanguageText = menuItemCSharp.Text;
}
btnLanguage.Text = btnLanguageText;
languageIsVB = lang == codeLanguage.vb;
//clear
listBox1.Items.Clear();
btnRecord.Checked = false;
btnRecord.PerformClick();
}
/// <summary>
/// 将转入的数据的类型转换成系统类型
/// </summary>
/// <param name="sqlType">数据库对应的字段类型</param>
/// <param name="language">要转换的语言(C#、Java)</param>
/// <returns></returns>
public static string SqlserverTypeToSys(string sqlType, codeLanguage codeLanguage)
{
string sysType = "string";
if (codeLanguage == codeLanguage.Java)
{
sysType = "String";
}
switch (sqlType.ToLower())
{
case "bigint":
sysType = "Long";
break;
case "smallint":
sysType = "Short";
break;
case "int":
sysType = "Integer";
break;
case "uniqueidentifier":
sysType = "String";
break;
case "smalldatetime":
sysType = "Date";
break;
case "datetime":
sysType = "Date";
break;
case "date":
sysType = "Date";
break;
case "float":
sysType = "Double";
break;
case "real":
case "numeric":
sysType = "BigDecimal";
break;
case "smallmoney":
sysType = "BigDecimal";
break;
case "decimal":
sysType = "BigDecimal";
break;
case "money":
sysType = "BigDecimal";
break;
case "tinyint":
sysType = "Integer";
break;
case "bit":
sysType = "Boolean";
break;
case "image":
sysType = "byte[]";
break;
case "binary":
sysType = "byte[]";
break;
case "varbinary":
sysType = "byte[]";
break;
case "timestamp":
sysType = "byte[]";
break;
}
return(sysType);
}
