private bool DoAdd() { bool flag = false; Rain.Model.user_groups model = new Rain.Model.user_groups(); Rain.BLL.user_groups userGroups = new Rain.BLL.user_groups(); model.title = this.txtTitle.Text.Trim(); model.is_lock = 0; if (this.rblIsLock.Checked) { model.is_lock = 1; } model.is_default = 0; if (this.rblIsDefault.Checked) { model.is_default = 1; } model.is_upgrade = 0; if (this.rblIsUpgrade.Checked) { model.is_upgrade = 1; } model.grade = int.Parse(this.txtGrade.Text.Trim()); model.upgrade_exp = int.Parse(this.txtUpgradeExp.Text.Trim()); model.amount = Decimal.Parse(this.txtAmount.Text.Trim()); model.point = int.Parse(this.txtPoint.Text.Trim()); model.discount = int.Parse(this.txtDiscount.Text.Trim()); if (userGroups.Add(model) > 0) { this.AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加用户组:" + model.title); flag = true; } return(flag); }
public int Add(Rain.Model.user_groups 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_groups("); stringBuilder.Append("title,grade,upgrade_exp,amount,point,discount,is_default,is_upgrade,is_lock)"); stringBuilder.Append(" values ("); stringBuilder.Append("@title,@grade,@upgrade_exp,@amount,@point,@discount,@is_default,@is_upgrade,@is_lock)"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[9] { new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@grade", OleDbType.Integer, 4), new OleDbParameter("@upgrade_exp", OleDbType.Integer, 4), new OleDbParameter("@amount", OleDbType.Decimal, 5), new OleDbParameter("@point", OleDbType.Integer, 4), new OleDbParameter("@discount", OleDbType.Integer, 4), new OleDbParameter("@is_default", OleDbType.Integer, 4), new OleDbParameter("@is_upgrade", OleDbType.Integer, 4), new OleDbParameter("@is_lock", OleDbType.Integer, 4) }; oleDbParameterArray[0].Value = (object)model.title; oleDbParameterArray[1].Value = (object)model.grade; oleDbParameterArray[2].Value = (object)model.upgrade_exp; oleDbParameterArray[3].Value = (object)model.amount; oleDbParameterArray[4].Value = (object)model.point; oleDbParameterArray[5].Value = (object)model.discount; oleDbParameterArray[6].Value = (object)model.is_default; oleDbParameterArray[7].Value = (object)model.is_upgrade; oleDbParameterArray[8].Value = (object)model.is_lock; 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_groups DataRowToModel(DataRow row) { Rain.Model.user_groups userGroups = new Rain.Model.user_groups(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { userGroups.id = int.Parse(row["id"].ToString()); } if (row["title"] != null) { userGroups.title = row["title"].ToString(); } if (row["grade"] != null && row["grade"].ToString() != "") { userGroups.grade = int.Parse(row["grade"].ToString()); } if (row["upgrade_exp"] != null && row["upgrade_exp"].ToString() != "") { userGroups.upgrade_exp = int.Parse(row["upgrade_exp"].ToString()); } if (row["amount"] != null && row["amount"].ToString() != "") { userGroups.amount = Decimal.Parse(row["amount"].ToString()); } if (row["point"] != null && row["point"].ToString() != "") { userGroups.point = int.Parse(row["point"].ToString()); } if (row["discount"] != null && row["discount"].ToString() != "") { userGroups.discount = int.Parse(row["discount"].ToString()); } if (row["is_default"] != null && row["is_default"].ToString() != "") { userGroups.is_default = int.Parse(row["is_default"].ToString()); } if (row["is_upgrade"] != null && row["is_upgrade"].ToString() != "") { userGroups.is_upgrade = int.Parse(row["is_upgrade"].ToString()); } if (row["is_lock"] != null && row["is_lock"].ToString() != "") { userGroups.is_lock = int.Parse(row["is_lock"].ToString()); } } return(userGroups); }
private void UserPage_Init(object sender, EventArgs e) { if (!this.IsUserLogin()) { HttpContext.Current.Response.Redirect(this.linkurl("login")); } else { this.userModel = this.GetUserInfo(); this.groupModel = new Rain.BLL.user_groups().GetModel(this.userModel.group_id); if (this.groupModel == null) { this.groupModel = new Rain.Model.user_groups(); } this.InitPage(); } }
public bool Update(Rain.Model.user_groups model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update " + this.databaseprefix + "user_groups set "); stringBuilder.Append("title=@title,"); stringBuilder.Append("grade=@grade,"); stringBuilder.Append("upgrade_exp=@upgrade_exp,"); stringBuilder.Append("amount=@amount,"); stringBuilder.Append("point=@point,"); stringBuilder.Append("discount=@discount,"); stringBuilder.Append("is_default=@is_default,"); stringBuilder.Append("is_upgrade=@is_upgrade,"); stringBuilder.Append("is_lock=@is_lock"); stringBuilder.Append(" where id=@id"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[10] { new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@grade", OleDbType.Integer, 4), new OleDbParameter("@upgrade_exp", OleDbType.Integer, 4), new OleDbParameter("@amount", OleDbType.Decimal, 5), new OleDbParameter("@point", OleDbType.Integer, 4), new OleDbParameter("@discount", OleDbType.Integer, 4), new OleDbParameter("@is_default", OleDbType.Integer, 4), new OleDbParameter("@is_upgrade", OleDbType.Integer, 4), new OleDbParameter("@is_lock", OleDbType.Integer, 4), new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray[0].Value = (object)model.title; oleDbParameterArray[1].Value = (object)model.grade; oleDbParameterArray[2].Value = (object)model.upgrade_exp; oleDbParameterArray[3].Value = (object)model.amount; oleDbParameterArray[4].Value = (object)model.point; oleDbParameterArray[5].Value = (object)model.discount; oleDbParameterArray[6].Value = (object)model.is_default; oleDbParameterArray[7].Value = (object)model.is_upgrade; oleDbParameterArray[8].Value = (object)model.is_lock; oleDbParameterArray[9].Value = (object)model.id; return(DbHelperOleDb.ExecuteSql(stringBuilder.ToString(), oleDbParameterArray) > 0); }
public bool Update(Rain.Model.user_groups model) { return(this.dal.Update(model)); }
public int Add(Rain.Model.user_groups model) { return(this.dal.Add(model)); }