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