public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtUserId.Text)) { strErr += "UserId格式错误!\\n"; } if (!PageValidate.IsNumber(txtRoleId.Text)) { strErr += "RoleId格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int UserId = int.Parse(this.txtUserId.Text); int RoleId = int.Parse(this.txtRoleId.Text); Bsam.Core.Model.Models.Model.Sys_User_In_Role model = new Bsam.Core.Model.Models.Model.Sys_User_In_Role(); model.UserId = UserId; model.RoleId = RoleId; Bsam.Core.Model.Models.BLL.Sys_User_In_Role bll = new Bsam.Core.Model.Models.BLL.Sys_User_In_Role(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
private void ShowInfo() { Bsam.Core.Model.Models.BLL.Sys_User_In_Role bll = new Bsam.Core.Model.Models.BLL.Sys_User_In_Role(); Bsam.Core.Model.Models.Model.Sys_User_In_Role model = bll.GetModel(); this.txtUserId.Text = model.UserId.ToString(); this.txtRoleId.Text = model.RoleId.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Bsam.Core.Model.Models.Model.Sys_User_In_Role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_User_In_Role set "); strSql.Append("UserId=@UserId,"); strSql.Append("RoleId=@RoleId"); strSql.Append(" where "); SQLiteParameter[] parameters = { new SQLiteParameter("@UserId", DbType.Int32, 4), new SQLiteParameter("@RoleId", DbType.Int32, 4) }; parameters[0].Value = model.UserId; parameters[1].Value = model.RoleId; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Bsam.Core.Model.Models.Model.Sys_User_In_Role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_User_In_Role("); strSql.Append("UserId,RoleId)"); strSql.Append(" values ("); strSql.Append("@UserId,@RoleId)"); SQLiteParameter[] parameters = { new SQLiteParameter("@UserId", DbType.Int32, 4), new SQLiteParameter("@RoleId", DbType.Int32, 4) }; parameters[0].Value = model.UserId; parameters[1].Value = model.RoleId; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Bsam.Core.Model.Models.Model.Sys_User_In_Role DataRowToModel(DataRow row) { Bsam.Core.Model.Models.Model.Sys_User_In_Role model = new Bsam.Core.Model.Models.Model.Sys_User_In_Role(); if (row != null) { if (row["UserId"] != null && row["UserId"].ToString() != "") { model.UserId = int.Parse(row["UserId"].ToString()); } if (row["RoleId"] != null && row["RoleId"].ToString() != "") { model.RoleId = int.Parse(row["RoleId"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Bsam.Core.Model.Models.Model.Sys_User_In_Role GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select UserId,RoleId from Sys_User_In_Role "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Bsam.Core.Model.Models.Model.Sys_User_In_Role model = new Bsam.Core.Model.Models.Model.Sys_User_In_Role(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }