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