public int Add(Rain.Model.user_oauth_app 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_app("); stringBuilder.Append("title,img_url,app_id,app_key,[remark],sort_id,is_lock,api_path)"); stringBuilder.Append(" values ("); stringBuilder.Append("@title,@img_url,@app_id,@app_key,@remark,@sort_id,@is_lock,@api_path)"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[8] { new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@img_url", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@app_id", OleDbType.VarChar, 100), new OleDbParameter("@app_key", OleDbType.VarChar, 500), new OleDbParameter("@remark", OleDbType.VarChar, 500), new OleDbParameter("@sort_id", OleDbType.Integer, 4), new OleDbParameter("@is_lock", OleDbType.Integer, 4), new OleDbParameter("@api_path", OleDbType.VarChar, (int)byte.MaxValue) }; oleDbParameterArray[0].Value = (object)model.title; oleDbParameterArray[1].Value = (object)model.img_url; oleDbParameterArray[2].Value = (object)model.app_id; oleDbParameterArray[3].Value = (object)model.app_key; oleDbParameterArray[4].Value = (object)model.remark; oleDbParameterArray[5].Value = (object)model.sort_id; oleDbParameterArray[6].Value = (object)model.is_lock; oleDbParameterArray[7].Value = (object)model.api_path; 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_app DataRowToModel(DataRow row) { Rain.Model.user_oauth_app userOauthApp = new Rain.Model.user_oauth_app(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { userOauthApp.id = int.Parse(row["id"].ToString()); } if (row["title"] != null) { userOauthApp.title = row["title"].ToString(); } if (row["img_url"] != null) { userOauthApp.img_url = row["img_url"].ToString(); } if (row["app_id"] != null) { userOauthApp.app_id = row["app_id"].ToString(); } if (row["app_key"] != null) { userOauthApp.app_key = row["app_key"].ToString(); } if (row["remark"] != null) { userOauthApp.remark = row["remark"].ToString(); } if (row["sort_id"] != null && row["sort_id"].ToString() != "") { userOauthApp.sort_id = int.Parse(row["sort_id"].ToString()); } if (row["is_lock"] != null && row["is_lock"].ToString() != "") { userOauthApp.is_lock = int.Parse(row["is_lock"].ToString()); } if (row["api_path"] != null) { userOauthApp.api_path = row["api_path"].ToString(); } } return(userOauthApp); }
private bool DoEdit(int _id) { bool flag = false; Rain.BLL.user_oauth_app userOauthApp = new Rain.BLL.user_oauth_app(); Rain.Model.user_oauth_app model = userOauthApp.GetModel(_id); model.title = this.txtTitle.Text.Trim(); model.is_lock = !this.cbIsLock.Checked ? 1 : 0; model.sort_id = Utils.StrToInt(this.txtSortId.Text.Trim(), 99); model.api_path = this.txtApiPath.Text.Trim(); model.app_id = this.txtAppId.Text.Trim(); model.app_key = this.txtAppKey.Text.Trim(); model.img_url = this.txtImgUrl.Text.Trim(); model.remark = this.txtRemark.Text; if (userOauthApp.Update(model)) { this.AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改OAuth信息:" + model.title); flag = true; } return(flag); }
public bool Update(Rain.Model.user_oauth_app model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update " + this.databaseprefix + "user_oauth_app set "); stringBuilder.Append("title=@title,"); stringBuilder.Append("img_url=@img_url,"); stringBuilder.Append("app_id=@app_id,"); stringBuilder.Append("app_key=@app_key,"); stringBuilder.Append("[remark]=@remark,"); stringBuilder.Append("sort_id=@sort_id,"); stringBuilder.Append("is_lock=@is_lock,"); stringBuilder.Append("api_path=@api_path"); stringBuilder.Append(" where id=@id"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[9] { new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@img_url", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@app_id", OleDbType.VarChar, 100), new OleDbParameter("@app_key", OleDbType.VarChar, 500), new OleDbParameter("@remark", OleDbType.VarChar, 500), new OleDbParameter("@sort_id", OleDbType.Integer, 4), new OleDbParameter("@is_lock", OleDbType.Integer, 4), new OleDbParameter("@api_path", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray[0].Value = (object)model.title; oleDbParameterArray[1].Value = (object)model.img_url; oleDbParameterArray[2].Value = (object)model.app_id; oleDbParameterArray[3].Value = (object)model.app_key; oleDbParameterArray[4].Value = (object)model.remark; oleDbParameterArray[5].Value = (object)model.sort_id; oleDbParameterArray[6].Value = (object)model.is_lock; oleDbParameterArray[7].Value = (object)model.api_path; oleDbParameterArray[8].Value = (object)model.id; return(DbHelperOleDb.ExecuteSql(stringBuilder.ToString(), oleDbParameterArray) > 0); }
public bool Update(Rain.Model.user_oauth_app model) { return(this.dal.Update(model)); }
public int Add(Rain.Model.user_oauth_app model) { return(this.dal.Add(model)); }