/// <summary>
///
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public static string GetProcTypeString(ColumnVO c)
{
switch (c.UserTypeName)
{
case "nvarchar":
case "nchar":
return(c.UserTypeName + "(" + ((c.MaxLength == -1) ? "max" : ((c.MaxLength / 2)).ToString()) + ")");
case "varchar":
case "char":
return(c.UserTypeName + "(" + ((c.MaxLength == -1) ? "max" : c.MaxLength.ToString()) + ")");
}
return(c.UserTypeName);
}
/// <summary>
///
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public static int GetParameterSize(ColumnVO c)
{
switch (c.UserTypeName)
{
case "nvarchar":
case "nchar":
return(c.MaxLength == -1 ? -1 : c.MaxLength / 2);
case "varchar":
case "char":
return(c.MaxLength == -1 ? -1 : c.MaxLength);
}
return(c.MaxLength);
}
private ColumnVO LoadColumn(IDataReader reader)
{
ColumnVO c = new ColumnVO();
c.ColumnId = ReadInt(reader, FIELD_COLUMN_ID);
c.Name = ReadString(reader, FIELD_NAME);
c.UserTypeName = ReadString(reader, FIELD_USER_TYPE_NAME);
c.MaxLength = ReadInt(reader, FIELD_MAX_LENGTH);
c.Precision = ReadInt(reader, FIELD_PRECISION);
c.Scale = ReadInt(reader, FIELD_SCALE);
c.IsIdentity = ReadBool(reader, FIELD_IS_IDENTITY);
//c.CreatedDate = ReadDate( reader, FIELD_CREATED_DATE );
//c.ModifiedDate = ReadDate( reader, FIELD_MODIFIED_DATE );
return(c);
}
/// <summary>
///
/// </summary>
/// <param name="lst"></param>
/// <returns></returns>
public static string GetSQLParameter(ColumnVO item)
{
return(string.Format(" SqlHelper.MakeInParameter( AT + FIELD_{0}, SqlDbType.{1}, {2}, {3} )", item.Name.ToUpper(), ConvertSqlTypeToSqlDataType(item.UserTypeName), GetParameterSize(item), item.Name.Substring(0, 1).ToLower() + item.Name.Substring(1)));
}
/// <summary>
///
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public static string GetMethodCallParameter(ColumnVO item)
{
return(string.Format("{0}", item.Name.Substring(0, 1).ToLower() + item.Name.Substring(1)));
}
/// <summary>
///
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public static string GetMethodParameter(ColumnVO item)
{
return(string.Format("{0} {1}", ConvertSqlTypeToCSharp(item.UserTypeName), item.Name.Substring(0, 1).ToLower() + item.Name.Substring(1)));
}
/// <summary>
///
/// </summary>
/// <param name="lst"></param>
/// <returns></returns>
public static string GetSQLWhereAnd(ColumnVO item)
{
return(string.Format("[{0}] = @{0}", item.Name));
}
