/// <summary>
/// 表:T 的修改方法｜｜表描述：臂长操作
/// </summary>
/// <param name="model">T 实例</param>
/// <param name="transaction">数据库事务对象</param>
/// <returns>返回结果：0(修改错误)，>0(修改成功)</returns>
public int Update(T model, SqlTransaction transaction)
{
var sqlClause = string.Format(UpdateSqlClause, TableName);
var parameters = GetParameters(model, true);
return
(DbHelperSql.ExecuteSql(ConnectionString, sqlClause, parameters));
}
/// <summary>
/// 表:d_ArmLenOperate的删除方法｜｜表描述：臂长操作
/// </summary>
/// <param name="id">主键ID</param>
/// <param name="transaction">数据库事务对象</param>
/// <returns>返回结果：0(删除错误)，>0(删除成功)</returns>
public int Delete(int id, SqlTransaction transaction)
{
var sqlClause = string.Format("DELETE FROM {0} WHERE {1} =@Id", TableName, PrimaryKeyName);
var parameters = new[] { new SqlParameter("@Id", SqlDbType.Int, 4) };
parameters[0].Value = id;
return
(DbHelperSql.ExecuteSql(ConnectionString, sqlClause, parameters));
}
public virtual int Update(int id, string fieldname, object fieldValue)
{
var sqlClause = string.Format("UPDATE SET {2}='{3}' {0} WHERE {1} =@Id", TableName, PrimaryKeyName, fieldname, fieldValue);
var parameters = new[] { new SqlParameter("@Id", SqlDbType.Int, 4) };
parameters[0].Value = id;
return
(DbHelperSql.ExecuteSql(ConnectionString, sqlClause, parameters));
}
/// <summary>
/// 根据黑匣子编号删除记录
/// </summary>
/// <param name="fieldValue"></param>
/// <param name="transaction"></param>
/// <param name="fieldname"></param>
public void DeleteByField <TElement>(string fieldname, T fieldValue, SqlTransaction transaction)
{
var sqlClause = string.Format("DELETE FROM {0} WHERE {1} =@{1}", TableName, fieldname);
SqlDbType sqlDbType = SqlDbType.BigInt;
int size = 0;
if (typeof(TElement) == typeof(int))
{
sqlDbType = SqlDbType.Int;
size = 4;
}
else if (typeof(TElement) == typeof(Int64))
{
sqlDbType = SqlDbType.BigInt;
size = 8;
}
else if (typeof(TElement) == typeof(Guid))
{
sqlDbType = SqlDbType.UniqueIdentifier;
size = 16;
}
else if (typeof(TElement) == typeof(DateTime))
{
sqlDbType = SqlDbType.DateTime;
size = 16;
}
else if (typeof(TElement) == typeof(string))
{
sqlDbType = SqlDbType.NVarChar;
size = (fieldValue.ToString()).Length;
}
else
{
return;
}
var parameters = new[] { new SqlParameter(string.Format("@{0}", fieldValue), sqlDbType, size) };
parameters[0].Value = fieldValue;
DbHelperSql.ExecuteSql(ConnectionString, sqlClause, parameters);
}
public void Execute(string sqlClause)
{
DbHelperSql.ExecuteSql(this.ConnectionString, sqlClause);
}
