private static string ParamCreate(AzMetaCloumEntity azMetaCloum, AzClassCreatProperty classCreatProperty)
{
StringBuilder stringBuilder = new StringBuilder();
MetaDataType metaDataType = MetaDataTypeHandle.GetMetaDataType(azMetaCloum.FldType);
stringBuilder.AddLineStatement("param = new SqlParameter();", 2);
stringBuilder.AddLineStatement("param.ParameterName = \"@" + azMetaCloum.FldName + "\";", 2);
if (azMetaCloum.IsOutParam == 0)
{
if (azMetaCloum.IsNullable == false)
{
stringBuilder.AddLineStatement($"param.Value={BaseConstants.ParamPer}Item.{azMetaCloum.FldNameTo};", 2);
}
else
{
stringBuilder.AddLineStatement($"if ({BaseConstants.ParamPer}Item.{azMetaCloum.FldNameTo}==null)", 2);
stringBuilder.AddLineStatement(" {param.Value = System.DBNull.Value;}", 2);
stringBuilder.AddLineStatement($"else", 2);
stringBuilder.AddLineStatement($"{{ param.Value={BaseConstants.ParamPer}Item.{azMetaCloum.FldNameTo};}};", 2);
}
}
else
{
stringBuilder.AddLineStatement("param.Direction = ParameterDirection.Output;}", 2);
}
if (metaDataType.CodeSign == 2)
{
stringBuilder.AddLineStatement($"param.Size = {azMetaCloum.FldLenCode};", 2);
}
stringBuilder.AddLineStatement($"param.SqlDbType = SqlDbType.{metaDataType.DBCodeType};", 2);
stringBuilder.AddLineStatement("cmd.Parameters.Add(param);", 2);
stringBuilder.AppendLine();
return(stringBuilder.ToString());
}
private void LoadList()
{
var list1 = MetaDataTypeHandle.GetMetaDataTypes();
foreach (var lt in list1)
{
cboBoxFldCodeType.Items.Add(lt.CodeType);
cboBoxFldType.Items.Add(lt.DBType);
}
}
public static string GetCorrectType(AzMetaCloumEntity azMetaCloum)
{
MetaDataType metaDataType = MetaDataTypeHandle.GetMetaDataType(azMetaCloum.FldType);
string ctype = metaDataType.CodeType;
if (azMetaCloum.IsNullable == true)
{
ctype = metaDataType.CodeGeneric;
}
return(ctype);
}
private static string ParamIdentityCreate(string idFldType)
{
StringBuilder stringBuilder = new StringBuilder();
MetaDataType metaDataType = MetaDataTypeHandle.GetMetaDataType(idFldType);
stringBuilder.AddLineStatement($"param = new SqlParameter();", 2);
stringBuilder.AddLineStatement($"param.SqlDbType = SqlDbType.{metaDataType.DBCodeType};", 2);
stringBuilder.AddLineStatement($"param.ParameterName = \"@getautouid\";", 2);
stringBuilder.AddLineStatement($"param.Direction = ParameterDirection.Output;", 2);
stringBuilder.AddLineStatement($"cmd.Parameters.Add(param);", 2);
stringBuilder.AppendLine();
return(stringBuilder.ToString());
}
private void tspMenuItemTurn_Click(object sender, EventArgs e)
{
if (GeneralHelpler.ConfirmQuestionOperate("确定根据DB数据类型初始代码数据类型吗？") == DialogResult.Cancel)
{
return;
}
var listcol = AzMetaCustomCloumHandle.Handle().Select().Where(t => t.TableName == currentObject.SchemaName).Go();
foreach (var item in listcol)
{
var entitype = MetaDataTypeHandle.GetMetaDataType(item.FldType);
item.FldCodeType = entitype.CodeType;
AzMetaCustomCloumHandle.Handle().Update(item);
}
LoadMataColum();
}
public static string SpParamCreate(AzMetaCloumEntity azMetaCloum)
{
StringBuilder stringBuilder = new StringBuilder();
bool iscannull = azMetaCloum.IsNullable != true;
string spfld = GetSpFldName(azMetaCloum.FldName, "P_");
string param_name = GetSpFldName(azMetaCloum.FldName, "param_");
stringBuilder.AddLineStatement($"SqlParameter {param_name} = new SqlParameter();", 2);
stringBuilder.AddLineStatement($"{param_name}.ParameterName =\"{azMetaCloum.FldName}\";", 2);
if (azMetaCloum.IsOutParam == 0)
{
if (iscannull)
{
stringBuilder.AddLineStatement($"{param_name}.Value ={BaseConstants.ParamPer}Item.{spfld};", 2);
}
else
{
stringBuilder.AddLineStatement($"if ({BaseConstants.ParamPer}Item.{spfld}==null)", 2);
stringBuilder.AddLineStatement($"{{{param_name}.Value =System.DBNull.Value;}}", 2);
stringBuilder.AddLineStatement($"else");
stringBuilder.AddLineStatement($"{{{param_name}.Value ={BaseConstants.ParamPer}Item.{spfld};}};", 2);
}
stringBuilder.AddLineStatement($"{param_name}.Direction = ParameterDirection.Input;", 2);
}
else
{
stringBuilder.AddLineStatement($"{param_name}.Direction = ParameterDirection.Output;", 2);
}
MetaDataType metaDataType = MetaDataTypeHandle.GetMetaDataType(azMetaCloum.FldType);
if (metaDataType.CodeSign == 2)
{
if (azMetaCloum.FldLen < 1)
{
stringBuilder.AddLineStatement($"{param_name}.Size = int.MaxValue - 1;", 2);
}
else
{
stringBuilder.AddLineStatement($"{param_name}.Size = {azMetaCloum.FldLen};", 2);
}
}
stringBuilder.AddLineStatement($"{param_name}.SqlDbType = SqlDbType.{metaDataType.DBCodeType};", 2);
stringBuilder.AddLineStatement($"cmd.Parameters.Add({param_name});", 2);
stringBuilder.AppendLine();
return(stringBuilder.ToString());
}
public static string SpParamarg_For_Mothod(IEnumerable <AzMetaCloumEntity> azMetaCloums)
{
string p = "";
foreach (var col in azMetaCloums)
{
MetaDataType metaDataType = MetaDataTypeHandle.GetMetaDataType(col.FldType);
if (string.IsNullOrWhiteSpace(p))
{
p = $"{ GetCorrectType(col)} {GetSpFldName(col.FldName, BaseConstants.ParamPer)}";
}
else
{
p += $",{ GetCorrectType(col)} {GetSpFldName(col.FldName, BaseConstants.ParamPer)}";
}
}
return(p);
}
public static string SpParam_InputThis(IEnumerable <AzMetaCloumEntity> azMetaCloums)
{
string p = "";
foreach (var col in azMetaCloums)
{
string spFldName = GetSpFldName(col.FldName, "this.P_");
MetaDataType metaDataType = MetaDataTypeHandle.GetMetaDataType(col.FldType);
if (string.IsNullOrWhiteSpace(p))
{
p = $"{spFldName}";
}
else
{
p += $",{spFldName}";
}
}
return(p);
}
public static string SpParamarg_For_Assignment(IEnumerable <AzMetaCloumEntity> azMetaCloums)
{
string p = "";
foreach (var col in azMetaCloums)
{
string spFldName = GetSpFldName(col.FldName, BaseConstants.ParamPer);
string spfld = GetSpFldName(col.FldName, "P_");
MetaDataType metaDataType = MetaDataTypeHandle.GetMetaDataType(col.FldType);
if (string.IsNullOrWhiteSpace(p))
{
p = $"{spfld} = {spFldName}";
}
else
{
p += $",{spfld} = {spFldName}";
}
}
return(p);
}
public static string ParamCreatekey(IEnumerable <AzMetaCloumEntity> azMetaCloums)
{
var cols = azMetaCloums.AsQueryable().Where(m => m.IsKeyField == true).ToList();
StringBuilder stringBuilder = new StringBuilder();
foreach (var col in cols)
{
MetaDataType metaDataType = MetaDataTypeHandle.GetMetaDataType(col.FldType);
stringBuilder.AddLineStatement("param = new SqlParameter();", 2);
stringBuilder.AddLineStatement("param.ParameterName = \"@" + col.FldName + "\";", 2);
stringBuilder.AddLineStatement($"param.Value=azItem.{col.FldNameTo};", 2);
if (metaDataType.CodeSign == 2)
{
stringBuilder.AddLineStatement($"param.Size = {col.FldLenCode};", 2);
}
stringBuilder.AddLineStatement($"param.SqlDbType = SqlDbType.{metaDataType.DBCodeType};", 2);
stringBuilder.AddLineStatement("cmd.Parameters.Add(param);", 2);
}
return(stringBuilder.ToString());
}
private void azCdgnDBSchema1_Atk_ReCreateDbData(object sender, EventArgs e)
{
if (GeneralHelpler.ConfirmQuestionOperate("确定重新导入？如果重新导入原设置将清除！") == DialogResult.Cancel)
{
return;
}
AzMetaCloumHandle.Handle().InitColumnSchema(metaTableEntity.SchemaName);
var listcol = AzMetaCustomCloumHandle.Handle().Select().Where(t => t.TableName == metaTableEntity.SchemaName).Go();
foreach (var item in listcol)
{
var entitype = MetaDataTypeHandle.GetMetaDataType(item.FldType);
if (entitype != null)
{
item.FldCodeType = entitype.CodeType;
AzMetaCustomCloumHandle.Handle().Update(item);
}
}
azCdgnDetail1.SetCurrentObject(metaTableEntity, 1);
}
