public ActionResult Index(int?page) { DateTime dt = DateTime.Now; DateTime endTime = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))); NameValueCollection q = new NameValueCollection(); q.Add("CreatedAtStart", endTime.AddDays(-1).ToString("yyyy/MM/dd 10:00")); q.Add("CreatedAtEnd", DateTime.Now.AddHours(1).ToString("yyyy/MM/dd HH:00")); InspectOriginQueryModel query = new InspectOriginQueryModel(q); IPagedList <InspectOrigin> inspects = null; using (var txn = new System.Transactions.TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted })) { using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { int currentPageIndex = page.HasValue ? (page.Value <= 0 ? 0 : page.Value - 1) : 0; IInspectOriginRep inspectOriginRep = new InspectOriginRep(unitOfWork); inspects = inspectOriginRep.Queryable(query.CreatedAtStart, query.CreatedAtEnd).ToPagedList(currentPageIndex, int.Parse(Resources.PageSize)); } } ViewBag.Query = query; return(View(inspects)); }
public ActionResult Edit(int id) { User user; using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IUserRep userRep = new UserRep(unitOfWork); user = userRep.FindById(id); if (user != null) { if (Brilliantech.Tsk.Manage.WebApp.Util.CustomMembershipProvider.CanEdit(user.Name)) { ViewData["Role"] = new SelectList(UserRoleModel.UserRoleList(), "Key", "Name", user.Role); return(View(user)); } else { TempData["Message"] = "初始管理员,不可以编辑"; return(RedirectToAction("Index")); } } else { return(RedirectToAction("Index")); } } }
public static bool IsAdmin(string username) { using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IUserRep userRep = new UserRep(unitOfWork); return(userRep.Find(username).Role == "admin" ? true : false); } }
private List <Inspect> ExportInspect(InspectQueryModel query) { List <Inspect> inspects = new List <Inspect>(); using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IInspectRep inspectRep = new InspectRep(unitOfWork); inspects = GenerateQuery(unitOfWork, query).ToList <Inspect>(); } return(inspects); }
private IPagedList <Inspect> QueryInspect(InspectQueryModel query, int?currentPageIndex, int?pageSize) { IPagedList <Inspect> inspects; using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IInspectRep inspectRep = new InspectRep(unitOfWork); inspects = GenerateQuery(unitOfWork, query).ToPagedList(currentPageIndex.Value, pageSize.Value); } return(inspects); }
// // GET: /Inspect/Details/5 public ActionResult Details(string id) { InspectOrigin inspect; using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IInspectOriginRep inspectRep = new InspectOriginRep(unitOfWork); inspect = inspectRep.FindById(id); } return(View(inspect)); }
public BaseRep(IUnitOfWork _unit) { if (_unit == null) { throw new ArgumentNullException("Data context is null"); } else { this.context = _unit as TskDataDataContext; } }
public ActionResult Index(int userId) { List <UserTsk> userTsks = null; using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { Session["UserTsk_UserId"] = userId; IUserTskRep userTskRep = new UserTskRep(unitOfWork); userTsks = userTskRep.ListByUserId(userId); } return(View(userTsks)); }
public ActionResult Index(int?page) { IPagedList <User> users = null; using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { int currentPageIndex = page.HasValue ? (page.Value <= 0 ? 0 : page.Value - 1) : 0; IUserRep userRep = new UserRep(unitOfWork); users = userRep.Queryable().ToPagedList(currentPageIndex, int.Parse(Resources.PageSize)); } return(View(users)); }
public ActionResult Create(FormCollection collection) { try { if (Session["UserTsk_UserId"] == null) { return(RedirectToAction("Index", "User")); } else { if (collection.Get("TskNo").Trim().Length > 0) { UserTsk userTsk; using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IUserTskRep userTskRep = new UserTskRep(unitOfWork); UserTsk ut = userTskRep.FindByUserId((int)Session["UserTsk_UserId"], collection.Get("TskNo")); if (ut == null) { userTsk = new UserTsk() { UserId = (int)Session["UserTsk_UserId"], TskNo = collection.Get("TskNo") }; userTskRep.Create(userTsk); unitOfWork.Submit(); } else { TempData["Message"] = "此用户已配置TSK:" + collection.Get("TskNo"); return(View()); } } } else { TempData["Message"] = "TskNo长度需大于0"; return(View()); } } return(RedirectToAction("Index", new { userId = Session["UserTsk_UserId"] })); } catch { return(View()); } }
public bool ValidateUser(string username, string password = null) { using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IUserRep userRep = new UserRep(unitOfWork); User user = userRep.Find(username, password); if (user == null) { return(false); } else { user.LastLoginTime = DateTime.Now; unitOfWork.Submit(); return(true); } } }
// // GET: /UserTsk/Delete/5 public ActionResult Delete(int id) { UserTsk userTsk; using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IUserTskRep userTskRep = new UserTskRep(unitOfWork); userTsk = userTskRep.FindById(id); if (userTsk != null) { return(View(userTsk)); } else { return(RedirectToAction("Index", new { userId = Session["UserTsk_UserId"] })); } } }
public bool ChangePassword(string username, string oldPassword, string newPassword) { using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IUserRep userRep = new UserRep(unitOfWork); User user = userRep.Find(username, oldPassword); if (user != null) { user.Password = newPassword; unitOfWork.Submit(); return(true); } else { return(false); } } }
public ActionResult Delete(int id, FormCollection collection) { UserTsk userTsk = null; try { using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IUserTskRep userTskRep = new UserTskRep(unitOfWork); userTsk = userTskRep.FindById(id); userTskRep.Delete(userTsk); unitOfWork.Submit(); } return(RedirectToAction("Index", new { userId = Session["UserTsk_UserId"] })); } catch { return(View(userTsk)); } }
public ActionResult Index(int?page) { DateTime dt = DateTime.Now; DateTime endTime = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))); NameValueCollection q = new NameValueCollection(); q.Add("ClipScanTime1Start", endTime.AddDays(-1).ToString("yyyy/MM/dd 10:00")); q.Add("ClipScanTime1End", DateTime.Now.AddHours(1).ToString("yyyy/MM/dd HH:00")); InspectQueryModel query = new InspectQueryModel(q); IPagedList <Inspect> inspects = null; using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { int currentPageIndex = page.HasValue ? (page.Value <= 0 ? 0 : page.Value - 1) : 0; IInspectRep inspectRep = new InspectRep(unitOfWork); inspects = inspectRep.Queryable(query.ClipScanTime1Start, query.ClipScanTime1End).ToPagedList(currentPageIndex, int.Parse(Resources.PageSize)); } ViewBag.Query = query; return(View(inspects)); }
public void CreateUser(string username, string password, string role, string email, out MembershipCreateStatus status) { status = MembershipCreateStatus.Success; using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IUserRep userRep = new UserRep(unitOfWork); if (userRep.Find(username) != null) { status = MembershipCreateStatus.DuplicateUserName; } else { userRep.Create(new User() { Name = username, Password = password, Role = role, Email = email }); } unitOfWork.Submit(); } }
public ActionResult Edit(int id, FormCollection collection) { try { User user; using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IUserRep userRep = new UserRep(unitOfWork); user = userRep.FindById(id); if (Brilliantech.Tsk.Manage.WebApp.Util.CustomMembershipProvider.CanEdit(user.Name)) { ViewData["Role"] = new SelectList(UserRoleModel.UserRoleList(), "Key", "Name", user.Role); if (collection.Get("Password").Trim().Length < CustomMembershipProvider.MinRequiredPasswordLength) { ViewBag.Message = "密码长度小于" + CustomMembershipProvider.MinRequiredPasswordLength; return(View(user)); } else { user.Password = collection.Get("Password").Trim(); user.Role = collection.Get("Role"); user.Email = collection.Get("Email"); unitOfWork.Submit(); return(RedirectToAction("Index")); } } else { TempData["Message"] = "初始管理员,不可以编辑"; return(RedirectToAction("Index")); } } } catch { return(View()); } }
/// <summary> /// Called by the <see cref="IScheduler" /> when a /// <see cref="ITrigger" /> fires that is associated with the <see cref="IJob" />. /// </summary> public virtual void Execute(IJobExecutionContext context) { //TestFile(context); //return; try { JobDataMap job = context.JobDetail.JobDataMap; DateTime startQueryDate = (DateTime)job.Get("StartDate"); DateTime endQueryDate = (DateTime)job.Get("EndDate"); List <User> users = null; using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IUserRep userRep = new UserRep(unitOfWork); users = userRep.ListWithEmail(); } SmtpClient smtpServer = new SmtpClient(EmailServerSetting.SmtpHost); //smtpServer.Port = EmailServerSetting.SmtpPort; smtpServer.Credentials = new System.Net.NetworkCredential(EmailServerSetting.EmailUser, EmailServerSetting.EmailPwd); foreach (User user in users) { try { List <UserInspect> inspects = new List <UserInspect>(); using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString)) { IUserInspectRep userInspectRep = new UserInspectRep(unitOfWork); inspects = userInspectRep.ListByUserId(user.Id, startQueryDate, endQueryDate); } if (inspects.Count > 0) { using (MailMessage mail = new MailMessage()) { mail.From = new MailAddress(EmailServerSetting.EmailAddress); mail.To.Add(user.Email); mail.Subject = "电测台数据文件"; var filename = "Inspect" + DateTime.Now.ToString("yyyyMMddHHmm") + "_" + Guid.NewGuid().ToString("N"); var csvfilename = filename + ".csv"; //var zipfilename = filename + ".zip"; var filePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "InspectFileTmp"); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } var csvFilePath = Path.Combine(filePath, csvfilename); //var zipFilePath = Path.Combine(filePath, zipfilename); using (FileStream csv = new FileStream(csvFilePath, FileMode.Create, FileAccess.ReadWrite)) { using (MemoryStream ms = new MemoryStream()) { using (StreamWriter sw = new StreamWriter(ms, Encoding.UTF8)) { sw.WriteLine(string.Join(",", InspectQueryModel.CsvHead.ToArray())); foreach (UserInspect i in inspects) { List <string> ii = new List <string>(); foreach (string field in InspectQueryModel.Fileds) { var value = i.GetType().GetProperty(field).GetValue(i, null); ii.Add(value == null ? "" : value.ToString()); } sw.WriteLine(string.Join(",", ii.ToArray())); } csv.Write(ms.ToArray(), 0, (int)ms.Length); } } } //using (ZipFile zip = new ZipFile()) //{ // zip.AddFile(csvFilePath); // zip.Save(zipfilename); //} Attachment att = new Attachment(csvFilePath); mail.Attachments.Add(att); smtpServer.Send(mail); LogUtil.Logger.Info("Send Inspect Email to:" + user.Email + ", File: " + filename); } } } catch (Exception ex) { LogUtil.Logger.Error(ex.Message); } } } catch (Exception e) { LogUtil.Logger.Error(e.Message); } }
public ProcessMessage CreateInspect(string text) { ProcessMessage message = new ProcessMessage(); try { using (IUnitOfWork unitOfWork = new TskDataDataContext(MSSqlConfig.ConnectionString)) { IInspectOriginRep inspectOriginRep = new InspectOriginRep(unitOfWork); InspectOrigin inspectOrigin = new InspectOrigin() { Id = Guid.NewGuid(), Text = text, CreatedAt = DateTime.Now }; if (text == null || text.Length == 0 || text.Split(TskConfig.DataSpliter).Length != TskConfig.DataCount) { message.Result = false; message.Messages.Add("数据为空或数据格式不存在"); if (!string.IsNullOrEmpty(text)) { message.Messages.Add("数据属性长度为:" + text.Split(TskConfig.DataSpliter).Length.ToString()); message.Messages.Add("分隔符为:" + TskConfig.DataSpliter.ToString()); } LogUtil.Logger.Error(message.GetMessageContent()); } else { IInspectRep inspectRep = new InspectRep(unitOfWork); string[] data = text.Split(TskConfig.DataSpliter); Inspect inspect = new Inspect() { Id = Guid.NewGuid(), TskNo = data[0], LeoniNo = data[1], CusNo = data[2], ClipScanNo = data[3], // ClipScanTime1 = data[4], // ClipScanTime2 = data[6], TskScanNo = data[7], // TskScanTime3 = data[8], // Time3MinTime2 = data[9], OkOrNot = data[10], CreatedAt = DateTime.Now, OriginId = inspectOrigin.Id }; DateTime clipScanTime1 = DateTime.Now; if (DateTime.TryParse(data[4], out clipScanTime1)) { inspect.ClipScanTime1 = clipScanTime1; } DateTime clipScanTime2 = DateTime.Now; if (DateTime.TryParse(data[6], out clipScanTime2)) { inspect.ClipScanTime2 = clipScanTime2; } DateTime tskScanTime3 = DateTime.Now; if (DateTime.TryParse(data[8], out tskScanTime3)) { inspect.TskScanTime3 = tskScanTime3; } float time3MinTime2 = 0; if (float.TryParse(data[9], out time3MinTime2)) { inspect.Time3MinTime2 = time3MinTime2; } inspectRep.Create(inspect); message.Messages.Add("数据处理成功"); message.Result = true; } inspectOrigin.ProcessResult = message.Result; inspectOrigin.ProcessMessage = message.GetMessageContent(); inspectOriginRep.Create(inspectOrigin); unitOfWork.Submit(); } return(message); } catch (Exception e) { LogUtil.Logger.Error(e.Message); throw e; } }