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)); } }