public static int UpdateTableMap(TableMapModel model)
{
const string sqlStr = @"UPDATE Tuhu_dbd..TableMap WITH ( ROWLOCK )
SET TableId = @tableid ,
FieldId = @fieldid ,
FieldType = @fieldtype ,
FieldSize = @fieldsize ,
ByteCount = @bytecount ,
DecimalSize = @decimalsize ,
IsNullable = @isnullable ,
Description = IIF(LTRIM(Description) <> '', Description, @description) ,
DefaultValue = @defaultvalue ,
IsPK = @ispk ,
IsIdentity = @isidentity
WHERE TableId = @tableid
AND FieldName = @fieldname;";
using (var cmd = new SqlCommand(sqlStr))
{
cmd.Parameters.AddWithValue("@fieldsize", model.FieldSize);
cmd.Parameters.AddWithValue("@fieldid", model.FieldId);
cmd.Parameters.AddWithValue("@fieldtype", model.FieldType);
cmd.Parameters.AddWithValue("@bytecount", model.ByteCount);
cmd.Parameters.AddWithValue("@decimalsize", model.DecimalSize);
cmd.Parameters.AddWithValue("@isnullable", model.IsNullable);
cmd.Parameters.AddWithValue("@defaultvalue", model.DefaultValue);
cmd.Parameters.AddWithValue("@description", model.Description);
cmd.Parameters.AddWithValue("@ispk", model.IsPk);
cmd.Parameters.AddWithValue("@isidentity", model.IsIdentity);
cmd.Parameters.AddWithValue("@tableid", model.TableId);
cmd.Parameters.AddWithValue("@fieldname", model.FieldName);
return(DbHelper.ExecuteNonQuery(cmd));
}
}
public static int AddtableMap(TableMapModel model)
{
#region SQLStr
const string sqlStr = @"INSERT INTO Tuhu_dbd..TableMap
(TableId,
FieldId,
FieldName,
FieldType,
FieldSize,
ByteCount,
DecimalSize,
IsNullable,
DefaultValue,
Description,
IsPK,
IsIdentity
)
VALUES(@tableid,
@fieldid,
@fieldname,
@fieldtype,
@fieldsize,
@bytecount,
@decimalsize,
@isnullable,
@defaultvalue,
@description,
@ispk,
@isidentity
); " ;
#endregion
using (var cmd = new SqlCommand(sqlStr))
{
cmd.Parameters.AddWithValue("@tableid", model.TableId);
cmd.Parameters.AddWithValue("@fieldid", model.FieldId);
cmd.Parameters.AddWithValue("@fieldname", model.FieldName);
cmd.Parameters.AddWithValue("@fieldtype", model.FieldType);
cmd.Parameters.AddWithValue("@fieldsize", model.FieldSize);
cmd.Parameters.AddWithValue("@bytecount", model.ByteCount);
cmd.Parameters.AddWithValue("@decimalsize", model.DecimalSize);
cmd.Parameters.AddWithValue("@isnullable", model.IsNullable);
cmd.Parameters.AddWithValue("@defaultvalue", model.DefaultValue);
cmd.Parameters.AddWithValue("@description", model.Description);
cmd.Parameters.AddWithValue("@ispk", model.IsPk);
cmd.Parameters.AddWithValue("@isidentity", model.IsIdentity);
return(DbHelper.ExecuteNonQuery(cmd));
}
}
