/// <summary>
/// 添加一行
/// </summary>
/// <param name="tabName"></param>
/// <param name="values"></param>
/// <returns></returns>
public long Add(string tabName, List <string> values)
{
string valuestr = string.Empty;
var sqlParams = new MySqlParameter[values.Count];
for (int i = 0; i < values.Count; i++)
{
var strKey = "@value" + i;
var strs = values[i].Split(':');
var dbType = GetDbType(strs[0]);
sqlParams[i] = new MySqlParameter(strKey, dbType)
{
Value = strs[1]
};
if (!string.IsNullOrEmpty(valuestr))
{
valuestr += ", ";
}
valuestr += strKey;
}
string strsql = "insert into " + tabName + " values (" + valuestr + ");";
return(MysqlUtility.ExecuteSql(strsql, sqlParams));
}
/// <summary>
/// 移除某个字段
/// </summary>
/// <param name="tabName"></param>
/// <param name="uid"></param>
/// <param name="key"></param>
public void Remove(string tabName, string uid, string key)
{
if (RedisUtility.KeyExist(key))
{
RedisUtility.KeyDelete(key);
}
var sqlParams = new MySqlParameter[]
{
new MySqlParameter("@openid", MySqlDbType.VarChar)
{
Value = uid
},
};
var strsql = "update " + tabName + " set " + key + "='' where openid =@openid";
MysqlUtility.ExecuteSql(strsql, sqlParams);
}
/// <summary>
/// 设置数据
/// </summary>
/// <param name="tabName"></param>
/// <param name="uid"></param>
/// <param name="key"></param>
/// <param name="value"></param>
public void Set(string tabName, string uid, string key, string value)
{
var strs = value.Split(':');
var dbType = GetDbType(strs[0]);
var sqlParams = new MySqlParameter[]
{
new MySqlParameter("@value", dbType)
{
Value = strs[1]
},
new MySqlParameter("@openid", MySqlDbType.VarChar)
{
Value = uid
},
};
string strKey = tabName + "_" + uid + "_" + key;
RedisUtility.StringSet(strKey, strs[1], expireTime);
var strsql = "update " + tabName + " set " + key + "=@value where openid=@openid";
MysqlUtility.ExecuteSql(strsql, sqlParams);
}
