/// <summary> /// 登录验证 /// </summary> /// <returns></returns> public static int getLogin(t_User u) { string sql = string.Format(@"select *from t_User where UserName='******' and Password='******'", u.UserName, u.Password); DataTable ds = DBHelper.GetDatatable(sql); return(ds.Rows.Count); }
public static TraceEntity Discard(string username, string caseNo) { t_User user = UserClass.GetUser(username); UserLoginResponse userResp = new UserLoginResponse(); userResp.Username = username; userResp.CountConsumed = user.CountConsumed; userResp.CountWithdrawed = user.CountWithdrawed; return(Discard(userResp, caseNo)); }
public static int getLoginTypeid(t_User u) { string sql = string.Format("select GroupID from t_User where UserName='******' and Password='******'", u.UserName, u.Password); DataTable ds = DBHelper.GetDatatable(sql); t_User f = new t_User(); foreach (DataRow item in ds.Rows) { f.TypeID = Convert.ToInt32(item["GroupID"]); } return(f.TypeID); }
public HttpResponseMessage Get(int id) { PDFDocument pdfDocument = new PDFDocument(); t_Expertise expertise = _db.t_Expertise.Find(id); if (expertise != null) { if (expertise.DateExp == null) { expertise.DateExp = DateTimeOffset.Now; } pdfDocument.DateExp = expertise.DateExp.Value.ToString("d"); pdfDocument.Conclusion = expertise.Conclusion; pdfDocument.IsForWriteoff = expertise.IsForWriteoff; pdfDocument.IsOrganizationRepair = expertise.IsOrganizationRepair; pdfDocument.IsPartsSupply = expertise.IsPartsSupply; pdfDocument.IsServiceable = expertise.IsServiceable; pdfDocument.IsServiceableEquipment = expertise.IsServiceableEquipment; pdfDocument.IsWarrantyRepair = expertise.IsWarrantyRepair; pdfDocument.NumberExp = expertise.NumberExp; pdfDocument.Reason = expertise.Reason; pdfDocument.RequestId = expertise.RequestId; pdfDocument.Staff = expertise.Staff; pdfDocument.Staff2 = expertise.Staff2; t_Equipment equipment = expertise.t_Equipment.FirstOrDefault(); if (equipment != null) { pdfDocument.InventoryNumber = equipment.InventoryNumber; pdfDocument.SerialNumber = equipment.SerialNumber; pdfDocument.StartupDate = equipment.StartupDate.Value.Year.ToString(); //.ToShortDateString(); pdfDocument.Name = equipment.Name; } t_User user = expertise.t_User.FirstOrDefault(); if (user != null) { pdfDocument.ImgData = user.Sign; } } MemoryStream stream = new MemoryStream(pdfDocument.GetPDFDocument()); HttpResponseMessage result = new HttpResponseMessage(statusCode: HttpStatusCode.OK); result.Content = new StreamContent(stream); result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/pdf"); result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment"); result.Content.Headers.ContentDisposition.FileName = pdfDocument.GetFileName() + ".pdf"; //var transactionViewQuerable = (IQueryable<TransactionFileReportModel>)queryOptions.ApplyTo(transactionView); return(result); // await transactionViewQuerable.ToArrayAsync(); }
public static t_User GetUser(string username) { DataSet ds = Common.DB.Select(Tables.t_User) .Where(Tables.t_User.username == username) .ToDataSet(); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; t_User user = NBear.Mapping.ObjectConvertor.ToObject <t_User>(dr); return(user); } else { return(null); } }
public bool AddUserToExpertise(int expertiseId, int userId) { t_Expertise expertise = _db.t_Expertise.SingleOrDefault(s => s.ExpertiseId == expertiseId); if (expertise != null) { t_User userNew = _db.t_User.Find(userId); if (userNew != null) { expertise.t_User.Add(userNew); _db.SaveChanges(); return(true); } return(false); } return(false); }
public async Task <ActionResult> Register(RegisterInputModel model, string SelectedRole) { if (ModelState.IsValid) { #if DEBUG Debug.WriteLine("Model is valid"); #endif var user = new t_User(); user.UserName = model.UserName; user.FIO = model.FIO; user.Position = model.Position; user.SetPasswordEnabled = model.SetPasswordEnabled; var result = await _userManager.CreateAsync(user, model.Password); if (result.Succeeded) { #if DEBUG Debug.WriteLine("resulult is secceeded"); #endif if (SelectedRole != null) { var result2 = await _userManager.AddToRoleAsync(user.Id, SelectedRole); if (result2.Succeeded) { #if DEBUG Debug.WriteLine("Roles is added"); #endif return(RedirectToAction("List")); } } }/* * var result = await _userManager.RegisterUserAsync(model, SelectedRole); * if (result.Succeeded) * { #if DEBUG * Debug.WriteLine("User is added!"); #endif * return RedirectToAction("List"); * }*/ } model.userRoles = _userManager.GetListUserRoles(); return(View(model)); }
public bool ReplaceUserForExpertise(int expertiseId, int userId) { t_Expertise expertise = _db.t_Expertise.SingleOrDefault(s => s.ExpertiseId == expertiseId); if (expertise != null) { t_User userOld = _db.t_Expertise.Find(expertiseId).t_User.FirstOrDefault(); if (userOld != null) { expertise.t_User.Remove(userOld); _db.SaveChanges(); } t_User userNew = _db.t_User.Find(userId); if (userNew != null) { expertise.t_User.Add(userNew); _db.SaveChanges(); return(true); } return(false); } return(false); }
public async Task <IHttpActionResult> PictureUploadPost(int id) { #if DEBUG Debug.WriteLine("HttpPost Begin"); #endif var request = HttpContext.Current.Request; var validationRules = new FlowValidationRules(); validationRules.AcceptedExtensions.AddRange(new List <string> { "jpeg", "jpg", "png", "bmp" }); validationRules.MaxFileSize = 5000000; //validationRules.MaxFileSize = 50; //validationRules.MaxFileSizeMessage = "File's size is too big!"; // try // { var status = _flowJs.PostChunk(request, _uploadFolder, validationRules); if (status.Status == PostChunkStatus.Done) { // file uploade is complete. Below is an example of further file handling var filePath = Path.Combine(_uploadFolder, status.FileName); #if DEBUG Debug.WriteLine("filePath=" + filePath); #endif var file = File.ReadAllBytes(filePath); //var picture = await _fileManager.UploadPictureToS3(User.Identity.GetUserId(), file, status.FileName); ModelState.AddModelError("file", "done"); //ModelState.Add(KeyValuePair<"1122",ModelState.AddModelError("file", "done") >); //_fileManager = new BinaryFile(filePath); //byte[] bytesF = _fileManager.GetBinaryData(); t_User user = _db.t_User.Where(w => w.UserID == id).FirstOrDefault(); if (user != null) { user.Sign = File.ReadAllBytes(filePath); _db.Entry(user).State = EntityState.Modified; _db.SaveChanges(); } #if DEBUG else { Debug.WriteLine("user==null"); } #endif //File.Delete(filePath); return(Ok()); //return BadRequest(ModelState); } if (status.Status == PostChunkStatus.PartlyDone) { return(Ok()); } status.ErrorMessages.ForEach(x => ModelState.AddModelError("file", x)); #if DEBUG foreach (var m in ModelState) { Debug.WriteLine("Key=" + m.Key + " value=" + m.Value.ToString()); } #endif return(BadRequest(ModelState)); //} /*catch (Exception) * { * ModelState.AddModelError("file", "exception"); * return BadRequest(ModelState); * }*/ }
public static int getLoginTypeid(t_User u) { return(t_UserService.getLoginTypeid(u)); }
public static int getlogin(t_User u) { return(t_UserService.getLogin(u)); }