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