public IActionResult add(Vm_User us) { if (us.UserNameUs == "admin") { eror = "Input name is not acceptable"; return(RedirectToAction("register")); } if (us.PasswordUs != us.repass) { eror = "The passwords entered do not match"; return(RedirectToAction("register")); } else if (db.Tbl_User.Any(a => a.PhoneUs == us.PhoneUs)) { eror = "The phone number in question has already been registered"; return(RedirectToAction("register")); } else { Tb_User tb = new Tb_User() { UserNameUs = us.UserNameUs, PasswordUs = us.PasswordUs, PhoneUs = us.PhoneUs }; db.Tbl_User.Add(tb); db.SaveChanges(); suc = "Registration completed successfully"; return(RedirectToAction("register")); } }
public IActionResult add(Vm_User us) { if (us.UserNameUs == "admin") { eror = "Giriş adı kabul edilmiyor "; return(RedirectToAction("register")); } if (us.PasswordUs != us.repass) { eror = "Girilen şifreler uyuşmuyor "; return(RedirectToAction("register")); } else if (db.Tbl_User.Any(a => a.PhoneUs == us.PhoneUs)) { eror = "İstenen telefon numarası zaten kayıtlı "; return(RedirectToAction("register")); } else { Tb_User tb = new Tb_User() { UserNameUs = us.UserNameUs, PasswordUs = us.PasswordUs, PhoneUs = us.PhoneUs }; db.Tbl_User.Add(tb); db.SaveChanges(); suc = "Kayıt başarıyla tamamlandı"; return(RedirectToAction("register")); } }
public IActionResult add(Vm_User us) { if (us.UserNameUs == "admin") { eror = "اسم الإدخال غير مقبول "; return(RedirectToAction("register")); } if (us.PasswordUs != us.repass) { eror = "كلمات السر التي تم ادخالها غير مطابقة "; return(RedirectToAction("register")); } else if (db.Tbl_User.Any(a => a.PhoneUs == us.PhoneUs)) { eror = "رقم الهاتف ذو الصلة مسجل بالفعل "; return(RedirectToAction("register")); } else { Tb_User tb = new Tb_User() { UserNameUs = us.UserNameUs, PasswordUs = us.PasswordUs, PhoneUs = us.PhoneUs }; db.Tbl_User.Add(tb); db.SaveChanges(); suc = "تم التسجيل بنجاح"; return(RedirectToAction("register")); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["Glb_Tb_User"] == null) { Response.Redirect("~/Login.aspx"); } Tb_User1 = Session["Glb_Tb_User"] as Tb_User; (Master.FindControl("Lbl_Title") as Label).Text = "ثبت دارایی های متوفی"; Txt_Hozeh.Text = Tb_User1.xUser_Hozeh; if (!IsPostBack) { Hfld_Command.Value = "Save"; } if (!IsPostBack) { if (Session["Classe"] != null) { Txt_Klasse.Text = Session["Classe"].ToString(); Session.RemoveAll(); Session["Glb_Tb_User"] = Tb_User1; Session["Classe"] = Txt_Klasse.Text; Btn_Search_Click(sender, e); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["Glb_Tb_User"] == null) { Response.Redirect("~/Login.aspx"); } Tb_User1 = Session["Glb_Tb_User"] as Tb_User; (Master.FindControl("Lbl_Title") as Label).Text = "ثبت اطلاعات فرم درخواست"; Txt_Hozeh.Text = Tb_User1.xUser_Hozeh; if (!IsPostBack) { if (Session["Classe"] != null) { Txt_Klasse.Text = Session["Classe"].ToString(); Session.RemoveAll(); Session["Glb_Tb_User"] = Tb_User1; Session["Classe"] = Txt_Klasse.Text; Btn_Search_Click(sender, e); } } #region ddl_Load if (!IsPostBack) { Txt_Hozeh.Text = Tb_User1.xUser_Hozeh; } #endregion }
/// <summary> /// 读取当前魔蓝成员信息 /// </summary> /// <param name="row"></param> /// <returns></returns> private string GetMoredianMember(DataRow row) { try { #region 获取参数并简单校验 string Mobile = string.Empty; if (row.Table.Columns.Contains("Mobile")) { Mobile = row["Mobile"].ToString(); } if (string.IsNullOrEmpty(Mobile)) { return(new WxResponse(0, "用户不存在", null).toJson()); } if (Mobile.Length != 11) { return(new WxResponse(0, "用户不存在", null).toJson()); } DateTime DateNow = DateTime.Now; #endregion using (IDbConnection conn = new SqlConnection(PubConstant.WChat2020ConnectionString), erpConn = new SqlConnection(erpConnStr)) { #region 查询用户信息 Tb_User tb_User = conn.QueryFirstOrDefault <Tb_User>("SELECT * FROM Tb_User WITH(NOLOCK) WHERE Mobile = @Mobile", new { Mobile }); if (null == tb_User) { return(new WxResponse(0, "用户不存在", null).toJson()); } #endregion #region 获取AppToken TianChengEntranceSyncService.Config.EntranceConnectionStr = erpConnStr; TianChengEntranceSyncService.Config.WChat2020ConnectionStr = PubConstant.WChat2020ConnectionString; string app_token = AppTokenRedis.GetAppToken(); if (string.IsNullOrEmpty(app_token)) { return(new WxResponse(0, "获取AppToken失败,请联系管理员", null).toJson()); } #endregion // 成员信息不存在,进行创建 #region 先查询/创建组织机构 MoredianOrg moredianOrg = OrgRedis.GetMoredianOrg(); if (null == moredianOrg) { return(new WxResponse(0, "组织机构配置错误,请联系管理员", null).toJson()); } #endregion #region 查询人员信息 MoredianMember moredianMember = MemberRedis.GetMoredianMember(Mobile); #endregion return(new WxResponse(200, "获取成功", moredianMember).toJson()); } } catch (Exception ex) { GetLog().Error(ex.Message + Environment.CommandLine + ex.StackTrace); return(new WxResponse(0, "响应异常", null).toJson()); } }
protected override void OnActionExecuting(ActionExecutingContext filterContext) { var userReq = System.Web.HttpContext.Current.User as CustomPrincipal; int userid = userReq != null ? userReq.UserID : 0; string controller = System.Web.HttpContext.Current.Request.RequestContext.RouteData.Values["controller"].ToString().ToLower(); string action = System.Web.HttpContext.Current.Request.RequestContext.RouteData.Values["action"].ToString().ToLower(); var actionlist = new string[] { "login", "loginload", "registersave", "acs", "sls", "redirectsso" }; if (!actionlist.Contains(action)) { using (var db = new Student_AttendanceEntities()) { UserLogon = db.Tb_User.Where(r => r.UserID == userid).FirstOrDefault(); UserIsLogin = db.Tb_Login.Where(r => r.UserID == userid).FirstOrDefault(); } Session.Timeout = 20; Session["sessionID"] = HttpContext.Session.SessionID; var sessionid = Session["sessionID"].ToString(); if (UserLogon == null || UserIsLogin.sessionID != sessionid) { //string urlLogout = "http://cpe.rmuti.ac.th/project/StudentAttendance/Login/Logout"; //filterContext.Result = new RedirectResult("~/Login/Login"); filterContext.Result = new RedirectResult(MainUrl); } else { if (UserLogon.Role == "user" && controller.ToLower() == "admin") { filterContext.Result = new RedirectResult(MainUrl + "/Home/index"); } } } base.OnActionExecuting(filterContext); }
/* public Tb_UserInfo GetUserInfo(string userName) * { * var cmd = new DataCommand(); * var findIt = cmd.Search<Tb_User>(x => x.Name.Equals(userName)); * var info=cmd.Search<Tb_UserInfo>(x => x.UserId==findIt.Id); * return info; * }*/ public void AddUser(Tb_User user, string phone) { var db = new MySqlContext(); db.TbUsers.Add(user); db.SaveChanges(); }
/// <summary> /// 修改密码 /// </summary> /// <param name="row"></param> /// Mobile 手机号【必填】 /// Pwd 密码【必填】 /// 返回: /// true:密码修改成功 /// false:错误信息 /// <returns></returns> private string UpdateUserPwd(DataRow row) { if (!row.Table.Columns.Contains("Mobile") || string.IsNullOrEmpty(row["Mobile"].ToString())) { return(JSONHelper.FromString(false, "手机号不能为空")); } if (!row.Table.Columns.Contains("Pwd") || string.IsNullOrEmpty(row["Pwd"].ToString())) { return(JSONHelper.FromString(false, "密码不能为空")); } IDbConnection Connectionstr = new SqlConnection(Connection.GetConnection("4")); string Sql = "SELECT * FROM Tb_User where Mobile=@Mobile"; Tb_User user = Connectionstr.Query <Tb_User>(Sql, new { Mobile = row["Mobile"].ToString() }).SingleOrDefault(); if (user == null) { return(JSONHelper.FromString(false, "该用户不存在")); } else { user.Pwd = row["Pwd"].ToString(); Connectionstr.Update(user); return(JSONHelper.FromString(true, "密码修改成功")); } }
public IActionResult add(Vm_User us) { if (us.UserNameUs == "admin") { eror = "نام ورودی غیر قابل قبول است "; return(RedirectToAction("register")); } if (us.PasswordUs != us.repass) { eror = "رمز های وارد شده با هم مطابقت ندارند "; return(RedirectToAction("register")); } else if (db.Tbl_User.Any(a => a.PhoneUs == us.PhoneUs)) { eror = "شماره تلفن مورد نظر قبلا ثبت شده است "; return(RedirectToAction("register")); } else { Tb_User tb = new Tb_User() { UserNameUs = us.UserNameUs, PasswordUs = us.PasswordUs, PhoneUs = us.PhoneUs }; db.Tbl_User.Add(tb); db.SaveChanges(); suc = "ثبت نام با موفقیت انجام شد"; return(RedirectToAction("register")); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["Glb_Tb_User"] == null) { Response.Redirect("~/Login.aspx"); } (Master.FindControl("Lbl_Title") as Label).Text = "استعلام از بانک / موسسه"; Lts_InheritedDataContext Lts_Inherited = new Lts_InheritedDataContext(); Tb_User Tb_User1 = Session["Glb_Tb_User"] as Tb_User; int DedId = int.Parse(Session["Bank_DeadId"].ToString()); Tb_Dead Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedId_pk == DedId); Rptv_InqBank.LocalReport.ReportPath = Server.MapPath("~/Int_Inquiries/Bank/Rpt_Bank.rdlc"); Rptv_InqBank.LocalReport.Refresh(); ReportParameter[] ReportParameter = new ReportParameter[8]; ReportParameter[0] = new ReportParameter("DedName", Tb_Dead1.xDedFName + " " + Tb_Dead1.xDedLName); ReportParameter[1] = new ReportParameter("dedNationalcode", Tb_Dead1.xDedNationalCode); ReportParameter[2] = new ReportParameter("DedFotDate", Tb_Dead1.xDedDeadDate); ReportParameter[3] = new ReportParameter("UserName", Tb_User1.xUserFName + " " + Tb_User1.xUserLName); ReportParameter[4] = new ReportParameter("Inq_date", Session["Bank_InqDate"].ToString()); ReportParameter[5] = new ReportParameter("Inq_RegNo", Session["Bank_InqNo"].ToString()); ReportParameter[6] = new ReportParameter("Hozeh", Tb_User1.xUser_Hozeh); ReportParameter[7] = new ReportParameter("Bank_Name", Session["Bank_Name"].ToString()); Rptv_InqBank.LocalReport.SetParameters(ReportParameter); Rptv_InqBank.LocalReport.Refresh(); }
public ActionResult GetItem() { BaseResult br = new BaseResult(); try { Hashtable param = new Hashtable(); param.Add("id", GetLoginInfo <long>("id_user")); param.Add("picuri", String.Format("{0}://{1}", Request.Url.Scheme, Request.Url.Authority)); br = BusinessFactory.Account.Get(param); var uri = String.Format("{0}://{1}", Request.Url.Scheme, Request.Url.Authority); if (br.Data != null) { Tb_User user = (Tb_User)br.Data; var id_master = GetLoginInfo <long>("id_user_master"); //if (string.IsNullOrEmpty(user.pic_erwei)) //{ // string filename = "erwei_" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".jpg"; // string filepath = Server.MapPath("~\\UpLoad\\User\\Master") + "\\" + filename; // var destImg = string.Empty; // if (!string.IsNullOrEmpty(user.pic)) // destImg = Server.MapPath(user.pic.Replace(uri, "")); //@"~\Images\\eweilogo.png"); // else // destImg = Server.MapPath(@"~\Images\\eweilogo.png"); // var id_des = DESEncrypt.EncryptDES(id_master.ToString()); // var id = Base64Encrypt.EncodeBase64(id_des); // var data = param["picuri"] + "/ServiceCustomer/Scan/" + id; // QRCode.CreatQRCode(destImg, data, filepath); // user.pic_erwei = "/UpLoad/User/Master/" + filename; // param.Clear(); // param.Add("id", GetLoginInfo<long>("id_user")); // param.Add("id_user", GetLoginInfo<long>("id_user")); // param.Add("id_user_master", GetLoginInfo<string>("id_user_master")); // param.Add("flag_from", GetLoginInfo<string>("flag_from")); // param.Add("pic_erwei", user.pic_erwei); // br = BusinessFactory.Account.Save(param); //} //user.pic_erwei = uri + user.pic_erwei; //br.Data = new { user.id, user.name, user.job, user.phone, user.email, user.qq, user.pic, user.pic_erwei }; br.Data = new { user.id, user.name, user.job, user.phone, user.email, user.qq }; } } catch (CySoftException ex) { throw ex; } catch (Exception ex) { throw ex; } return(Json(br)); }
private static Tb_User GetUser(DataRow dr, Tb_User user) { if (dr.Table.Columns.Contains("Name")) { user.Name = dr["Name"].ToString(); } if (dr.Table.Columns.Contains("Birthday")) { user.Birthday = dr["Birthday"].ToString(); } if (dr.Table.Columns.Contains("Mobile")) { user.Mobile = dr["Mobile"].ToString(); } if (dr.Table.Columns.Contains("Email")) { user.Email = dr["Email"].ToString(); } if (dr.Table.Columns.Contains("QQ")) { user.QQ = dr["QQ"].ToString(); } if (dr.Table.Columns.Contains("QQToken")) { user.QQToken = dr["QQToken"].ToString(); } if (dr.Table.Columns.Contains("WeChatNum")) { user.WeChatNum = dr["WeChatNum"].ToString(); } if (dr.Table.Columns.Contains("WeChatToken")) { user.WeChatToken = dr["WeChatToken"].ToString(); } if (dr.Table.Columns.Contains("NickName")) { user.NickName = dr["NickName"].ToString(); } if (dr.Table.Columns.Contains("Pwd")) { user.Pwd = dr["Pwd"].ToString(); } if (dr.Table.Columns.Contains("UserPic")) { user.UserPic = dr["UserPic"].ToString(); } if (dr.Table.Columns.Contains("Sex")) { user.Sex = AppGlobal.StrToInt(dr["Sex"].ToString()); } if (dr.Table.Columns.Contains("RegDate")) { user.RegDate = AppGlobal.StrToDate(dr["RegDate"].ToString()); } return(user); }
protected void Page_Load(object sender, EventArgs e) { if (Session["Glb_Tb_User"] == null) { Response.Redirect("~/Login.aspx"); } (Master.FindControl("Lbl_Title") as Label).Text = "استعلام از اداره امور مالیاتی"; Lts_InheritedDataContext Lts_Inherited = new Lts_InheritedDataContext(); Tb_User Tb_User1 = Session["Glb_Tb_User"] as Tb_User; int DedId = int.Parse(Session["Office_DeadId"].ToString()); Tb_Dead Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedId_pk == DedId); List <string> Lst_Estates = new List <string>(); Lst_Estates = Session["Office_EstateId"].ToString().Split('&').ToList(); Lst_Estates.RemoveAt(Lst_Estates.Count - 1); List <Inq_AsnadResult> Lst_Inq_Asnad = new List <Inq_AsnadResult>(); foreach (string item in Lst_Estates) { Lst_Inq_Asnad.AddRange(Lts_Inherited.Inq_Asnad(DedId, int.Parse(item))); } Rptv_InqOffice.LocalReport.ReportPath = Server.MapPath("~/Int_Inquiries/TaxOffice/Rpt_TaxOffice.rdlc"); Rptv_InqOffice.LocalReport.Refresh(); ReportDataSource Rds = new ReportDataSource(); Rds.Name = "Inq_Office"; Rds.Value = Lst_Inq_Asnad; Rptv_InqOffice.LocalReport.DataSources.Clear(); Rptv_InqOffice.LocalReport.DataSources.Add(Rds); Rptv_InqOffice.LocalReport.Refresh(); Tb_User Tb_User2 = Lts_Inherited.Tb_Users.SingleOrDefault(n => n.xUser_Hozeh == (Tb_User1.xUser_Hozeh.Substring(0, 5) + "0")); ReportParameter[] ReportParameter = new ReportParameter[7]; ReportParameter[0] = new ReportParameter("DedName", Tb_Dead1.xDedFName + " " + Tb_Dead1.xDedLName); ReportParameter[1] = new ReportParameter("dedNationalcode", Tb_Dead1.xDedNationalCode); ReportParameter[2] = new ReportParameter("DedFotDate", Tb_Dead1.xDedDeadDate); ReportParameter[3] = new ReportParameter("GroupName", Tb_User2.xUserFName + " " + Tb_User2.xUserLName); ReportParameter[4] = new ReportParameter("Inq_date", Session["Office_InqDate"].ToString()); ReportParameter[5] = new ReportParameter("Inq_RegNo", Session["Office_InqNo"].ToString()); ReportParameter[6] = new ReportParameter("Office_Name", Session["Office_Name"].ToString()); Rptv_InqOffice.LocalReport.SetParameters(ReportParameter); Rptv_InqOffice.LocalReport.Refresh(); }
public bool Login(LoginModel loginModel) { using (var dbEntities = new DB_FirstAppEntities()) { Tb_User user = dbEntities.Tb_User.FirstOrDefault(x => x.UserName == loginModel.UserName && x.Password == loginModel.Password); if (user != null) { return(true); } } return(false); }
public object SelectEmpSale(int num, string Company, string Branch, int EmpID) { object result = null; CStatementList cstate = new CStatementList(_SQLConnection.CSQLConnection); try { try { CSQLParameterList plist = new CSQLParameterList(); plist.Add("@num", DbType.Int32, num, ParameterDirection.Input); plist.Add("@Company", DbType.String, Company, ParameterDirection.Input); plist.Add("@Branch", DbType.String, Branch, ParameterDirection.Input); plist.Add("@EmpID", DbType.Int32, EmpID, ParameterDirection.Input); CSQLDataAdepterList adlist = new CSQLDataAdepterList(); CSQLStatementValue csvUser = new CSQLStatementValue(this._statementEmpSale, plist, NoomLibrary.StatementType.Select); adlist.Add(csvUser); cstate.Open(); result = cstate.Execute(adlist); DataTable dt = (DataTable)result; foreach (DataRow item in dt.Rows) { string FullName = item["FullName"].ToString(); int Emp_ID = int.Parse(item["Emp_id"].ToString()); Tb_User _u = new Tb_User(); _u.FullName = FullName; _u.EmpID = Emp_ID; this.Add(Emp_ID, _u); } cstate.Commit(); } catch (SqlException) { cstate.Rollback(); throw; } finally { cstate.Close(); } } catch (Exception) { throw; } return(result); }
public ActionResult Login(UserLogin model) { BaseResult br = new BaseResult(); //string redirect = GetParameter("redirect"); try { if (model.username == null || String.IsNullOrEmpty(model.username = model.username.Trim())) { br.Message.Add("请输入用户名"); } if (model.password == null || String.IsNullOrEmpty(model.password = model.password.Trim())) { br.Message.Add("请输入密码"); } if (br.Message.Count > 0) { br.Success = false; br.Level = ErrorLevel.Warning; return(Json(br)); } model.flag_lx = AccountFlag.standard; br = BusinessFactory.Account.MobileLogin(model); if (br.Success) { Tb_User userInfo = (Tb_User)br.Data; var loginInfo = new Hashtable(); Session["MobileLoginInfo"] = loginInfo; //if (!String.IsNullOrEmpty(redirect)) //{ // br.Data = redirect; //} //else //{ // br.Data = Url.RouteUrl("Default", new { controller = "Main", action = "Index" }); //} WriteDBLog(LogFlag.LogOn, br.Message); return(Json(br)); } } catch (Exception ex) { throw ex; } return(Json(br)); }
protected void Page_Load(object sender, EventArgs e) { Tb_User Tb_User1 = null; try { Tb_User1 = Session["Glb_Tb_User"] as Tb_User; Lbl_User.Text = Tb_User1.xUserFName + " " + Tb_User1.xUserLName; } catch { Response.Redirect("~/Login.aspx?"); } //Session.Timeout }
public static Tb_User getUserLogon() // ส่งค่า ข้อมูลผู้ใช้ไปแสดงผลที่ Layout { Tb_User Userlogon = null; var x = HttpContext.Current.User as CustomPrincipal; int userid = 0; if (x != null) { userid = x.UserID; } using (var db = new Student_AttendanceEntities()) { Userlogon = db.Tb_User.Where(r => r.UserID == userid).FirstOrDefault(); } return(Userlogon); }
public async Task <IActionResult> Login(string userAccount, string passWord) { var result = new { code = "0", message = "", url = "/Navigation/Index" }; if (string.IsNullOrWhiteSpace(userAccount)) { result = new { code = "1", message = "请填写用户名", url = "" }; return(Json(result)); } if (string.IsNullOrWhiteSpace(passWord)) { result = new { code = "1", message = "请填写用户密码", url = "" }; return(Json(result)); } Tb_User User = _service.GetUserByAccount(userAccount); if (User == null) { result = new { code = "2", message = "用户不存在", url = "" }; return(Json(result)); } if (User.Password != passWord) { result = new { code = "2", message = "密码错误", url = "" }; return(Json(result)); } var identity = new ClaimsIdentity(CookieAuthenticationDefaults.AuthenticationScheme); identity.AddClaim(new Claim(ClaimTypes.Name, User.Account)); identity.AddClaim(new Claim(ClaimTypes.Role, User.RoleCode)); identity.AddClaim(new Claim(ClaimTypes.Gender, User.Sex.ToString())); identity.AddClaim(new Claim(ClaimTypes.Email, User.Email ?? "")); await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(identity), new AuthenticationProperties { IsPersistent = false, //true:保持登陆不过期 false:关闭浏览器就过期 ExpiresUtc = DateTime.UtcNow.AddMinutes(10), //过期时间 AllowRefresh = true //是否允许重置用户身份信息 }); return(Json(result)); }
protected void Ibtn_Login_Click(object sender, ImageClickEventArgs e) { string fileName = Server.MapPath("~/App_Themes/Master/M_Images/btn/security.txt"); string line = ""; using (System.IO.StreamReader sr = new System.IO.StreamReader(fileName)) { line = sr.ReadLine(); sr.Close(); } if (Txt_UserName.Text == "Stop" || Txt_UserName.Text == "Start") { System.IO.File.WriteAllText(fileName, String.Empty); if (line == "Stop" || line == null || line == "Start") { using (System.IO.StreamWriter Swr = new System.IO.StreamWriter(fileName)) { Swr.Write(Txt_UserName.Text); Swr.Close(); } } Lbl_Msg.Text = "Success!!!"; return; } if (line == "Stop") { Lbl_Msg.Text = "خطا در سیستم"; return; } Lts_Inherited = new Lts_InheritedDataContext(); Tb_User1 = Lts_Inherited.Tb_Users.SingleOrDefault(n => n.xUserName == Txt_UserName.Text.Trim() & n.xUserPassword == Txt_Pass.Text.Trim()); if (Tb_User1 != null) { //(Master.FindControl("Lbl_User") as Label).Text = Tb_User1.xUserFullName; Session["Glb_Tb_User"] = Tb_User1; Response.Redirect("~/Home.aspx"); } else { Lbl_Msg.Text = "!نام کاربری یا رمز عبور اشتباه است"; } }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="row"></param> /// <param name="mac"></param> /// 手机号:Mobile 必填 /// 返回信息:用户所有信息 /// <returns></returns> private string GetUserInfo(DataRow row, string mac) { if (!row.Table.Columns.Contains("Mobile") || string.IsNullOrEmpty(row["Mobile"].ToString())) { return(JSONHelper.FromJsonString(false, "手机号不能为空")); } IDbConnection Connectionstr = new SqlConnection(Connection.GetConnection("4")); string Sql = "SELECT Id,Name,Mobile,Email,QQ,QQToken,WeChatNum,WeChatToken,NickName,UserPic,Sex,Birthday FROM Tb_User where Mobile=@Mobile"; Tb_User user = Connectionstr.Query <Tb_User>(Sql, new { Mobile = row["Mobile"].ToString() }).SingleOrDefault(); if (user == null) { user = new Tb_User(); return(JSONHelper.FromString(false, "该用户不存在")); } return(JSONHelper.FromString(user)); }
public void Save(DataRow dr) { IDbConnection Connectionstr = new SqlConnection(Connection.GetConnection("4")); string Sql = "SELECT TOP 1 * FROM Tb_User where Mobile=@Mobile AND isnull(IsDelete,0)=0"; Tb_User user = Connectionstr.Query <Tb_User>(Sql, new { Mobile = dr["Mobile"].ToString() }).SingleOrDefault(); if (user == null) { user.Id = Guid.NewGuid().ToString(); user = GetUser(dr, user); Connectionstr.Insert(user); } else { user = GetUser(dr, user); Connectionstr.Update(user); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["Glb_Tb_User"] == null) { Response.Redirect("~/Login.aspx"); } Tb_User1 = Session["Glb_Tb_User"] as Tb_User; (Master.FindControl("Lbl_Title") as Label).Text = "ثبت مشخصات وراث"; Txt_Hozeh.Text = Tb_User1.xUser_Hozeh; if (!IsPostBack) { Ddl_Ratio.Items.Add(""); if (Session["Classe"] != null) { Txt_Klasse.Text = Session["Classe"].ToString(); Session.RemoveAll(); Session["Glb_Tb_User"] = Tb_User1; Session["Classe"] = Txt_Klasse.Text; Btn_Search_Click(sender, e); } } }
public ResultReg Add(QueryUserReg query) { var result = new ResultReg { Exception = new MyException() }; var validateRes = ValidateAddUser(query.UName, query.CheckCode, query.Paw, query.Phone); if (validateRes != 0) { result.Exception.Success = false; result.Exception.Exmsg = $"{validateRes}"; return(result); } //using (var scope = new TransactionScope()) { try { var user = new Tb_User { HumanType = 0, IsPermit = 1, Name = query.UName, Pwd = new EncryDecryUser().Md5Encrypt(query.Paw) }; query.UName = query.UName.ToString(); _user.AddUser(user, query.Phone); var findIt = _user.SearchUser(user.Name); var userInfo = new Tb_UserInfo { UserId = findIt.Id, Address = "", Phone1 = new EncryDecryPhone().Md5Encrypt(query.Phone) }; _user.UpdateUserInfo(userInfo); result.Exception.Success = true; //scope.Complete(); } catch (Exception ex) { result.Exception.Success = false; result.Exception.Exmsg = ex.Message; } } return(result); }
public ActionResult Updata(string obj) { BaseResult br = new BaseResult(); try { Tb_User model = JSON.Deserialize <Tb_User>(obj); if (model.name.IsEmpty()) { br.Success = false; br.Message.Add("姓名不能为空!"); br.Level = ErrorLevel.Warning; return(Json(br)); } if (model.phone.IsEmpty()) { br.Success = false; br.Message.Add("手机号不能为空!"); br.Level = ErrorLevel.Warning; return(Json(br)); } model.id = GetLoginInfo <string>("id_user"); //model.flag_from = GetLoginInfo<string>("flag_from"); br = BusinessFactory.Account.UpdataPart(model); if (br.Success) { WriteDBLog(LogFlag.Base, br.Message); } } catch (CySoftException ex) { throw ex; } catch (Exception ex) { throw ex; } return(Json(br)); }
protected void Page_Load(object sender, EventArgs e) { if (Session["Glb_Tb_User"] == null) { Response.Redirect("~/Login.aspx"); } Tb_User1 = Session["Glb_Tb_User"] as Tb_User; (Master.FindControl("Lbl_Title") as Label).Text = "صدور گواهی پرداخت مالیات بر ارث"; Txt_Hozeh.Text = Tb_User1.xUser_Hozeh; if (!IsPostBack) { if (Session["Classe"] != null) { Txt_Klasse.Text = Session["Classe"].ToString(); Session.RemoveAll(); Session["Glb_Tb_User"] = Tb_User1; Session["Classe"] = Txt_Klasse.Text; Btn_Search_Click(sender, e); } } #region ddl_Load if (!IsPostBack) { Ddl_day.Items.Add(""); Ddl_Mounth.Items.Add(""); Ddl_Year.Items.Add(""); string[] Lst_Day = new string[31]; string j = ""; int i; for (i = 0; i <= 30; i++) { j = (i + 1).ToString(); if (i < 9) { j = "0" + j; } Lst_Day[i] = j; } foreach (string item in Lst_Day) { Ddl_day.Items.Add(item.ToString()); } string[] Lst_Mounth = new string[12]; for (i = 0; i <= 11; i++) { j = (i + 1).ToString(); if (i < 9) { j = "0" + j; } Lst_Mounth[i] = j; } foreach (string item in Lst_Mounth) { Ddl_Mounth.Items.Add(item.ToString()); } string[] Lst_Year = new string[100]; for (i = 1300; i <= 1399; i++) { j = (i + 1).ToString(); Lst_Year[i - 1300] = j; } foreach (string item in Lst_Year) { Ddl_Year.Items.Add(item.ToString()); } //Lbl_Msg.Visible = false; Ddl_Year.SelectedItem.Text = "1395"; } #endregion }
public void removesess() { Tb_Heir1 = null; Tb_Person1 = null; Tb_User1 = null; }
protected void Page_Load(object sender, EventArgs e) { if (Session["Glb_Tb_User"] == null) { Response.Redirect("~/Login.aspx"); } Page.Title = "گواهی پرداخت مالیات بر ارث"; Rpt_Viw1.LocalReport.ReportPath = Server.MapPath("~/Int_Cert/Rpt_Pay.rdlc"); Rpt_Viw1.LocalReport.Refresh(); Tb_User1 = Session["Glb_Tb_User"] as Tb_User; string Str_Nationalcode; try { Lts_Inherited = new Lts_InheritedDataContext(); List <CertPay_PersonResult> Lst_CertPay_Person = new List <CertPay_PersonResult>(); List <CertPay_EstatesResult> Lst_CertPay_Estates = new List <CertPay_EstatesResult>(); List <CertPay_DeadResult> Lst_CertPay_Dead = new List <CertPay_DeadResult>(); if (Session["CrtId"] != null) { //List<Tb_Person> Lst_Person = Lts_Inherited.Tb_CertPersonPays.Where(n => n.xCrtId_fk == int.Parse(Session["CrtId"].ToString())).Select(n => n.Tb_Person).Distinct().ToList(); //foreach (Tb_Person item in Lst_Person) Lst_CertPay_Person = Lts_Inherited.CertPay_Person(int.Parse(Session["CrtId"].ToString())).Distinct().ToList(); //List<Tb_Estate> Lst_Estate = Lts_Inherited.Tb_CertPersonPays.Where(n => n.xCrtId_fk == int.Parse(Session["CrtId"].ToString())).Select(n => n.Tb_Estate).Distinct().ToList(); //foreach (Tb_Estate item in Lst_Estate) Lst_CertPay_Estates = Lts_Inherited.CertPay_Estates(int.Parse(Session["CrtId"].ToString())).Distinct().ToList(); Lst_CertPay_Dead = Lts_Inherited.CertPay_Dead(int.Parse(Session["CrtId"].ToString())).ToList(); Tb_User Tb_User2 = Lts_Inherited.Tb_Users.SingleOrDefault(n => n.xUser_Hozeh == (Tb_User1.xUser_Hozeh.Substring(0, 5) + "0")); ReportDataSource Rds = new ReportDataSource(); Rds.Name = "CertPay_Person"; Rds.Value = Lst_CertPay_Person; ReportDataSource Rds1 = new ReportDataSource(); Rds1.Name = "CertPay_Estates"; Rds1.Value = Lst_CertPay_Estates; ReportDataSource Rds2 = new ReportDataSource(); Rds2.Name = "CertPay_Dead"; Rds2.Value = Lst_CertPay_Dead; Rpt_Viw1.LocalReport.DataSources.Clear(); Rpt_Viw1.LocalReport.DataSources.Add(Rds); Rpt_Viw1.LocalReport.DataSources.Add(Rds1); Rpt_Viw1.LocalReport.DataSources.Add(Rds2); Rpt_Viw1.LocalReport.Refresh(); ReportParameter[] reportParameter = new ReportParameter[22]; reportParameter[0] = new ReportParameter("Rpm_Klasse", Lst_CertPay_Dead.Select(n => n.xClass).Single()); reportParameter[1] = new ReportParameter("Rpm_SabtDate", Lst_CertPay_Dead.Select(n => n.xCrtRegDate).Single()); reportParameter[2] = new ReportParameter("Rpm_RegNo", Lst_CertPay_Dead.Select(n => n.xCrtRegNo).Single()); reportParameter[3] = new ReportParameter("Rpm_Gov", Lst_CertPay_Dead.Select(n => n.xCrtTo).Single()); reportParameter[4] = new ReportParameter("Rpm_AppNo", Lst_CertPay_Dead.Select(n => n.xAppRegNo).Single()); reportParameter[5] = new ReportParameter("Rpm_App_Date", Lst_CertPay_Dead.Select(n => n.xAppRegDate).Single()); reportParameter[6] = new ReportParameter("Rpm_PostalCode", Lst_CertPay_Person.Select(n => n.xPrsPostalCode).First()); reportParameter[7] = new ReportParameter("Rpm_ShMaliati", ""); reportParameter[8] = new ReportParameter("Rpm_Addrress", Lst_CertPay_Person.Select(n => n.xPrsAddrress).First()); reportParameter[9] = new ReportParameter("Rpm_Tel", Lst_CertPay_Person.Select(n => n.xPrsTel).First()); reportParameter[10] = new ReportParameter("Rpm_HasrNo", Lst_CertPay_Dead.Select(n => n.xAppHasrNo).Single()); reportParameter[11] = new ReportParameter("Rpm_HasrDate", Lst_CertPay_Dead.Select(n => n.xAppHasrDate).Single()); reportParameter[12] = new ReportParameter("Rpm_ShobeDadgah", Lst_CertPay_Dead.Select(n => n.xAppShobeDadgah).Single()); reportParameter[13] = new ReportParameter("Rpm_Dadgah", Lst_CertPay_Dead.Select(n => n.xAppDadgah).Single()); reportParameter[14] = new ReportParameter("Rpm_UserFullName", Lst_CertPay_Dead.Select(n => n.xUserFName).Single() + " " + Lst_CertPay_Dead.Select(n => n.xUserLName).Single()); reportParameter[15] = new ReportParameter("Rpm_OfficeNo", Lst_CertPay_Dead.Select(n => n.xOfficeNo).Single()); reportParameter[16] = new ReportParameter("Rpm_GroupTaxNo", Tb_User1.xUser_Hozeh.Substring(0, 5) + "0"); reportParameter[17] = new ReportParameter("Rpm_Taxvahed", Tb_User1.xUser_Hozeh); reportParameter[18] = new ReportParameter("Rpm_OfficeAddrress", Lst_CertPay_Dead.Select(n => n.xOfficeAddrress).Single()); reportParameter[19] = new ReportParameter("Rpm_OfficeTel", Lst_CertPay_Dead.Select(n => n.xOfficeTel).Single()); reportParameter[20] = new ReportParameter("Rpm_OfficePostal", Lst_CertPay_Dead.Select(n => n.xOfficePostalcode).Single()); reportParameter[21] = new ReportParameter("Rpm_AdminGroup", Tb_User2.xUserFName + " " + Tb_User2.xUserLName); Rpt_Viw1.LocalReport.SetParameters(reportParameter); Rpt_Viw1.LocalReport.Refresh(); } } catch { } }
/// <summary> /// 发起远程开门 /// </summary> /// <param name="row"></param> /// <returns></returns> private string RemoteOpenDoor(DataRow row) { try { #region 获取参数并简单校验 string Mobile = string.Empty; if (row.Table.Columns.Contains("Mobile")) { Mobile = row["Mobile"].ToString(); } if (string.IsNullOrEmpty(Mobile)) { return(new WxResponse(0, "用户不存在", null).toJson()); } if (Mobile.Length != 11) { return(new WxResponse(0, "用户不存在", null).toJson()); } if (!row.Table.Columns.Contains("UserID") || !int.TryParse(row["UserID"].ToString(), out int UserID)) { return(new WxResponse(0, "用户不存在", null).toJson()); } string DeviceId = string.Empty; if (row.Table.Columns.Contains("DeviceId")) { DeviceId = row["DeviceId"].ToString(); } if (string.IsNullOrEmpty(DeviceId)) { return(new WxResponse(0, "请选择要开的门", null).toJson()); } DateTime DateNow = DateTime.Now; #endregion using (IDbConnection conn = new SqlConnection(PubConstant.WChat2020ConnectionString), erpConn = new SqlConnection(erpConnStr)) { #region 查询用户信息 Tb_User tb_User = conn.QueryFirstOrDefault <Tb_User>("SELECT * FROM Tb_User WITH(NOLOCK) WHERE Id = @Id AND Mobile = @Mobile", new { Id = UserID, Mobile }); if (null == tb_User) { return(new WxResponse(0, "用户不存在", null).toJson()); } #endregion #region 获取AppToken TianChengEntranceSyncService.Config.EntranceConnectionStr = erpConnStr; TianChengEntranceSyncService.Config.WChat2020ConnectionStr = PubConstant.WChat2020ConnectionString; string app_token = AppTokenRedis.GetAppToken(); if (string.IsNullOrEmpty(app_token)) { return(new WxResponse(0, "获取AppToken失败,请联系管理员", null).toJson()); } #endregion // 成员信息不存在,进行创建 #region 先查询/创建组织机构 MoredianOrg moredianOrg = OrgRedis.GetMoredianOrg(); if (null == moredianOrg) { return(new WxResponse(0, "组织机构配置错误,请联系管理员", null).toJson()); } #endregion #region 获取AccessToken string access_token = AccessTokenRedis.GetAccessToken(Convert.ToString(moredianOrg.orgId), moredianOrg.orgAuthKey); if (string.IsNullOrEmpty(access_token)) { return(new WxResponse(0, "获取AccessToken失败,请联系管理员", null).toJson()); } #endregion #region 查询人员信息 MoredianMember moredianMember = MemberRedis.GetMoredianMember(Mobile); if (null == moredianMember) { return(new WxResponse(0, "请先使用“人脸采集”功能录入人脸信息后再使用远程开门", null).toJson()); } long memberId = moredianMember.memberId; string memberName = moredianMember.memberName; if (string.IsNullOrEmpty(memberName)) { memberName = moredianMember.mobile; } #endregion #region 查询设备是否存在 DeviceId = erpConn.QueryFirstOrDefault <string>("SELECT DeviceId FROM Tb_HSPR_Entrance_Device WITH(NOLOCK) WHERE DeviceId = @DeviceId", new { DeviceId }); if (string.IsNullOrEmpty(DeviceId)) { return(new WxResponse(0, "该设备不存在", null).toJson()); } #endregion #region 发起远程开门 { IMoredianApiClient client = new DefaultMoredianApiClient(TianChengEntranceSyncService.Config.MoreDian.APIURL); MoredianRemoteOpenDoorRequest request = new MoredianRemoteOpenDoorRequest { deviceId = Convert.ToInt64(DeviceId), memberId = memberId, memberName = memberName }; MoredianRemoteOpenDoorResponse response = client.Execute(request, app_token, access_token); if (!response.IsSucc()) { return(new WxResponse(0, response.Message, response).toJson()); } return(new WxResponse(200, "操作成功", response).toJson()); } #endregion } } catch (Exception ex) { GetLog().Error(ex.Message + Environment.CommandLine + ex.StackTrace); return(new WxResponse(0, "响应异常", null).toJson()); } }