public bool Update(Rain.Model.user_oauth model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update " + this.databaseprefix + "user_oauth set ");
stringBuilder.Append("user_id=@user_id,");
stringBuilder.Append("user_name=@user_name,");
stringBuilder.Append("oauth_name=@oauth_name,");
stringBuilder.Append("oauth_access_token=@oauth_access_token,");
stringBuilder.Append("oauth_openid=@oauth_openid,");
stringBuilder.Append("add_time=@add_time");
stringBuilder.Append(" where id=@id");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[7]
{
new OleDbParameter("@user_id", OleDbType.Integer, 4),
new OleDbParameter("@user_name", OleDbType.VarChar, 100),
new OleDbParameter("@oauth_name", OleDbType.VarChar, 50),
new OleDbParameter("@oauth_access_token", OleDbType.VarChar, 500),
new OleDbParameter("@oauth_openid", OleDbType.VarChar, (int)byte.MaxValue),
new OleDbParameter("@add_time", OleDbType.Date),
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)model.user_id;
oleDbParameterArray[1].Value = (object)model.user_name;
oleDbParameterArray[2].Value = (object)model.oauth_name;
oleDbParameterArray[3].Value = (object)model.oauth_access_token;
oleDbParameterArray[4].Value = (object)model.oauth_openid;
oleDbParameterArray[5].Value = (object)model.add_time;
oleDbParameterArray[6].Value = (object)model.id;
return(DbHelperOleDb.ExecuteSql(stringBuilder.ToString(), oleDbParameterArray) > 0);
}
public int Add(Rain.Model.user_oauth model)
{
int maxId;
using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString))
{
oleDbConnection.Open();
using (OleDbTransaction trans = oleDbConnection.BeginTransaction())
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into " + this.databaseprefix + "user_oauth(");
stringBuilder.Append("user_id,user_name,oauth_name,oauth_access_token,oauth_openid,add_time)");
stringBuilder.Append(" values (");
stringBuilder.Append("@user_id,@user_name,@oauth_name,@oauth_access_token,@oauth_openid,@add_time)");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[6]
{
new OleDbParameter("@user_id", OleDbType.Integer, 4),
new OleDbParameter("@user_name", OleDbType.VarChar, 100),
new OleDbParameter("@oauth_name", OleDbType.VarChar, 50),
new OleDbParameter("@oauth_access_token", OleDbType.VarChar, 500),
new OleDbParameter("@oauth_openid", OleDbType.VarChar, (int)byte.MaxValue),
new OleDbParameter("@add_time", OleDbType.Date)
};
oleDbParameterArray[0].Value = (object)model.user_id;
oleDbParameterArray[1].Value = (object)model.user_name;
oleDbParameterArray[2].Value = (object)model.oauth_name;
oleDbParameterArray[3].Value = (object)model.oauth_access_token;
oleDbParameterArray[4].Value = (object)model.oauth_openid;
oleDbParameterArray[5].Value = (object)model.add_time;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder.ToString(), oleDbParameterArray);
maxId = this.GetMaxId(oleDbConnection, trans);
trans.Commit();
}
catch
{
trans.Rollback();
return(-1);
}
}
}
return(maxId);
}
public Rain.Model.user_oauth DataRowToModel(DataRow row)
{
Rain.Model.user_oauth userOauth = new Rain.Model.user_oauth();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
userOauth.id = int.Parse(row["id"].ToString());
}
if (row["user_id"] != null && row["user_id"].ToString() != "")
{
userOauth.user_id = int.Parse(row["user_id"].ToString());
}
if (row["user_name"] != null)
{
userOauth.user_name = row["user_name"].ToString();
}
if (row["oauth_name"] != null)
{
userOauth.oauth_name = row["oauth_name"].ToString();
}
if (row["oauth_access_token"] != null)
{
userOauth.oauth_access_token = row["oauth_access_token"].ToString();
}
if (row["oauth_openid"] != null)
{
userOauth.oauth_openid = row["oauth_openid"].ToString();
}
if (row["add_time"] != null && row["add_time"].ToString() != "")
{
userOauth.add_time = DateTime.Parse(row["add_time"].ToString());
}
}
return(userOauth);
}
public bool Update(Rain.Model.user_oauth model)
{
return(this.dal.Update(model));
}
public int Add(Rain.Model.user_oauth model)
{
return(this.dal.Add(model));
}
