private void ShowInfo(string _order_no)
{
this.model = new Rain.BLL.orders().GetModel(_order_no);
this.adminModel = this.GetAdminInfo();
this.rptList.DataSource = (object)this.model.order_goods;
this.rptList.DataBind();
}
private bool DoAdd()
{
Rain.Model.manager model = new Rain.Model.manager();
Rain.BLL.manager manager = new Rain.BLL.manager();
model.role_id = int.Parse(this.ddlRoleId.SelectedValue);
model.role_type = new Rain.BLL.manager_role().GetModel(model.role_id).role_type;
model.is_lock = !this.cbIsLock.Checked ? 1 : 0;
if (manager.Exists(this.txtUserName.Text.Trim()))
{
return(false);
}
model.user_name = this.txtUserName.Text.Trim();
model.salt = Utils.GetCheckCode(6);
model.password = DESEncrypt.Encrypt(this.txtPassword.Text.Trim(), model.salt);
model.real_name = this.txtRealName.Text.Trim();
model.telephone = this.txtTelephone.Text.Trim();
model.email = this.txtEmail.Text.Trim();
model.add_time = DateTime.Now;
if (manager.Add(model) <= 0)
{
return(false);
}
this.AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加管理员:" + model.user_name);
return(true);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Rain.BLL.manager manager = new Rain.BLL.manager();
Rain.Model.manager adminInfo = this.GetAdminInfo();
if (DESEncrypt.Encrypt(this.txtOldPassword.Text.Trim(), adminInfo.salt) != adminInfo.password)
{
this.JscriptMsg("旧密码不正确！", "");
}
else if (this.txtPassword.Text.Trim() != this.txtPassword1.Text.Trim())
{
this.JscriptMsg("两次密码不一致！", "");
}
else
{
adminInfo.password = DESEncrypt.Encrypt(this.txtPassword.Text.Trim(), adminInfo.salt);
adminInfo.real_name = this.txtRealName.Text.Trim();
adminInfo.telephone = this.txtTelephone.Text.Trim();
adminInfo.email = this.txtEmail.Text.Trim();
if (!manager.Update(adminInfo))
{
this.JscriptMsg("保存过程中发生错误！", "");
}
else
{
this.Session["dt_session_admin_info"] = (object)null;
this.JscriptMsg("密码修改成功！", "manager_pwd.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.keywords = DTRequest.GetQueryString("keywords");
this.pageSize = this.GetPageSize(10);
if (this.Page.IsPostBack)
{
return;
}
this.ChkAdminLevel(nameof(manager_log), DTEnums.ActionEnum.View.ToString());
this.model = this.GetAdminInfo();
this.RptBind("id>0" + this.CombSqlTxt(this.keywords), "add_time desc,id desc");
}
public bool AddAdminLog(string action_type, string remark)
{
if (this.siteConfig.logstatus > 0)
{
Rain.Model.manager adminInfo = this.GetAdminInfo();
if (new Rain.BLL.manager_log().Add(adminInfo.id, adminInfo.user_name, action_type, remark) > 0)
{
return(true);
}
}
return(false);
}
public Rain.Model.manager GetAdminInfo()
{
if (this.IsAdminLogin())
{
Rain.Model.manager manager = this.Session["dt_session_admin_info"] as Rain.Model.manager;
if (manager != null)
{
return(manager);
}
}
return((Rain.Model.manager)null);
}
public int Add(Rain.Model.manager 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 + "manager(");
stringBuilder.Append("role_id,role_type,user_name,[password],salt,real_name,telephone,email,is_lock,add_time)");
stringBuilder.Append(" values (");
stringBuilder.Append("@role_id,@role_type,@user_name,@password,@salt,@real_name,@telephone,@email,@is_lock,@add_time)");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[10]
{
new OleDbParameter("@role_id", OleDbType.Integer, 4),
new OleDbParameter("@role_type", OleDbType.Integer, 4),
new OleDbParameter("@user_name", OleDbType.VarChar, 100),
new OleDbParameter("@password", OleDbType.VarChar, 100),
new OleDbParameter("@salt", OleDbType.VarChar, 20),
new OleDbParameter("@real_name", OleDbType.VarChar, 50),
new OleDbParameter("@telephone", OleDbType.VarChar, 30),
new OleDbParameter("@email", OleDbType.VarChar, 30),
new OleDbParameter("@is_lock", OleDbType.Integer, 4),
new OleDbParameter("@add_time", OleDbType.Date)
};
oleDbParameterArray[0].Value = (object)model.role_id;
oleDbParameterArray[1].Value = (object)model.role_type;
oleDbParameterArray[2].Value = (object)model.user_name;
oleDbParameterArray[3].Value = (object)model.password;
oleDbParameterArray[4].Value = (object)model.salt;
oleDbParameterArray[5].Value = (object)model.real_name;
oleDbParameterArray[6].Value = (object)model.telephone;
oleDbParameterArray[7].Value = (object)model.email;
oleDbParameterArray[8].Value = (object)model.is_lock;
oleDbParameterArray[9].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.manager GetModel(int id)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 id,role_id,role_type,user_name,[password],salt,real_name,telephone,email,is_lock,add_time from " + this.databaseprefix + "manager ");
stringBuilder.Append(" where id=@id");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)id;
Rain.Model.manager manager = new Rain.Model.manager();
DataSet dataSet = DbHelperOleDb.Query(stringBuilder.ToString(), oleDbParameterArray);
if (dataSet.Tables[0].Rows.Count <= 0)
{
return((Rain.Model.manager)null);
}
if (dataSet.Tables[0].Rows[0][nameof(id)].ToString() != "")
{
manager.id = int.Parse(dataSet.Tables[0].Rows[0][nameof(id)].ToString());
}
if (dataSet.Tables[0].Rows[0]["role_id"].ToString() != "")
{
manager.role_id = int.Parse(dataSet.Tables[0].Rows[0]["role_id"].ToString());
}
if (dataSet.Tables[0].Rows[0]["role_type"].ToString() != "")
{
manager.role_type = int.Parse(dataSet.Tables[0].Rows[0]["role_type"].ToString());
}
manager.user_name = dataSet.Tables[0].Rows[0]["user_name"].ToString();
manager.password = dataSet.Tables[0].Rows[0]["password"].ToString();
manager.salt = dataSet.Tables[0].Rows[0]["salt"].ToString();
manager.real_name = dataSet.Tables[0].Rows[0]["real_name"].ToString();
manager.telephone = dataSet.Tables[0].Rows[0]["telephone"].ToString();
manager.email = dataSet.Tables[0].Rows[0]["email"].ToString();
if (dataSet.Tables[0].Rows[0]["is_lock"].ToString() != "")
{
manager.is_lock = int.Parse(dataSet.Tables[0].Rows[0]["is_lock"].ToString());
}
if (dataSet.Tables[0].Rows[0]["add_time"].ToString() != "")
{
manager.add_time = DateTime.Parse(dataSet.Tables[0].Rows[0]["add_time"].ToString());
}
return(manager);
}
public bool Update(Rain.Model.manager model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update " + this.databaseprefix + "manager set ");
stringBuilder.Append("role_id=@role_id,");
stringBuilder.Append("role_type=@role_type,");
stringBuilder.Append("user_name=@user_name,");
stringBuilder.Append("[password]=@password,");
stringBuilder.Append("real_name=@real_name,");
stringBuilder.Append("telephone=@telephone,");
stringBuilder.Append("email=@email,");
stringBuilder.Append("is_lock=@is_lock,");
stringBuilder.Append("add_time=@add_time");
stringBuilder.Append(" where id=@id");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[10]
{
new OleDbParameter("@role_id", OleDbType.Integer, 4),
new OleDbParameter("@role_type", OleDbType.Integer, 4),
new OleDbParameter("@user_name", OleDbType.VarChar, 100),
new OleDbParameter("@password", OleDbType.VarChar, 100),
new OleDbParameter("@real_name", OleDbType.VarChar, 50),
new OleDbParameter("@telephone", OleDbType.VarChar, 30),
new OleDbParameter("@email", OleDbType.VarChar, 30),
new OleDbParameter("@is_lock", OleDbType.Integer, 4),
new OleDbParameter("@add_time", OleDbType.Date),
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)model.role_id;
oleDbParameterArray[1].Value = (object)model.role_type;
oleDbParameterArray[2].Value = (object)model.user_name;
oleDbParameterArray[3].Value = (object)model.password;
oleDbParameterArray[4].Value = (object)model.real_name;
oleDbParameterArray[5].Value = (object)model.telephone;
oleDbParameterArray[6].Value = (object)model.email;
oleDbParameterArray[7].Value = (object)model.is_lock;
oleDbParameterArray[8].Value = (object)model.add_time;
oleDbParameterArray[9].Value = (object)model.id;
return(DbHelperOleDb.ExecuteSql(stringBuilder.ToString(), oleDbParameterArray) > 0);
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Page.IsPostBack)
{
return;
}
Rain.Model.manager adminInfo = this.GetAdminInfo();
if (adminInfo != null)
{
Rain.BLL.manager_log managerLog = new Rain.BLL.manager_log();
Rain.Model.manager_log model1 = managerLog.GetModel(adminInfo.user_name, 1, DTEnums.ActionEnum.Login.ToString());
if (model1 != null)
{
this.litIP.Text = model1.user_ip;
}
Rain.Model.manager_log model2 = managerLog.GetModel(adminInfo.user_name, 2, DTEnums.ActionEnum.Login.ToString());
if (model2 != null)
{
this.litBackIP.Text = model2.user_ip;
this.litBackTime.Text = model2.add_time.ToString();
}
}
}
private bool DoEdit(int _id)
{
bool flag = false;
Rain.BLL.manager manager = new Rain.BLL.manager();
Rain.Model.manager model = manager.GetModel(_id);
model.role_id = int.Parse(this.ddlRoleId.SelectedValue);
model.role_type = new Rain.BLL.manager_role().GetModel(model.role_id).role_type;
model.is_lock = !this.cbIsLock.Checked ? 1 : 0;
if (this.txtPassword.Text.Trim() != this.defaultpassword)
{
model.password = DESEncrypt.Encrypt(this.txtPassword.Text.Trim(), model.salt);
}
model.real_name = this.txtRealName.Text.Trim();
model.telephone = this.txtTelephone.Text.Trim();
model.email = this.txtEmail.Text.Trim();
if (manager.Update(model))
{
this.AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改管理员:" + model.user_name);
flag = true;
}
return(flag);
}
public bool Update(Rain.Model.manager model)
{
return(this.dal.Update(model));
}
public int Add(Rain.Model.manager model)
{
return(this.dal.Add(model));
}