protected void btnLogon_Click(object sender, EventArgs e) { string username = txtName.Text.Trim().ToLower(); string password = txtPwd.Text.Trim().ToLower(); EnterpriseUser enterpriseUser = new EnterpriseUser(); enterpriseUser.Username = username; enterpriseUser.Password = password; EnterpriseUserBLL enterpriseBll = new EnterpriseUserBLL(); if (enterpriseBll.CheckLogin(enterpriseUser)) { if (txtValidate.Text.ToUpper().Equals(Session["CheckCode"].ToString())) { /*设置session变量username为用户名*/ Session["username"] = username; Session["EuserID"] = enterpriseBll.GetEnterpriseIdByUser(username); Session["usertype"] = "E";//E - 企业端,S-系统端,A-答题端 Session["userfullName"] = enterpriseBll.GetIncNameByUser(username); Response.Redirect("~/Enterprise/ManageActivity.aspx"); } else { MessageBox.ShowAndRedirect(this, "您输入的验证码有误,请重新输入!", "EnterpriseLogin.aspx"); } } else { MessageBox.ShowAndRedirect(this, "您输入的用户名称或者密码有误,请重新输入!", "EnterpriseLogin.aspx"); } }
private void load() { Model.EnterpriseUser account = (Model.EnterpriseUser)Session["Login"]; RPCResult <List <Model.EnterpriseUser> > r = ZHSMSProxy.GetZKD().GetLowerEnterprises(account.AccountCode); DataTable dt = CreateTable(); if (r.Success) { List <Model.EnterpriseUser> accounts = r.Value; if (accounts.Count > 0) { foreach (Model.EnterpriseUser a in accounts) { DataRow dr = dt.NewRow(); dr["accountID"] = a.AccountID; dr["code"] = a.AccountCode; dr["name"] = a.Name; dr["contact"] = a.Contact; dr["phone"] = a.Phone; dr["address"] = a.Address; dt.Rows.Add(dr); } } GridView1.DataSource = dt; GridView1.DataBind(); Session["dt"] = dt; } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(EnterpriseUser model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into ExamDB.dbo.tb_EnterpriseUsers("); strSql.Append(@"users_name, users_pwd, users_incname, users_contact, users_phone, users_address, users_firstlogontime, users_availablemoney, users_totalconsumemoney)"); strSql.Append(" values ("); strSql.Append(@"@users_name, @users_pwd, @users_incname, @users_contact, @users_phone, @users_address, @users_firstlogontime, @users_availablemoney, @users_totalconsumemoney)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@users_name", SqlDbType.NVarChar,255), new SqlParameter("@users_pwd", SqlDbType.NChar,255), new SqlParameter("@users_incname", SqlDbType.NVarChar,255), new SqlParameter("@users_contact", SqlDbType.NVarChar,255), new SqlParameter("@users_phone",SqlDbType.NVarChar,255), new SqlParameter("@users_address", SqlDbType.NVarChar,255), new SqlParameter("@users_firstlogontime", SqlDbType.DateTime), new SqlParameter("@users_availablemoney", SqlDbType.Float), new SqlParameter("@users_totalconsumemoney", SqlDbType.Float) }; parameters[0].Value = model.Username; parameters[1].Value = Encrypt(model.Password); parameters[2].Value = model.Users_incname; parameters[3].Value = model.Users_contact; parameters[4].Value = model.Users_phone; parameters[5].Value = model.Users_address; parameters[6].Value = model.Users_firstlogon; parameters[7].Value = model.Users_availablemoney; parameters[8].Value = model.Users_totalconsumemoney; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return -1; } else { return Convert.ToInt32(obj); } }
protected void btnChange_Click(object sender, EventArgs e) { EnterpriseUser temp = new EnterpriseUser(); temp.Username = lblUserName.Text.Trim(); temp.Users_incname = lblCoName.Text.Trim(); // temp.Users_address = txtbAddress.Text.Trim(); temp.Users_contact = txtbContact.Text.Trim(); temp.Users_phone = txtbPhone.Text.Trim(); temp.Users_scale = ddlCoScale.SelectedValue; temp.Users_type = ddlCoType.SelectedValue; if (m_EnterpriseUserBll.UpdateContact(temp) > 0) { MessageBox.ShowAndRedirect(this, "修改成功", "ManageActivity.aspx"); } }
/// <summary> /// 获得数据列表 /// </summary> public List<EnterpriseUser> GetModelList(string strWhere) { DataSet ds = EnterpriseUserDAL.GetListAll(); List<EnterpriseUser> modelList = new List<EnterpriseUser>(); int rowsCount = ds.Tables[0].Rows.Count; if (rowsCount > 0) { EnterpriseUser model; for (int n = 0; n < rowsCount; n++) { model = new EnterpriseUser(); //TODO: ADD MODEL modelList.Add(model); } } return modelList; }
/// <summary> /// 判断登录 /// </summary> public bool CheckLogin(EnterpriseUser enterpriseUser) { return EnterpriseUserDAL.CheckLogin(enterpriseUser); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(EnterpriseUser model) { return EnterpriseUserDAL.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public int UpdateContact(EnterpriseUser model) { return EnterpriseUserDAL.UpdateContact(model); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(EnterpriseUser model) { return EnterpriseUserDAL.Update(model); }
/// <summary> /// 判断登录 /// </summary> public static bool CheckLogin(EnterpriseUser enterpriseUser) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from ExamDB.dbo.tb_EnterpriseUsers"); strSql.Append(" where users_name=@Username"); strSql.Append(" and users_pwd=@Password"); SqlParameter[] parameters ={ new SqlParameter("@Username",SqlDbType.VarChar,255), new SqlParameter("@Password",SqlDbType.VarChar,255)}; parameters[0].Value = enterpriseUser.Username; parameters[1].Value = Encrypt(enterpriseUser.Password); return DbHelperSQL.Exists(strSql.ToString(), parameters); }
/// <summary> /// 更新联系信息 /// </summary> public static int UpdateContact(EnterpriseUser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ExamDB.dbo.tb_EnterpriseUsers set "); strSql.Append("users_incname=@users_incname,"); strSql.Append("users_contact=@users_contact,"); strSql.Append("users_phone=@users_phone,"); strSql.Append("users_address=@users_address,"); strSql.Append("users_type=@users_type,"); strSql.Append("users_scale=@users_scale"); strSql.Append(" where users_name=@users_name "); SqlParameter[] parameters = { new SqlParameter("@users_incname", SqlDbType.NVarChar,255), new SqlParameter("@users_contact", SqlDbType.NVarChar,255), new SqlParameter("@users_phone", SqlDbType.NChar,255), new SqlParameter("@users_address", SqlDbType.NVarChar,255), new SqlParameter("@users_type", SqlDbType.NVarChar,10), new SqlParameter("@users_scale",SqlDbType.NVarChar,10), new SqlParameter("@users_name", SqlDbType.NVarChar,255)}; parameters[0].Value = model.Users_incname; parameters[1].Value = model.Users_contact; parameters[2].Value = model.Users_phone; parameters[3].Value = model.Users_address; parameters[4].Value = model.Users_type; parameters[5].Value = model.Users_scale; parameters[6].Value = model.Username; return DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public static int Update(EnterpriseUser model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update ExamDB.dbo.tb_EnterpriseUsers set "); strSql.Append("users_name=@users_name,"); strSql.Append("users_pwd=@users_pwd,"); strSql.Append("users_incname=@users_incname,"); strSql.Append("users_contact=@users_contact,"); strSql.Append("users_phone=@users_phone,"); strSql.Append("users_address=@users_address"); strSql.Append(" where users_id=@users_id "); SqlParameter[] parameters = { new SqlParameter("@users_id", SqlDbType.Int,4), new SqlParameter("@users_name", SqlDbType.NVarChar,255), new SqlParameter("@users_pwd", SqlDbType.NChar,255), new SqlParameter("@users_incname", SqlDbType.NVarChar,255), new SqlParameter("@users_contact", SqlDbType.NVarChar,255), new SqlParameter("@users_phone",SqlDbType.NVarChar,255), new SqlParameter("@users_address", SqlDbType.NVarChar,255)}; parameters[0].Value = model.Id; parameters[1].Value = model.Username; parameters[2].Value = Encrypt(model.Password); parameters[3].Value = model.Users_incname; parameters[4].Value = model.Users_contact; parameters[5].Value = model.Users_phone; parameters[6].Value = model.Users_address; return DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public static EnterpriseUser GetModel(int ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 * from ExamDB.dbo.tb_EnterpriseUsers"); strSql.Append(" where users_id=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4)}; parameters[0].Value = ID; EnterpriseUser model=new EnterpriseUser(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if (ds.Tables[0].Rows[0]["users_id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["users_id"].ToString()); } model.Username = ds.Tables[0].Rows[0]["users_name"].ToString(); model.Password = ds.Tables[0].Rows[0]["users_pwd"].ToString(); model.Users_incname=ds.Tables[0].Rows[0]["users_incname"].ToString(); model.Users_contact = ds.Tables[0].Rows[0]["users_contact"].ToString(); model.Users_phone = ds.Tables[0].Rows[0]["users_phone"].ToString(); model.Users_address = ds.Tables[0].Rows[0]["users_address"].ToString(); model.Users_availablemoney = float.Parse(ds.Tables[0].Rows[0]["users_availablemoney"].ToString()); if (ds.Tables[0].Rows[0]["users_firstlogontime"].ToString() != "") { model.Users_firstlogon = DateTime.Parse(ds.Tables[0].Rows[0]["users_firstlogontime"].ToString()); } model.Users_totalconsumemoney = float.Parse(ds.Tables[0].Rows[0]["users_totalconsumemoney"].ToString()); model.Users_scale = ds.Tables[0].Rows[0]["users_scale"].ToString(); model.Users_type = ds.Tables[0].Rows[0]["users_type"].ToString(); return model; } else { return null; } }
protected void btnSave_Click(object sender, EventArgs e) { int userId = 0; if (Request.QueryString["users_id"] != null) { userId = int.Parse(Request.QueryString["users_id"]); } // *验证用户输入的信息*/ if (string.IsNullOrEmpty(UserName.Text)) { MessageBox.ResponseScript(this, "您好,请填写用户名!"); } if (string.IsNullOrEmpty(Password.Text)) { MessageBox.ResponseScript(this, "您好,请填写密码!"); } if (string.IsNullOrEmpty(CompanyName.Text)) { MessageBox.ResponseScript(this, "您好,请填写公司名称!"); } EnterpriseUserBLL enterpriseUserBll = new EnterpriseUserBLL(); EnterpriseUser enterpriseUser = new EnterpriseUser(); if (0 == userId) { if (enterpriseUserBll.Exists(UserName.Text.Trim().ToLower())) { MessageBox.ShowAndRedirect(this, "用户添加失败:此用户名已存在", "AddEnterpriseUser.aspx"); return; } enterpriseUser.Username = UserName.Text.Trim().ToLower(); enterpriseUser.Users_incname = CompanyName.Text.Trim(); enterpriseUser.Password = Password.Text.Trim().ToLower(); enterpriseUser.Users_phone = txtbPhone.Text.Trim(); enterpriseUser.Users_contact = txtbContact.Text.Trim(); if (enterpriseUserBll.Add(enterpriseUser) != -1) { MessageBox.ShowAndRedirect(this, "企业用户添加成功", "EnterpriseUserList.aspx"); } else { MessageBox.ShowAndRedirect(this, "企业用户添加失败", "EnterpriseUserList.aspx"); } } else { enterpriseUser.Id = userId; enterpriseUser.Username = UserName.Text.Trim(); enterpriseUser.Users_incname = CompanyName.Text.Trim(); enterpriseUser.Password = Password.Text.Trim(); enterpriseUser.Users_phone = txtbPhone.Text.Trim(); enterpriseUser.Users_contact = txtbContact.Text.Trim(); if (enterpriseUserBll.Update(enterpriseUser) == 1) { MessageBox.ShowAndRedirect(this, "企业用户修改成功", "EnterpriseUserList.aspx"); } else { MessageBox.ShowAndRedirect(this, "企业用户修改失败", "EnterpriseUserList.aspx"); } } }