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());
}
}
