/// <summary> /// 添加部门(确定按钮) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ImageButton1_Click(object sender, EventArgs e) { try { if (TextBox1.Text.Trim() != "") { Maticsoft.Model.Department bumen = new Model.Department(); bumen.departmentname = TextBox1.Text.Trim(); bumen.Beizhu = TextBox2.Text.Trim(); int a = dep.Add(bumen); if (a > 0) { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('添加成功!');</script>"); bind(sql); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('添加失败!');</script>"); bind(sql); } } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('部门名称不能为空!');</script>"); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>javascript:showDiv1();</script>"); } } catch (Exception ee) { //Response.Write("<script>alert('确定异常 " + ee.Message + "')</script>"); ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('确定异常 " + ee.Message + "');</script>"); } }
/// <summary> /// 用户中心登陆 /// </summary> /// <returns></returns> public ActionResult UserCenterLogin() { ConfigurationHelper config = new ConfigurationHelper(); string WebUrl = config.getConfigName("WebUrl"); string token = Request.QueryString["token"]?.ToString(); DataTable dt = null; if (!string.IsNullOrEmpty(token)) { token = HttpUtility.UrlEncode(token, System.Text.Encoding.UTF8); token = Setpassword.get_password_ASC(HttpUtility.UrlDecode(token)); dt = JsonConvert.DeserializeObject(token, typeof(DataTable)) as DataTable; } if (dt != null && dt.Rows.Count > 0)//表示token能解析出对象 { DateTime time = Convert.ToDateTime(dt.Rows[0]["CreateDate"]); if (time.Date == DateTime.Now.Date) { DataTable userTable = BUserInfo.GetList("UrGuid='" + dt.Rows[0]["UserGuid"].ToString() + "'").Tables[0]; //处理dt if (userTable.Rows.Count > 0)//如果存在这个guid 表示用户存在 { //存在还要判断数据是否有被修改 int companyId = Convert.ToInt32(dt.Rows[0]["CompanyID"]); string companyName = dt.Rows[0]["CompanyName"].ToString(); //先开始判断公司 MCompany = BCompany.GetModel(companyId); if (MCompany == null) { //创建公司 MCompany = new Maticsoft.Model.Company() { Id = companyId, Name = companyName }; BCompany.Add(MCompany); } else//表示存在公司 { if (MCompany.Name != companyName)//表示数据更改 { string sql = "update company set Name=@Name where Id=@Id"; SqlParameter[] paras = { new SqlParameter("@Name", companyName), new SqlParameter("@Id", companyId) }; DbHelperSQL.ExecuteSql(sql, paras); } } int departmentId = Convert.ToInt32(dt.Rows[0]["DepartmentID"]); int newDepartmentId = 0; string departmentName = dt.Rows[0]["DepartmentName"].ToString(); DataTable departmentTable = BDepartment.GetList("UcDepartmentId = " + departmentId).Tables[0]; if (departmentTable.Rows.Count > 0)//表示已经存在部门 { newDepartmentId = Convert.ToInt32(departmentTable.Rows[0]["ID"]); if (departmentTable.Rows[0]["Name"].ToString() != departmentName || departmentTable.Rows[0]["CpId"].ToString() != companyId.ToString())//表示部门名称更改,更新部门名称 { string sql = "update Department set UcDepartmentId=@UcDepartmentId,Name=@Name,CpId=@CpId where Id=@Id"; SqlParameter[] paras = { new SqlParameter("@UcDepartmentId", departmentId), new SqlParameter("@CpId", companyId), new SqlParameter("@Name", departmentName), new SqlParameter("@Id", newDepartmentId) }; DbHelperSQL.ExecuteSql(sql, paras); } } else { //不存在部门,新增 MDepartment = new Maticsoft.Model.Department() { CpId = companyId, UcDepartmentId = departmentId, Name = departmentName }; newDepartmentId = BDepartment.Add(MDepartment); } //处理用户 if (userTable.Rows[0]["UserName"].ToString() != dt.Rows[0]["UserPhone"].ToString() || dt.Rows[0]["UserName"].ToString() != userTable.Rows[0]["TrueName"].ToString() || Convert.ToInt32(userTable.Rows[0]["DepartmentId"]) != newDepartmentId || userTable.Rows[0]["HeadImage"].ToString() != dt.Rows[0]["UserHeadImage"].ToString()) { //表示用户信息有被更改 string sql = "update Userinfo set UserName=@UserName,TrueName=@TrueName,DepartmentId=@DepartmentId,HeadImage=@HeadImage where Id=@Id"; SqlParameter[] paras = { new SqlParameter("@UserName", dt.Rows[0]["UserPhone"].ToString()), new SqlParameter("@TrueName", dt.Rows[0]["UserName"].ToString()), new SqlParameter("@HeadImage", dt.Rows[0]["UserHeadImage"].ToString()), new SqlParameter("@DepartmentId", newDepartmentId), new SqlParameter("@Id", Convert.ToInt32(userTable.Rows[0]["ID"])) }; DbHelperSQL.ExecuteSql(sql, paras); } string name = userTable.Rows[0]["TrueName"].ToString(); string ID = userTable.Rows[0]["ID"].ToString(); string RoleID = userTable.Rows[0]["RoleID"].ToString(); Session.Add("UserInfoID", ID); Session.Add("TrueName", name); Session.Add("RoleID", RoleID); Session.Timeout = 40; return(RedirectToAction("Index", "Window")); //string ID = userTable.Rows[0]["ID"].ToString(); //Session.Add("UserInfoID", ID); //Session.Add("RoleID", 3);//默认都是反馈人员 //Session.Add("TrueName", MUserInfo.TrueName); //Session.Timeout = 40; //return RedirectToAction("Index", "Window"); } else //表示不存在这个用户 { int companyId = Convert.ToInt32(dt.Rows[0]["CompanyID"]); string companyName = dt.Rows[0]["CompanyName"].ToString(); //先开始判断公司 MCompany = BCompany.GetModel(companyId); if (MCompany == null) { //创建公司 MCompany = new Maticsoft.Model.Company() { Id = companyId, Name = companyName }; BCompany.Add(MCompany); } else//表示存在公司 { if (MCompany.Name != companyName)//表示数据更改 { string sql = "update company set Name=@Name where Id=@Id"; SqlParameter[] paras = { new SqlParameter("@Name", companyName), new SqlParameter("@Id", companyId) }; DbHelperSQL.ExecuteSql(sql, paras); } } int departmentId = Convert.ToInt32(dt.Rows[0]["DepartmentID"]); int newDepartmentId = 0; string departmentName = dt.Rows[0]["DepartmentName"].ToString(); DataTable departmentTable = BDepartment.GetList("UcDepartmentId = " + departmentId).Tables[0]; if (departmentTable.Rows.Count > 0)//表示已经存在部门 { newDepartmentId = Convert.ToInt32(departmentTable.Rows[0]["ID"]); if (departmentTable.Rows[0]["Name"].ToString() != departmentName || departmentTable.Rows[0]["CpId"].ToString() != companyId.ToString())//表示部门名称更改,更新部门名称 { string sql = "update Department set UcDepartmentId=@UcDepartmentId,Name=@Name,CpId=@CpId where Id=@Id"; SqlParameter[] paras = { new SqlParameter("@UcDepartmentId", departmentId), new SqlParameter("@Name", departmentName), new SqlParameter("@CpId", companyId), new SqlParameter("@Id", newDepartmentId) }; DbHelperSQL.ExecuteSql(sql, paras); } } else { //不存在部门,新增 MDepartment = new Maticsoft.Model.Department() { CpId = companyId, UcDepartmentId = departmentId, Name = departmentName }; newDepartmentId = BDepartment.Add(MDepartment); } //创建用户 MUserInfo.ParentID = 1; //默认上级是超级管理员 MUserInfo.Password = ""; // password.set_password_ASC("888888"); MUserInfo.PrivilegeID = "17"; //默认权限 MUserInfo.RoleID = 3; MUserInfo.status = Convert.ToInt32(1); MUserInfo.Time = System.DateTime.Now; MUserInfo.UserFrom = "ERP-User"; MUserInfo.DepartmentID = newDepartmentId; MUserInfo.TrueName = dt.Rows[0]["UserName"].ToString(); //用户真实姓名 MUserInfo.UserName = dt.Rows[0]["UserPhone"].ToString(); //用户昵称,就是手机号 MUserInfo.UrGuid = dt.Rows[0]["UserGuid"].ToString(); MUserInfo.HeadImage = dt.Rows[0]["UserHeadImage"].ToString(); int check = BUserInfo.Add(MUserInfo); if (check > 0) { Session.Add("UserInfoID", check); Session.Add("RoleID", 3);//默认都是反馈人员 Session.Add("TrueName", MUserInfo.TrueName); Session.Timeout = 40; return(RedirectToAction("Index", "Window")); } else { return(RedirectToAction("Login", "Window")); } } } else { return(RedirectToAction("Login", "Window")); } } else { return(RedirectToAction("Login", "Window")); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtdepartmentname.Text.Trim().Length == 0) { strErr += "departmentname不能为空!\\n"; } if (this.txtBeizhu.Text.Trim().Length == 0) { strErr += "Beizhu不能为空!\\n"; } if (!PageValidate.IsDecimal(txtBY1.Text)) { strErr += "BY1格式错误!\\n"; } if (!PageValidate.IsDecimal(txtBY2.Text)) { strErr += "BY2格式错误!\\n"; } if (!PageValidate.IsDecimal(txtBY3.Text)) { strErr += "BY3格式错误!\\n"; } if (this.txtBY4.Text.Trim().Length == 0) { strErr += "BY4不能为空!\\n"; } if (this.txtBY5.Text.Trim().Length == 0) { strErr += "BY5不能为空!\\n"; } if (this.txtBY6.Text.Trim().Length == 0) { strErr += "BY6不能为空!\\n"; } if (this.txtBY7.Text.Trim().Length == 0) { strErr += "BY7不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string departmentname = this.txtdepartmentname.Text; string Beizhu = this.txtBeizhu.Text; decimal BY1 = decimal.Parse(this.txtBY1.Text); decimal BY2 = decimal.Parse(this.txtBY2.Text); decimal BY3 = decimal.Parse(this.txtBY3.Text); string BY4 = this.txtBY4.Text; string BY5 = this.txtBY5.Text; string BY6 = this.txtBY6.Text; string BY7 = this.txtBY7.Text; Maticsoft.Model.Department model = new Maticsoft.Model.Department(); model.departmentname = departmentname; model.Beizhu = Beizhu; model.BY1 = BY1; model.BY2 = BY2; model.BY3 = BY3; model.BY4 = BY4; model.BY5 = BY5; model.BY6 = BY6; model.BY7 = BY7; Maticsoft.BLL.Department bll = new Maticsoft.BLL.Department(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }