private void btnConfirm_Click(object sender, EventArgs e)
{
var uid = txtUid.Text.Trim();
var pwd = txtPwd.Text.Trim();
if (string.IsNullOrEmpty(uid))
{
XtraMessageBox.Show("登录名不能为空!");
return;
}
if (string.IsNullOrEmpty(pwd))
{
XtraMessageBox.Show("密码不能为空!");
return;
}
//query from db
var db = ContextPool.GetContext();
var yh = db.T_YH.SingleOrDefault(o => o.F_YHBH == uid && o.F_YHMM == pwd);
if (yh == null)
{
XtraMessageBox.Show("用户命或密码不正确!");
return;
}
//success
DialogResult = DialogResult.Yes;
_authorizedUser = yh;
Close();
}
/// <summary>
/// 用户列表
/// </summary>
/// <param name="YHID"></param>
private void ShowInfo(int YHID)
{
T_YH model = new T_YH();
model = model.GetModel(YHID);
if (model != null)
{
this.txtDLZH.Text = model.DLZH;
this.txtYHMC.Text = model.YHMC;
this.txtDLMM.Text = model.DLMM;
}
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAdd_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtDLZH.Text == "")
{
strErr += "登录账户不能为空！\\n";
}
if (this.txtYHMC.Text == "")
{
strErr += "会员名称不能为空！\\n";
}
if (this.txtDLMM.Text == "")
{
strErr += "登录密码不能为空！\\n";
}
if (strErr != "")
{
ResponseMessage(this, strErr);
return;
}
string DLZH = this.txtDLZH.Text;
string YHMC = this.txtYHMC.Text;
string DLMM = this.txtDLMM.Text;
T_YH model = new T_YH();
model.DLZH = DLZH;
model.YHMC = YHMC;
model.DLMM = DLMM;
if (Request.Params["id"] != null && Request.Params["id"].Trim() != "")
{
//修改
model.YHID = Convert.ToInt32(Request.Params["id"]);
if (model.Update(model) <= 0)
{
ResponseMessage(this, "修改失败，系统错误！");
return;
}
}
else
{
if (model.Add(model) <= 0)
{
ResponseMessage(this, "添加用户失败，系统错误！");
return;
}
}
Response.Redirect("YHGL.aspx");
}
private static T_YH CreateYh(string yhm)
{
T_YH yh = new T_YH();
yh.F_YHM = yh.F_YHBH = yhm;
yh.F_YHMC = "平台用户_" + yhm;
yh.F_YHQX = 8;
yh.F_YHMM = yhm;
yh.F_SFZH = yh.F_DHHM = yh.F_FJH = yh.F_CXTS = yh.F_YH_BY1 = yh.F_YH_BY2 = "";
yh.F_DXFPYS = 0;
db.T_YH.Add(yh);
db.SaveChanges();
return(yh);
}
/// <summary>
/// 单击行事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
int num = int.Parse(e.CommandArgument.ToString());
if (e.CommandName == "Sel")
{
string strUrl = "ADDYH.aspx?id=" + gvData.DataKeys[num]["YHID"].ToString();
PageBase.OpenWebForm(strUrl);
}
else if (e.CommandName == "Del")
{
//删除记录
string strKey = gvData.DataKeys[num]["YHID"].ToString();
T_YH model = new T_YH();
if (model.Delete(int.Parse(strKey)) <= 0)
{
ResponseMessage(this.Page, "删除失败，请重试!");
return;
}
BindResult();
}
}
/// <summary>
///绑定列表
/// </summary>
private void BindResult()
{
//组合查询条件
string strSqlWhere = string.Empty;
if (this.ddlCXLX.SelectedValue.Trim() != "全部")
{
if (this.txtCXNR.Text != "")
{
strSqlWhere += " and " + this.ddlCXLX.SelectedValue.Trim() + " like '%" + this.txtCXNR.Text.Trim() + "%'";
}
}
T_YH modelList = new T_YH();
DataTable dt = modelList.GetList(strSqlWhere).Tables[0];
if (dt != null)
{
this.gvData.DataKeyNames = new string[] { "YHID" };
this.gvData.DataSource = dt;
this.gvData.DataBind();
ShowStats(dt.Rows.Count.ToString());
}
}
/// <summary>
/// 登录功能
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void IbtDL_Click(object sender, ImageClickEventArgs e)
{
LoginUser dlUser = new LoginUser();
//校验
if (this.txtUser.Text == "")
{
Alert("账户不能为空!");
return;
}
if (this.txtPwd.Text == "")
{
Alert("密码不能为空！");
return;
}
if (this.dlType.SelectedValue.Trim() == "管理")
{
T_ADMIN model = new T_ADMIN();
model = model.GetModelByName(this.txtUser.Text);
if (model == null)
{
ResponseMessage(this, "账户不存在！");
return;
}
if (model.ADMINMM != txtPwd.Text)
{
ResponseMessage(this, "密码错误，请查证后重新输入！");
return;
}
dlUser.JSID = 1;
dlUser.JSNAME = "超级管理员";
dlUser.Password = txtPwd.Text;
dlUser.ZH = txtUser.Text;
dlUser.ID = model.ADMINID;
dlUser.RealName = "超级管理员";
}
else if (dlType.SelectedValue.Trim() == "用户")
{
T_YH model = new T_YH();
model = model.GetModelByName(txtUser.Text);
if (model == null)
{
ResponseMessage(this, "账户不存在！");
return;
}
if (model.DLMM != txtPwd.Text)
{
ResponseMessage(this, "密码错误，请查证后重新输入！");
return;
}
dlUser.JSID = 2;
dlUser.JSNAME = "用户";
dlUser.Password = txtPwd.Text;
dlUser.ZH = txtUser.Text;
dlUser.ID = model.YHID;
dlUser.RealName = model.YHMC;
}
else
{
ResponseMessage(this, "登录类型错误！");
return;
}
Session["LoginUser"] = dlUser;
Response.Redirect("index.aspx");
}
