public virtual int Update(string sql, params SqlParameter[] cmdParms)
{
DbCommand dbCommand = m_Db.GetSqlStringCommand(sql);
foreach (SqlParameter sp in cmdParms)
{
m_Db.AddInParameter(dbCommand, sp.ParameterName, sp.DbType, sp.Value);
}
return(m_Db.ExecuteNonQuery(dbCommand));
}
public void SetSetting(Setting setting)
{
var cmd = _database.GetSqlStringCommand(SaveOrUpdateCommandText);
_database.AddInParameter(cmd, "@Name", DbType.String, setting.Key);
_database.AddInParameter(cmd, "@Value", DbType.String, setting.Value);
_database.AddInParameter(cmd, "@IsEncrypted", DbType.Boolean, setting.IsEncrypted);
_database.ExecuteNonQuery(cmd);
}
/// <summary>
/// 获取字段值(如果使用参数方式 返回参数名称)
/// </summary>
/// <param name="fieldName">字段名称</param>
/// <param name="fieldValue">字段值</param>
/// <param name="isParamMode">是否参数方式</param>
/// <param name="command">命令对象</param>
/// <param name="database">数据库对象</param>
/// <param name="parPix">参数名称修饰</param>
protected virtual string GetFieldValue(string fieldName, object fieldValue, bool isParamMode, DbCommand command, IDatabase database, string parPix = "par")
{
if (isParamMode)
{
Type objType = typeof(string);
if (fieldValue != null)
{
objType = fieldValue.GetType();
}
string paramName = string.Format("{0}{1}", parPix, fieldName);
if (objType == typeof(SQLValue))
{
var sqlValue = (SQLValue)fieldValue;
if (sqlValue != null)
{
fieldValue = sqlValue.FieldValue.ToString();
}
}
var paramObj = database.AddInParameter(command, paramName, fieldValue, 0, CSharpTypeToDbType(objType, fieldName));
return(paramObj.ParameterName);
}
if (fieldValue == null)
{
return("NULL");
}
Type fileType = fieldValue.GetType();
if (TypeHelper.IsNumeric(fileType))
{
return(fieldValue.ToString());
}
if (TypeHelper.IsBoolean(fileType))
{
bool colValue = fieldValue.ToBool();
if (colValue)
{
return("1");
}
return("0");
}
if (fileType == typeof(SQLValue))
{
return(((SQLValue)fieldValue).FieldValue.ToString());
}
return(string.Format("'{0}'", EncodeFieldValue(fieldValue.ToString())));
}
public void AddInParameter(DbCommand command, string name, SqlDbType dbType, object value)
{
_database.AddInParameter(command, name, dbType, value);
}