/// <summary> /// Tìm kiếm sv theo niên khóa mục quản lý sinh viên /// </summary> /// <returns>trả về bảng sinh viên</returns> public static DataTable Timkiemnienkhoa(int i, string id, int idkythi, int idkhoa, int idlop) { try { string str = null; switch (i) { case 1: str = "SELECT ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], s.MaSV, s.HoSV, s.TenSV, s.NgaySinh, l.MaLop,'false' as [Chon] " + "FROM SINHVIEN s,LOP l WHERE not exists (SELECT x.IdSV FROM XEPPHONG x WHERE x.IdSV = s.MaSV and x.IdKyThi = " + idkythi + ") " + "and s.IdLop = l.ID and l.ID = " + idlop + " and s.MaSV like '%" + id + "' ORDER BY TenSV"; break; case 2: str = "SELECT ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], s.MaSV, s.HoSV, s.TenSV, s.NgaySinh, l.MaLop,'false' as [Chon] " + "FROM SINHVIEN s,LOP l, KHOA k WHERE not exists (SELECT x.IdSV FROM XEPPHONG x WHERE x.IdSV = s.MaSV and x.IdKyThi = " + idkythi + ") " + "and s.IdLop = l.ID and l.IdKhoa = k.ID and k.ID = " + idkhoa + " and s.MaSV like '%" + id + "' ORDER BY TenSV"; break; case 3: str = "SELECT ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], s.MaSV, s.HoSV, s.TenSV, s.NgaySinh, l.MaLop,'false' as [Chon] " + "FROM SINHVIEN s,LOP l WHERE not exists (SELECT x.IdSV FROM XEPPHONG x WHERE x.IdSV = s.MaSV and x.IdKyThi = " + idkythi + ") " + "and s.IdLop = l.ID and s.MaSV like '%" + id + "' ORDER BY TenSV"; break; } return(Conn.GetTable(str)); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); return(null); } }
public ActionResult UpdateCustomerCare(string key, string json, int agencyId) { var msg = new JsonMessage(false, "Sở thích cập nhật thành công."); try { if (key != Keyapi) { return(Json(0, JsonRequestBehavior.AllowGet)); } var model = _da.GetById(ItemId); var NoteCate = Request["NoteCate"]; var customerCare = model.Customer_Care.Where(v => v.AgencyId == agencyId).FirstOrDefault(); if (customerCare != null) { customerCare.Note = HttpUtility.UrlDecode(NoteCate); } else { customerCare = new Customer_Care { Note = HttpUtility.UrlDecode(NoteCate), AgencyId = Agencyid() }; model.Customer_Care.Add(customerCare); } _da.Save(); } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được cập nhật"; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
public static DataTable Timkiemnienkhoa3(int i, string id, int idkhoa, int idlop) { try { string str = null; switch (i) { case 1: str = "SELECT ROW_NUMBER() OVER(ORDER BY l.MaLop, s.TenSV) as [STT],s.MaSV,s.HoSV,s.TenSV,s.NgaySinh," + "s.IdLop,l.MaLop,l.IdKhoa,k.TenKhoa " + "FROM SINHVIEN s,LOP l, KHOA k " + "WHERE s.IdLop = l.ID and l.IdKhoa = k.ID and l.ID = " + idlop + " and s.MaSV like '%" + id + "' ORDER BY l.MaLop, s.TenSV"; break; case 2: str = "SELECT ROW_NUMBER() OVER(ORDER BY l.MaLop, s.TenSV) as [STT],s.MaSV,s.HoSV,s.TenSV,s.NgaySinh," + "s.IdLop,l.MaLop,l.IdKhoa,k.TenKhoa " + "FROM SINHVIEN s,LOP l, KHOA k " + "WHERE s.IdLop = l.ID and l.IdKhoa = k.ID and k.ID = " + idkhoa + " and s.MaSV like '%" + id + "' ORDER BY l.MaLop, s.TenSV"; break; case 3: str = "SELECT ROW_NUMBER() OVER(ORDER BY l.MaLop, s.TenSV) as [STT],s.MaSV,s.HoSV,s.TenSV,s.NgaySinh," + "s.IdLop,l.MaLop,l.IdKhoa,k.TenKhoa " + "FROM SINHVIEN s,LOP l, KHOA k " + "WHERE s.IdLop = l.ID and l.IdKhoa = k.ID and s.MaSV like '%" + id + "' ORDER BY l.MaLop, s.TenSV"; break; } return(Conn.GetTable(str)); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); return(null); } }
private void txtPathBackup_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { try { var openfiledialog = new OpenFileDialog { Filter = @"Excel Files|*.bak;*bak", Multiselect = false, Title = @"Chọn file bak", CheckFileExists = true, CheckPathExists = true }; if (openfiledialog.ShowDialog() == DialogResult.OK) { _str = openfiledialog.FileName; txtPathBackup.Text = _str; } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
public ActionResult LockAgency(string key, string lstInt) { var msg = new JsonMessage(false, "Cập nhật dữ liệu thành công."); try { if (key == Keyapi) { var obj = _da.GetListByArrId(lstInt); foreach (var item in obj) { item.IsLock = true; } _da.Save(); } } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được cập nhật."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
private void dgv_DanhSach_InitializeLayout(object sender, InitializeLayoutEventArgs e) { try { var band = e.Layout.Bands[0]; band.Columns["IdKyThi"].Hidden = true; band.Columns["ThangDiem"].Hidden = true; band.Override.CellAppearance.TextHAlign = HAlign.Center; band.Override.HeaderAppearance.FontData.SizeInPoints = 10; band.Override.HeaderAppearance.FontData.Bold = DefaultableBoolean.True; band.Columns["MaMon"].MinWidth = 140; band.Columns["MaDe"].MinWidth = 140; band.Columns["CauHoi"].MinWidth = 140; band.Columns["Dapan"].MinWidth = 140; band.Columns["MaMon"].MaxWidth = 150; band.Columns["MaDe"].MaxWidth = 150; band.Columns["CauHoi"].MaxWidth = 150; band.Columns["Dapan"].MaxWidth = 150; band.Override.HeaderClickAction = HeaderClickAction.SortSingle; #region Caption band.Columns["MaMon"].Header.Caption = @"Mã môn thi"; band.Columns["MaDe"].Header.Caption = @"Mã đề thi"; band.Columns["CauHoi"].Header.Caption = @"Câu hỏi"; band.Columns["Dapan"].Header.Caption = @"Đáp án"; #endregion } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
public ActionResult Add(string key, string json) { var msg = new JsonMessage(false, "Thêm mới dữ liệu thành công."); var model = new DN_Vote(); try { if (key != Keyapi) { return(Json(0, JsonRequestBehavior.AllowGet)); } UpdateModel(model); model.Name = HttpUtility.UrlDecode(model.Name); _da.Add(model); _da.Save(); } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được thêm mới."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
// áp dụng nhiều kỳ thi public static DataTable[] KiemTraLogic(IList <int> list) { var tb = new DataTable[list.Count]; try { var str = new string[list.Count]; for (var i = 0; i < list.Count; i++) { str[i] = "select bl.MaSV,s.HoSV,s.TenSV,s.NgaySinh,l.MaLop, p.TenPhong" + " from BAILAM bl join XEPPHONG x on bl.MaSV = x.IdSV join SINHVIEN s on bl.MaSV = s.MaSV join LOP l on s.IdLop = l.ID join PHONGTHI p on x.IdPhong = p.ID" + " where IdKyThi = " + list[i] + " and not exists( select c.MaSV From (" + Getstr2(list) + " ) c where bl.MaSV = c.MaSV)"; tb[i] = Conn.GetTable(str[i]); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } return(tb); }
private void ChonSinhVien() { try { var save = new SqlBulkCopy(); var tbxp = save.tbXepPhong(); foreach (var row in dgv_DanhSach.Rows) { if (!bool.Parse(row.Cells["Chon"].Text)) { continue; } tbxp.Rows.Add(row.Cells["MaSV"].Text, _idkythi); } //save.Bulk_Insert("XEPPHONG",tbxp); save.sp_InsertUpdate("sp_InsertXepPhong", "@tbl", tbxp); Invoke((Action)(() => MessageBox.Show(@"Lưu lại thành công", @"Thông báo"))); Invoke((Action)(Close)); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
protected override void LoadFormDetail() { try { var frm = new FrmGopKetQua { Check = false }; frm.ShowDialog(); _list = frm.LstIdKyThi; if (_list.Count > 0 && frm.Check) { var thread = new Thread(LoadGrid) { IsBackground = true }; thread.Start(); OnShowDialog("Loading..."); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
public ActionResult Delete(string key, string lstArrId) { var msg = new JsonMessage(false, "Xóa dữ liệu thành công."); try { if (key == Keyapi) { var lstProduct = _da.ListByArrId(lstArrId); foreach (var item in lstProduct) { item.IsDeleted = true; } _da.Save(); } } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được xóa."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
private void Rptdsbailam() { try { if (dgv_DanhSach.Rows.Count == 0) { return; } reportManager1.DataSources.Clear(); reportManager1.DataSources.Add("danhsach", dgv_DanhSach.DataSource); rptdsbailam.FilePath = Application.StartupPath + @"\Reports\dsbailam.rst"; rptdsbailam.Prepare(); rptdsbailam.GetReportParameter += GetParameter; var previewForm = new PreviewForm(rptdsbailam) { WindowState = FormWindowState.Maximized }; previewForm.Show(); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
public ActionResult Actions() { var msg = new JsonMessage(); var category = new Category(); var parent = new Category(); List <Category> ltsCategoryItems; StringBuilder stbMessage; switch (DoAction) { case ActionType.Add: try { UpdateModel(category); category.LanguageId = Fdisystem.LanguageId; category.IsDeleted = false; category.CreatedDate = DateTime.Now; //category.AgencyId = int.Parse(WebConfig.AgencyId); parent = _categoryDa.GetById(category.ParentId ?? 0); if (parent != null) { category.IsLevel = parent.IsLevel + 1; } _categoryDa.Add(category); _categoryDa.Save(); msg = new JsonMessage { Erros = false, ID = category.Id.ToString(), Message = string.Format("Đã thêm mới chuyên mục: <b>{0}</b>", Server.HtmlEncode(category.Name)) }; } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } break; case ActionType.Edit: try { category = _categoryDa.GetById(ArrId.FirstOrDefault()); UpdateModel(category); //category.AgencyId = int.Parse(WebConfig.AgencyId); parent = _categoryDa.GetById(category.ParentId ?? 0); if (parent != null) { category.IsLevel = parent.IsLevel + 1; } category.Type = !string.IsNullOrEmpty(Request["Type"]) ? Convert.ToInt32(Request["Type"]) : 0; _categoryDa.Save(); msg = new JsonMessage { Erros = false, ID = category.Id.ToString(), Message = string.Format("Đã cập nhật chuyên mục: <b>{0}</b>", Server.HtmlEncode(category.Name)) }; } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } break; case ActionType.Delete: ltsCategoryItems = _categoryDa.GetListByArrId1(ArrId); stbMessage = new StringBuilder(); foreach (var item in ltsCategoryItems) { try { item.IsDeleted = true; stbMessage.AppendFormat("Đã xóa chuyên mục <b>{0}</b>.<br />", Server.HtmlEncode(item.Name)); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } } msg.ID = string.Join(",", ArrId); _categoryDa.Save(); msg.Message = stbMessage.ToString(); break; case ActionType.Show: ltsCategoryItems = _categoryDa.GetListByArrId1(ArrId).Where(o => o.IsShow == false).ToList(); //Chỉ lấy những đối tượng ko được hiển thị stbMessage = new StringBuilder(); foreach (var item in ltsCategoryItems) { try { item.IsShow = true; stbMessage.AppendFormat("Đã hiển thị chuyên mục <b>{0}</b>.<br />", Server.HtmlEncode(item.Name)); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } } _categoryDa.Save(); msg.ID = string.Join(",", ltsCategoryItems.Select(o => o.Id)); msg.Message = stbMessage.ToString(); break; case ActionType.Hide: ltsCategoryItems = _categoryDa.GetListByArrId1(ArrId).Where(o => o.IsShow == true).ToList(); //Chỉ lấy những đối tượng được hiển thị stbMessage = new StringBuilder(); foreach (var item in ltsCategoryItems) { try { item.IsShow = false; stbMessage.AppendFormat("Đã ẩn chuyên mục <b>{0}</b>.<br />", Server.HtmlEncode(item.Name)); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } } _categoryDa.Save(); msg.ID = string.Join(",", ltsCategoryItems.Select(o => o.Id)); msg.Message = stbMessage.ToString(); break; case ActionType.Order: try { if (!string.IsNullOrEmpty(Request["OrderValues"])) { var orderValues = Request["OrderValues"]; if (orderValues.Contains("|")) { foreach (var keyValue in orderValues.Split('|')) { if (keyValue.Contains("_")) { var tempCategory = _categoryDa.GetById(Convert.ToInt32(keyValue.Split('_')[0])); tempCategory.Sort = Convert.ToInt32(keyValue.Split('_')[1]); _categoryDa.Save(); } } } msg.ID = string.Join(",", orderValues); msg.Message = "Đã cập nhật lại thứ tự chuyên mục"; } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } break; } if (string.IsNullOrEmpty(msg.Message)) { msg.Message = "Không có hành động nào được thực hiện."; msg.Erros = true; } return(Json(msg, JsonRequestBehavior.AllowGet)); }
private void cboHocky_SelectedValueChanged(object sender, EventArgs e) { try { _idhocky = cboHocky.SelectedValue.ToString(); if (_idhocky == "0") { if (_idnamhoc == 0) { if (_idlop != 0) { dgv_DanhSach.DataSource = SearchData.Timkiemtheolop1(_idlop); } else if (_idkhoa != 0) { dgv_DanhSach.DataSource = SearchData.Timkiemtheokhoa1(_idkhoa); } else { LoadGrid(); } } else if (_idlop != 0) { dgv_DanhSach.DataSource = SearchData.Quanlydiem(1, _idkhoa, _idlop, _idnamhoc, _idhocky); } else if (_idkhoa != 0) { dgv_DanhSach.DataSource = SearchData.Quanlydiem(2, _idkhoa, _idlop, _idnamhoc, _idhocky); } else { dgv_DanhSach.DataSource = SearchData.Quanlydiem(3, _idkhoa, _idlop, _idnamhoc, _idhocky); } } else if (_idnamhoc != 0) { if (_idlop != 0) { dgv_DanhSach.DataSource = SearchData.Quanlydiem(7, _idkhoa, _idlop, _idnamhoc, _idhocky); } else if (_idkhoa != 0) { dgv_DanhSach.DataSource = SearchData.Quanlydiem(8, _idkhoa, _idlop, _idnamhoc, _idhocky); } else { dgv_DanhSach.DataSource = SearchData.Quanlydiem(9, _idkhoa, _idlop, _idnamhoc, _idhocky); } } else if (_idlop != 0) { dgv_DanhSach.DataSource = SearchData.Quanlydiem(4, _idkhoa, _idlop, _idnamhoc, _idhocky); } else if (_idkhoa != 0) { dgv_DanhSach.DataSource = SearchData.Quanlydiem(5, _idkhoa, _idlop, _idnamhoc, _idhocky); } else { dgv_DanhSach.DataSource = SearchData.Quanlydiem(6, _idkhoa, _idlop, _idnamhoc, _idhocky); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
private void dgv_DanhSach_InitializeLayout(object sender, InitializeLayoutEventArgs e) { try { var band = e.Layout.Bands[0]; band.Groups.Clear(); band.Columns["IdNamHoc"].Hidden = true; band.Override.HeaderAppearance.FontData.Bold = DefaultableBoolean.True; band.Override.HeaderAppearance.FontData.SizeInPoints = 10; band.Columns["STT"].CellActivation = Activation.NoEdit; band.Columns["STT"].CellAppearance.BackColor = Color.LightCyan; #region Caption var columns = band.Columns; band.ColHeadersVisible = false; var group6 = band.Groups.Add("STT"); var group0 = band.Groups.Add("Mã SV"); var group1 = band.Groups.Add("Họ và tên"); var group7 = band.Groups.Add("Lớp"); var group2 = band.Groups.Add("Ngày sinh"); var group3 = band.Groups.Add("Năm học"); var group4 = band.Groups.Add("Học kỳ"); var group5 = band.Groups.Add("Điểm"); columns["STT"].Group = group6; columns["MaSV"].Group = group0; columns["HoSV"].Group = group1; columns["TenSV"].Group = group1; columns["MaLop"].Group = group7; columns["NgaySinh"].Group = group2; columns["NamHoc"].Group = group3; columns["HocKy"].Group = group4; columns["Diem"].Group = group5; #endregion #region Size band.Columns["STT"].MinWidth = 60; band.Columns["STT"].MaxWidth = 70; band.Columns["MaSV"].MinWidth = 100; band.Columns["MaSV"].MaxWidth = 120; band.Columns["HoSV"].MinWidth = 130; band.Columns["HoSV"].MaxWidth = 150; band.Columns["TenSV"].MinWidth = 90; band.Columns["TenSV"].MaxWidth = 100; band.Columns["MaLop"].MinWidth = 90; band.Columns["MaLop"].MaxWidth = 100; band.Columns["NgaySinh"].MinWidth = 100; band.Columns["NgaySinh"].MaxWidth = 100; band.Columns["NamHoc"].MinWidth = 140; band.Columns["NamHoc"].MaxWidth = 150; band.Columns["HocKy"].MinWidth = 100; band.Columns["HocKy"].MaxWidth = 110; band.Columns["Diem"].MinWidth = 100; band.Columns["Diem"].MaxWidth = 120; #endregion columns["STT"].CellAppearance.TextHAlign = HAlign.Center; columns["MaSV"].CellAppearance.TextHAlign = HAlign.Center; columns["NamHoc"].CellAppearance.TextHAlign = HAlign.Center; columns["Diem"].CellAppearance.TextHAlign = HAlign.Center; columns["TenSV"].CellAppearance.TextHAlign = HAlign.Center; columns["MaLop"].CellAppearance.TextHAlign = HAlign.Center; columns["HocKy"].CellAppearance.TextHAlign = HAlign.Center; foreach (var column in band.Columns) { column.CellActivation = Activation.NoEdit; } dgv_DanhSach.DisplayLayout.UseFixedHeaders = true; dgv_DanhSach.DisplayLayout.FixedHeaderOffImage = Properties.Resources.trang; dgv_DanhSach.DisplayLayout.FixedHeaderOnImage = Properties.Resources.trang; group0.Header.Fixed = true; group1.Header.Fixed = true; group2.Header.Fixed = true; group6.Header.Fixed = true; group7.Header.Fixed = true; } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
private bool Checkghi() { try { var b = true; if (string.IsNullOrEmpty(txtmasinhvien.Text)) { b = false; errormasinhvien.SetError(txtmasinhvien, "Không được để trống"); } else { errormasinhvien.Dispose(); } if (string.IsNullOrEmpty(txthotendem.Text)) { b = false; errorhodem.SetError(txthotendem, "Không được để trống"); } else { errorhodem.Dispose(); } if (string.IsNullOrEmpty(txttensinhvien.Text)) { b = false; errortensinhvien.SetError(txttensinhvien, "Không được để trống"); } else { errortensinhvien.Dispose(); } if (string.IsNullOrEmpty(cbongaysinh.Text)) { b = false; errormasinhvien.SetError(cbongaysinh, "Không được để trống"); } else { errorngaysinh.Dispose(); } if (string.IsNullOrEmpty(cbokhoa.Text)) { b = false; errorkhoa.SetError(cbokhoa, "Không được để trống"); } else { errorkhoa.Dispose(); } if (string.IsNullOrEmpty(cbolop.Text)) { b = false; errorlop.SetError(cbolop, "Không được để trống"); } else { errorlop.Dispose(); } return(b); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); return(false); } }
public ActionResult Update(string key, string json) { var msg = new JsonMessage(false, "Cập nhật dữ liệu thành công."); try { if (key == Keyapi) { var objitem = JsonConvert.DeserializeObject <AgencyItem>(json); var obj = _da.GetById(objitem.ID); var check = obj.GroupID != objitem.GroupID; if (obj.GroupID > 0 && check) { _da.InsertDNModule(objitem.GroupID, obj.ID, true); } obj = UpdateBase(obj, objitem); _da.Save(); if (!string.IsNullOrEmpty(objitem.Pass)) { var user = _daUserDa.GetUserByUserName(objitem.UserName); if (user != null) { var sha1PasswordHash = FDIUtils.CreatePasswordHash(objitem.Pass, user.PasswordSalt); user.Password = sha1PasswordHash; } else { var date = ConvertDate.TotalSeconds(DateTime.Now); var role = _darRoleDa.GetByName("Admin"); if (role == null) { role = new DN_Roles { RoleId = Guid.NewGuid(), RoleName = "Admin", LoweredRoleName = "admin", AgencyID = obj.ID, Description = "Quản trị" }; _darRoleDa.Add(role); _darRoleDa.Save(); } var saltKey = FDIUtils.CreateSaltKey(5); var sha1PasswordHash = FDIUtils.CreatePasswordHash(objitem.Pass, saltKey); user = new DN_Users { UserId = Guid.NewGuid(), PasswordSalt = saltKey, Password = sha1PasswordHash, UserName = objitem.UserName, LoweredUserName = obj.Name, Email = obj.Email, Address = obj.Address, AgencyID = obj.ID, Mobile = obj.Phone, IsApproved = true, IsLockedOut = false, CreateDate = date, IsDeleted = false }; _daUserDa.Add(user); var dnUsersInRoles = new DN_UsersInRoles { UserId = role.RoleId, AgencyID = obj.ID, DateCreated = date }; user.DN_UsersInRoles.Add(dnUsersInRoles); } _daUserDa.Save(); } } } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được cập nhật."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
/// <summary> /// /// </summary> /// <param name="key"></param> /// <param name="phone">UserName</param> /// <param name="mobile">SĐT3G</param> /// <param name="pass">Mật khẩu</param> /// <param name="address">Địa chỉ</param> /// <returns></returns> public ActionResult Addapp(string key, string phone, string mobile, string pass, string address, string name, int gid) { var objr = new CustomerAppItem { UserName = phone, Status = 0 }; try { if (key == Keyapi && !string.IsNullOrEmpty(phone) && !string.IsNullOrEmpty(pass)) { if (_da.CheckUserName(phone)) { return(Json(objr, JsonRequestBehavior.AllowGet)); } var daten = DateTime.Now; var date = daten.TotalSeconds(); var saltKey = FDIUtils.CreateSaltKey(5); var sha1PasswordHash = FDIUtils.CreatePasswordHash(pass, saltKey); var obj = new Base.Customer { Address = address, FullName = name, GroupID = gid, Phone = phone, PasswordSalt = saltKey, PassWord = sha1PasswordHash, UserName = phone, DateCreated = date, IsDelete = false, IsActive = true, Reward = 0, }; _da.Add(obj); _da.Save(); var datee = daten.AddDays(5).TotalSeconds(); //var lg = new Ultils(); var code = Ultils.CodeLogin(daten); var dNlogin = new DN_Login { CustomerID = obj.ID, DateCreated = date, DateEnd = datee, Code = code, IsOut = false }; _dl.Add(dNlogin); _dl.Save(); objr = new CustomerAppItem { ID = obj.ID, UserName = phone, Address = address, FullName = name, Phone = mobile, Reward = 0, GroupID = gid, Status = 1, }; } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } return(Json(objr, JsonRequestBehavior.AllowGet)); }
public ActionResult Add(string key, string json) { var msg = new JsonMessage(false, "Thêm mới dữ liệu thành công."); try { if (key == Keyapi) { var date = DateTime.Now.TotalSeconds(); var objitem = JsonConvert.DeserializeObject <AgencyItem>(json); var obj = new DN_Agency { IsDelete = false, IsLock = false, IsOut = false, CreateDate = date, WalletValue = 10000000, CashOut = 0, }; obj = UpdateBase(obj, objitem); _da.Add(obj); _da.Save(); if (objitem.GroupID > 0) { _da.InsertDNModule(objitem.GroupID, obj.ID); } var saltKey = FDIUtils.CreateSaltKey(5); var sha1PasswordHash = FDIUtils.CreatePasswordHash(objitem.Pass, saltKey); var user = new DN_Users { UserId = Guid.NewGuid(), PasswordSalt = saltKey, Password = sha1PasswordHash, UserName = objitem.UserName, LoweredUserName = obj.Name, Email = obj.Email, Address = obj.Address, AgencyID = obj.ID, Mobile = obj.Phone, IsApproved = true, IsLockedOut = false, CreateDate = date, IsDeleted = false }; _daUserDa.Add(user); _daUserDa.Save(); var role = new DN_Roles { RoleId = Guid.NewGuid(), RoleName = "Admin", LoweredRoleName = "admin", AgencyID = obj.ID, Description = "Quản trị" }; _darRoleDa.Add(role); var dnUsersInRoles = new DN_UsersInRoles { UserId = user.UserId, AgencyID = obj.ID, DateCreated = date, IsDelete = false }; role.DN_UsersInRoles.Add(dnUsersInRoles); _darRoleDa.Save(); } } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được thêm mới."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
public ActionResult Update(string key, string codelogin, Guid?userId) { var msg = new JsonMessage(false, "Thêm mới dữ liệu thành công."); try { if (key == Keyapi) { var model = _da.GetById(ItemId); UpdateModel(model); model.DateUpdate = DateTime.Now.TotalSeconds(); model.UserID = userId; var lst = model.ProductValue_Recipe.Where(c => c.IsDeleted == false || !c.IsDeleted.HasValue).ToList(); var lstNew = GetListRecipeValueItem(codelogin); //xóa var result1 = lst.Where(p => lstNew.All(p2 => p2.ProductValueId != p.ProductValueId)); foreach (var i in result1) { i.IsDeleted = true; } //Sửa foreach (var i in lst) { var j = lstNew.FirstOrDefault(c => c.ProductValueId == i.ProductValueId); if (j != null) { i.Quantity = j.Quantity; } } //thêm mới var result2 = lstNew.Where(p => lst.All(p2 => p2.ProductValueId != p.ProductValueId)).ToList(); foreach (var item in result2) { model.ProductValue_Recipe.Add(item); } //var vaulePrice = model.ProductValue_Recipe.Sum(a => a.Quantity * a.Shop_Product_Value.Price); // var lstDetail = model.Mapping_ProductDetail_Recipe.Where(c => c.IsDeleted == false || !c.IsDeleted.HasValue).ToList(); var lstNewDetail = GetListRecipeDetailItem(codelogin); //xóa var resultDetail = lstDetail.Where(p => lstNewDetail.All(p2 => p2.DetailID != p.DetailID)); foreach (var i in resultDetail) { i.IsDeleted = true; } //Sửa foreach (var i in lstDetail) { var j = lstNewDetail.FirstOrDefault(c => c.DetailID == i.DetailID); if (j != null) { i.Quantity = j.Quantity; } } //thêm mới var result2Detail = lstNewDetail.Where(p => lstDetail.All(p2 => p2.DetailID != p.DetailID)).ToList(); foreach (var item in result2Detail) { model.Mapping_ProductDetail_Recipe.Add(item); } //var productPrice = model.Mapping_ProductDetail_Recipe.Sum(a => a.Quantity * a.Shop_Product_Detail.PriceCost); _da.Save(); //var detail = _detailDa.GetById(model.ProductDetailId ?? 0); //var pricecost = vaulePrice + productPrice; //model.ProductPrice = productPrice; //model.ValuePrice = vaulePrice; //detail.PriceCost = pricecost; //detail.PriceOld = pricecost + detail.Percent * 1000 + (detail.Incurred ?? 0); _da.Save(); } } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được thêm mới."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
public ActionResult Addproduct(string key, string json) { var msg = new JsonMessage(false, "Thêm mới sản phẩm thành công."); try { if (key == Keyapi) { var model = _da.GetProductById(ItemId); var product = _da.GetById(ItemId); var list = new List <Shop_Product>(); foreach (var item in model) { var size = Request["Size_old" + item.ID]; var Type = Request["Type_old" + item.ID]; var price = Request["Price_old" + item.ID]; if (string.IsNullOrEmpty(size)) { list.Add(item); } else { item.SizeID = int.Parse(size); item.TypeID = int.Parse(Type); item.PriceNew = decimal.Parse(price); _da.Save(); } } foreach (var item in list) { _da.DeleteProduct(item); } var stt = ConvertUtil.ToInt32(Request["do_stt"]); for (int i = 1; i <= stt; i++) { var name = Request["Size_add_" + i]; var type = Request["Type_add_" + i]; var price = Request["Price_add_" + i]; if (!string.IsNullOrEmpty(name)) { var obj = new Shop_Product() { ProductDetailID = product.ID, SizeID = int.Parse(name), TypeID = int.Parse(type), IsShow = true, IsDelete = false, }; obj.PriceNew = decimal.Parse(price); _da.AddProduct(obj); } } _da.Save(); } } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được Cập nhật."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Load dữ liệu theo kỳ thi /// </summary> /// <param name="chon"></param> /// <param name="idKythi"></param> /// <returns>trả về 1 table</returns> /// 1. Sinh viên đã được xếp phòng /// 2.3.4. RptPhongthi - 109_SinhVienDuThi /// 5. Sĩ số phòng đã được xếp sinh viên /// 6: Trả về danh sách bài làm của sinh viên /// 7: Đáp án /// 8: Kiểm tra lỗi logic /// 9: Nhập thang điểm /// 10: In điểm thi /// 11. Phòng thi đã được chọn /// 12. Sinh viên đã được chọn để thi /// 13: Sinh viên chưa được xếp phòng trong bảng XEPPHONG với IdPhong là null /// 14: Phong thi có SiSo nhỏ hơn SucChua /// 15: Bảng BAILAM với sinh viên đã được chấm thì DiemThi not null public static DataTable Load(int chon, int idKythi) { var table = new DataTable(); string str = null; try { switch (chon) { case 1: str = "SELECT ROW_NUMBER() OVER(ORDER BY p.TenPhong,s.TenSV) as [STT], " + "s.MaSV, s.HoSV, s.TenSV, s.NgaySinh, l.MaLop, p.TenPhong, k.TenKhoa, l.IdKhoa, x.IdPhong " + "FROM SINHVIEN s " + "join XEPPHONG x on s.MaSV = x.IdSV " + "join PHONGTHI p on x.IdPhong = p.ID " + "join LOP l on s.IdLop = l.ID " + "join KHOA k on l.IdKhoa = k.ID " + "WHERE x.IdKyThi = " + idKythi + " order by p.TenPhong, s.TenSV"; break; case 2: str = "SELECT p.TenPhong " + "FROM PHONGTHI p join XEPPHONG x on p.ID = x.IdPhong " + "where x.IdKyThi = " + idKythi + " ORDER BY p.TenPhong"; break; case 3: str = "SELECT * FROM KYTHI WHERE ID = " + idKythi + ""; break; case 4: str = "SELECT l.MaLop " + "FROM LOP l join SINHVIEN s on l.ID = s.IdLop " + "join XEPPHONG x on s.MaSV = x.IdSV " + "where x.IdKyThi = " + idKythi + " GROUP BY l.MaLop"; break; case 5: str = "SELECT p.TenPhong, p.SucChua, k.SiSo, k.IdPhong " + "FROM KT_PHONG k join PHONGTHI p on k.IdPhong = p.ID " + "WHERE k.IdKyThi = " + idKythi + ""; break; case 6: str = "SELECT ROW_NUMBER() OVER(ORDER BY b.MaSV) as [STT]," + " b.* " + "FROM BAILAM b " + "WHERE b.IdKyThi = " + idKythi + ""; break; case 7: str = "SELECT MaMon, MaDe, CauHoi, Dapan, ThangDiem " + "FROM DAPAN d, KYTHI k " + "WHERE d.IdKyThi = k.ID and d.IdKyThi = " + idKythi + ""; break; case 2051: str = "select b.MaSV" + " FROM BAILAM b" + " where b.IdKyThi = " + idKythi + "" + " and not exists (select * from XEPPHONG x where b.MaSV = x.IdSV and x.IdKyThi = " + idKythi + ") ORDER BY b.MaSV"; break; case 2052: str = "select x.IdSV,s.HoSV,s.TenSV,s.NgaySinh,l.MaLop, p.TenPhong from XEPPHONG x join SINHVIEN s on x.IdSV = s.MaSV join LOP l on s.IdLop = l.ID join PHONGTHI p on x.IdPhong = p.ID " + " where x.IdKyThi = " + idKythi + " and" + " not exists (select b.MaSV from BAILAM b where b.MaSV = x.IdSV and b.IdKyThi = " + idKythi + ")"; break; case 9: str = "SELECT MaMon, MaDe, CauHoi, Dapan, ThangDiem " + "FROM DAPAN d, KYTHI k " + "WHERE d.IdKyThi = k.ID and d.IdKyThi = " + idKythi + ""; break; case 10: str = "SELECT ROW_NUMBER() OVER(ORDER BY b.MaSV) as [STT], b.MaSV, s.HoSV, s.TenSV,s.NgaySinh,l.MaLop, b.DiemThi " + "FROM BAILAM b join SINHVIEN s on b.MaSV = s.MaSV " + "join LOP l on s.IdLop = l.ID " + "WHERE b.IdKyThi = " + idKythi + " "; break; case 11: str = "select ROW_NUMBER() OVER(ORDER BY p.ID) as [STT], " + "p.ID, p.TenPhong,p.SucChua, kt.SiSo " + "From KT_PHONG kt join PHONGTHI p on kt.IdPhong = p.ID " + "where kt.IdKyThi = " + idKythi + ""; break; case 12: str = "SELECT ROW_NUMBER() OVER(ORDER BY s.MaSV) as [STT], " + "s.MaSV, s.HoSV, s.TenSV, s.NgaySinh, l.MaLop, x.IdPhong " + "FROM SINHVIEN s join XEPPHONG x on s.MaSV = x.IdSV " + "join LOP l on s.IdLop = l.ID " + "WHERE x.IdKyThi = " + idKythi + ""; break; case 13: str = "SELECT ROW_NUMBER() OVER(ORDER BY x.IdSV) as [STT],x.IdSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, '' as [PhongThi] " + "FROM XEPPHONG x join SINHVIEN s on x.IdSV = s.MaSV " + "join LOP l on s.IdLop = l.ID " + "where x.IdPhong is null and x.IdKyThi = " + idKythi + ""; break; case 131: str = "SELECT ROW_NUMBER() OVER(ORDER BY x.IdSV) as [STT],x.IdSV, x.IdKyThi, x.IdPhong " + "FROM XEPPHONG x " + "where x.IdPhong is null and x.IdKyThi = " + idKythi + ""; break; case 14: str = "SELECT k.IdPhong, p.SucChua, k.SiSo, p.TenPhong " + "FROM KT_PHONG k join PHONGTHI p on k.IdPhong = p.ID " + "WHERE k.SiSo < p.SucChua and k.IdKyThi = " + idKythi + ""; break; case 15: str = "SELECT ROW_NUMBER() OVER(ORDER BY s.MaSV) as [STT], " + "s.MaSV,s.HoSV,s.TenSV,s.NgaySinh,l.MaLop,b.DiemThi " + "FROM BAILAM b join SINHVIEN s on b.MaSV = s.MaSV " + "join LOP l on s.IdLop = l.ID " + "WHERE b.IdKyThi = " + idKythi + " and b.DiemThi is not null"; break; case 207: str = "SELECT ROW_NUMBER() OVER(ORDER BY b.MaSV) as [STT], b.* " + "FROM BAILAM b " + "WHERE b.IdKyThi = " + idKythi + ""; break; case 209: str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], b.MaSV, s.HoSV,s.TenSV, s.NgaySinh, l.MaLop,b.MaDe, b.DiemThi " + "from BAILAM b join SINHVIEN s on b.MaSV = s.MaSV " + "join LOP l on s.IdLop = l.ID " + "where b.DiemThi is not null and IdKyThi = " + idKythi + " order by TenSV"; break; } table = Conn.GetTable(str); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } return(table); }
/// <summary> /// Load dữ liệu /// </summary> /// <param name="chon"></param> /// <returns>trả về 1 table</returns> /// 1:Trả về bảng thông tin sinh viên gồm lớp khoa /// 2:Trả về bảng bao gồm mã sinh viên /// 3:Trả về bảng khoa /// 4:Trả về bảng lớp /// 5:Trả về bảng sinh viên đã được xếp phòng /// 6:Trả về bảng sinh viên chưa được xếp phòng /// 7:Trả về bảng sinh viên đã được xếp phòng /// 8:Trả về bảng phòng thi còn xếp được sinh viên(số lượng , sức chứa) /// 9:Trả về bảng phòng thi /// 10:Trả về bảng kỳ thi /// 11:Trả về bảng đáp án các mã đề /// 12:Trả về danh sách bài làm của sinh viên /// 13:Kiểm tra những sinh viên có trong danh sách bài thi những không có trong danh sách dự thi /// 14: trả về bảng TAIKHOAN /// 15: Khoa /// 16: Lớp /// 17: Sinh viên /// 18: kỳ thi /// 19: phòng thi /// 20: lấy ra kỳ thi /// 21: lấy ra điểm thi cao nhất /// 22: Năm học public static DataTable Load(int chon) { var table = new DataTable(); string str = null; try { switch (chon) { case 1: str = "SELECT ROW_NUMBER() OVER(ORDER BY l.MaLop,s.TenSV) as [STT],s.MaSV,s.HoSV,s.TenSV,s.NgaySinh," + "s.IdLop,l.MaLop,l.IdKhoa,k.TenKhoa " + "FROM SINHVIEN s,LOP l, KHOA k " + "WHERE s.IdLop = l.ID and l.IdKhoa = k.ID ORDER BY l.MaLop,s.TenSV"; break; case 2: str = "SELECT MaSV FROM SINHVIEN ORDER BY TenSV"; break; case 3: str = "SELECT * FROM KHOA"; break; case 4: str = "SELECT * FROM LOP"; break; case 8: str = "select p.TenPhong, p.SucChua, k.SiSo, k.IdPhong from PHONGTHI p left join KT_PHONG k on p.ID = k.IdPhong"; break; case 9: str = "SELECT ROW_NUMBER() OVER(ORDER BY p.ID) as [STT], p.* FROM PHONGTHI p"; break; case 10: str = "SELECT ROW_NUMBER() OVER(ORDER BY K.ID) as [STT], K.*, [TT] = case K.TrangThai when 1 then N'Hiển thị' when 0 then N'Ẩn' end FROM KYTHI K"; break; case 14: str = "SELECT ROW_NUMBER() OVER(ORDER BY T.ID) as [STT], T.* FROM TAIKHOAN T"; break; case 15: str = "SELECT ROW_NUMBER() OVER(ORDER BY K.ID) as [STT], K.* FROM KHOA K"; break; case 16: str = "SELECT ROW_NUMBER() OVER(ORDER BY L.MaLop) as [STT], L.*, k.TenKhoa FROM LOP L" + " join KHOA k on L.IdKhoa = k.id order by L.MaLop"; break; case 17: str = "SELECT * FROM SINHVIEN"; break; case 18: str = "SELECT ID, MaKT, TenKT FROM KYTHI where TrangThai = 1"; break; case 20: str = "SELECT ID, TenKT, 'false' as [Chon] FROM KYTHI where TrangThai = 1 order by ID desc"; break; case 210: str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" + " (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" + " join SINHVIEN s on d.MaSV = s.MaSV" + " join LOP l on s.IdLop = l.ID" + " join KHOA k on l.IdKhoa = k.ID order by s.TenSV"; break; case 111: str = "select ROW_NUMBER() OVER(ORDER BY N.ID) as [STT], N.* from NAMHOC N order by N.ID"; break; case 209: str = "select N.* from NAMHOC N order by N.ID DESC"; break; case 211: str = " select ROW_NUMBER() OVER(ORDER BY d.MaSV) as [STT], d.MaSV, s.HoSV, s.TenSV,l.MaLop,s.NgaySinh,d.IdNamHoc, n.NamHoc, d.HocKy,d.Diem from" + " DIEMTHI d" + " join NAMHOC n on d.IdNamHoc = n.ID" + " join SINHVIEN s on d.MaSV = s.MaSV" + " join LOP l on s.IdLop = l.ID ORDER BY d.MaSV"; break; } table = Conn.GetTable(str); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } return(table); }
public ActionResult Actions() { var msg = new JsonMessage(); switch (DoAction) { case ActionType.Show: try { int total = _api.TotalSim(); const int t = 30000; int du = total % t; int p = total / t; p = du > 0 ? p + 1 : p; for (int i = 1; i <= p; i++) { var filesale = ConfigData.SitemapFolder + "sitemap-sim-so-" + i + ".txt"; System.IO.File.Copy(ConfigData.SitemapFileFolder + file, filesale); var list = _api.PageProductSitemap(t, i, 2010, total); var listener = new TextWriterTraceListener(filesale); const string text = url; listener.WriteLine(text); foreach (var item in list) { listener.WriteLine(url + "dat-sim-sim-so-dep-0" + item); } listener.Flush(); listener.Close(); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); msg.Message = ex.Message; //msg.Message = "Dữ liệu chưa được backup."; msg.Erros = true; } break; case ActionType.Active: try { string filesale = ConfigData.Folder + "SitemapUpdate.txt"; System.IO.File.Copy(ConfigData.SitemapFileFolder + file, filesale); System.IO.File.Copy(ConfigData.SitemapFileFolder + "SitemapUpdate.xml", ConfigData.Folder + "SitemapUpdate.xml"); var sSiteMapFilePath = Server.MapPath(@"~/SitemapUpdate.xml"); msg = new JsonMessage(false, "SitemapUpdate đã được cập nhật."); var xmlDoc = new XmlDocument(); xmlDoc.Load(sSiteMapFilePath); var listener = new TextWriterTraceListener(filesale); var listsite = Sitemap.Sitemapsimso(); foreach (var item in listsite) { listener.WriteLine(url + item); var nodeSite = xmlDoc.CreateElement("url"); var loc = xmlDoc.CreateElement("loc"); loc.InnerText = url + item; //var lastmod = xmlDoc.CreateElement("lastmod"); //lastmod.InnerText = date; var priority = xmlDoc.CreateElement("priority"); priority.InnerText = string.IsNullOrEmpty(item) ? "1.0" : "0.5"; var changefreq = xmlDoc.CreateElement("changefreq"); changefreq.InnerText = "daily"; nodeSite.AppendChild(loc); //nodeSite.AppendChild(lastmod); nodeSite.AppendChild(priority); nodeSite.AppendChild(changefreq); XmlNode node = nodeSite; XmlNode childNode = xmlDoc.DocumentElement; if (childNode != null) { childNode.InsertAfter(node, childNode.LastChild); } } //listener.Flush(); var list = _da.GetListHomeWork(); foreach (var item in list) { var nodeSite = xmlDoc.CreateElement("url"); var loc = xmlDoc.CreateElement("loc"); loc.InnerText = url + item.Slug; listener.WriteLine(url + item.Slug); //var lastmod = xmlDoc.CreateElement("lastmod"); //lastmod.InnerText = date; var priority = xmlDoc.CreateElement("priority"); priority.InnerText = "0.5"; var changefreq = xmlDoc.CreateElement("changefreq"); changefreq.InnerText = "daily"; nodeSite.AppendChild(loc); //nodeSite.AppendChild(lastmod); nodeSite.AppendChild(priority); nodeSite.AppendChild(changefreq); XmlNode node = nodeSite; XmlNode childNode = xmlDoc.DocumentElement; if (childNode != null) { childNode.InsertAfter(node, childNode.LastChild); } } //listener.Flush(); var listcate = _da.GetTagSitemap(); foreach (var item in listcate) { var nodeSite = xmlDoc.CreateElement("url"); var loc = xmlDoc.CreateElement("loc"); loc.InnerText = url + item.Slug; listener.WriteLine(url + item.Slug); //var lastmod = xmlDoc.CreateElement("lastmod"); //lastmod.InnerText = date; var priority = xmlDoc.CreateElement("priority"); priority.InnerText = "0.5"; var changefreq = xmlDoc.CreateElement("changefreq"); changefreq.InnerText = "daily"; nodeSite.AppendChild(loc); //nodeSite.AppendChild(lastmod); nodeSite.AppendChild(priority); nodeSite.AppendChild(changefreq); XmlNode node = nodeSite; XmlNode childNode = xmlDoc.DocumentElement; if (childNode != null) { childNode.InsertAfter(node, childNode.LastChild); } //listener.Flush(); foreach (var itemnews in item.ListNewsItem) { var nodeSiten = xmlDoc.CreateElement("url"); var locn = xmlDoc.CreateElement("loc"); locn.InnerText = url + itemnews + ".html"; listener.WriteLine(url + itemnews + ".html"); //var lastmodn = xmlDoc.CreateElement("lastmod"); //lastmodn.InnerText = date; var priorityn = xmlDoc.CreateElement("priority"); priorityn.InnerText = "0.5"; var changefreqn = xmlDoc.CreateElement("changefreq"); changefreqn.InnerText = "daily"; nodeSiten.AppendChild(locn); //nodeSiten.AppendChild(lastmodn); nodeSiten.AppendChild(priorityn); nodeSiten.AppendChild(changefreqn); XmlNode noden = nodeSiten; XmlNode childNoden = xmlDoc.DocumentElement; if (childNoden != null) { childNoden.InsertAfter(noden, childNoden.LastChild); } } } var listTag = _da.GetListTag(); foreach (var item in listTag) { var nodeSite = xmlDoc.CreateElement("url"); var loc = xmlDoc.CreateElement("loc"); loc.InnerText = url + "tag/" + item.Url; listener.WriteLine(url + item.Url); //var lastmod = xmlDoc.CreateElement("lastmod"); //lastmod.InnerText = date; var priority = xmlDoc.CreateElement("priority"); priority.InnerText = "0.5"; var changefreq = xmlDoc.CreateElement("changefreq"); changefreq.InnerText = "daily"; nodeSite.AppendChild(loc); //nodeSite.AppendChild(lastmod); nodeSite.AppendChild(priority); nodeSite.AppendChild(changefreq); XmlNode node = nodeSite; XmlNode childNode = xmlDoc.DocumentElement; if (childNode != null) { childNode.InsertAfter(node, childNode.LastChild); } } listener.Flush(); listener.Close(); xmlDoc.Save(sSiteMapFilePath); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); msg.Message = ex.Message; //msg.Message = "Dữ liệu chưa được backup."; msg.Erros = true; } break; default: msg.Message = "Không có hành động nào được thực hiện."; msg.Erros = true; break; } return(Json(msg, JsonRequestBehavior.AllowGet)); }
private void GetParameter(object sender, PerpetuumSoft.Reporting.Components.GetReportParameterEventArgs e) { try { //double bosung = Statistic.Thongkediem(0, _list).Rows.Count; //double toiec1 = Statistic.Thongkediem(1, _list).Rows.Count; //double toiec2 = Statistic.Thongkediem(2, _list).Rows.Count; //double toiec3 = Statistic.Thongkediem(3, _list).Rows.Count; //double toiec4 = Statistic.Thongkediem(4, _list).Rows.Count; //double miengiam = Statistic.Thongkediem(5, _list).Rows.Count; double bosung = 0; double toiec1 = 0; double toiec2 = 0; double toiec3 = 0; double toiec4 = 0; double miengiam = 0; foreach (var row in dgv_DanhSach.Rows) { var d = double.Parse(row.Cells["TongDiem"].Text); if (d < 200) { bosung = bosung + 1; } else if (d >= 200 && d < 250) { toiec1 += 1; } else if (d >= 250 && d < 300) { toiec2 += 1; } else if (d >= 300 && d < 374) { toiec3 += 1; } else if (d >= 374 && d < 450) { toiec4 += 1; } else { miengiam += 1; } } var tong = bosung + toiec1 + toiec2 + toiec3 + toiec4 + miengiam; e.Parameters["bosung"].Value = bosung.ToString(); e.Parameters["toiec1"].Value = toiec1.ToString(); e.Parameters["toiec2"].Value = toiec2.ToString(); e.Parameters["toiec3"].Value = toiec3.ToString(); e.Parameters["toiec4"].Value = toiec4.ToString(); e.Parameters["miengiam"].Value = miengiam.ToString(); e.Parameters["TLbosung"].Value = Math.Round(bosung / tong * 100, 1).ToString(); e.Parameters["TLtoiec1"].Value = Math.Round(toiec1 / tong * 100, 1).ToString(); e.Parameters["TLtoiec2"].Value = Math.Round(toiec2 / tong * 100, 1).ToString(); e.Parameters["TLtoiec3"].Value = Math.Round(toiec3 / tong * 100, 1).ToString(); e.Parameters["TLtoiec4"].Value = Math.Round(toiec4 / tong * 100, 1).ToString(); e.Parameters["TLmiengiam"].Value = Math.Round(miengiam / tong * 100, 1).ToString(); e.Parameters["tong"].Value = tong.ToString(); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
public static DataTable Thongkediem(int index, string s) { try { string str = null; switch (index) { case 1: str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" + " (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" + " join SINHVIEN s on d.MaSV = s.MaSV" + " join LOP l on s.IdLop = l.ID" + " join KHOA k on l.IdKhoa = k.ID" + " where s.MaSV like '%" + s + "' and d.Diem < 200 order by s.TenSV"; break; case 2: str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" + " (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" + " join SINHVIEN s on d.MaSV = s.MaSV" + " join LOP l on s.IdLop = l.ID" + " join KHOA k on l.IdKhoa = k.ID" + " where s.MaSV like '%" + s + "' and d.Diem >= 200 and d.Diem < 250 order by s.TenSV"; break; case 3: str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" + " (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" + " join SINHVIEN s on d.MaSV = s.MaSV" + " join LOP l on s.IdLop = l.ID" + " join KHOA k on l.IdKhoa = k.ID" + " where s.MaSV like '%" + s + "' and d.Diem < 250 order by s.TenSV"; break; case 4: str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" + " (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" + " join SINHVIEN s on d.MaSV = s.MaSV" + " join LOP l on s.IdLop = l.ID" + " join KHOA k on l.IdKhoa = k.ID" + " where s.MaSV like '%" + s + "' and d.Diem >= 250 and d.Diem < 300 order by s.TenSV"; break; case 5: str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" + " (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" + " join SINHVIEN s on d.MaSV = s.MaSV" + " join LOP l on s.IdLop = l.ID" + " join KHOA k on l.IdKhoa = k.ID" + " where s.MaSV like '%" + s + "' and d.Diem < 300 order by s.TenSV"; break; case 6: str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" + " (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" + " join SINHVIEN s on d.MaSV = s.MaSV" + " join LOP l on s.IdLop = l.ID" + " join KHOA k on l.IdKhoa = k.ID" + " where s.MaSV like '%" + s + "' and d.Diem >= 300 and d.Diem < 375 order by s.TenSV"; break; case 7: str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" + " (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" + " join SINHVIEN s on d.MaSV = s.MaSV" + " join LOP l on s.IdLop = l.ID" + " join KHOA k on l.IdKhoa = k.ID" + " where s.MaSV like '%" + s + "' and d.Diem < 375 order by s.TenSV"; break; case 8: str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" + " (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" + " join SINHVIEN s on d.MaSV = s.MaSV" + " join LOP l on s.IdLop = l.ID" + " join KHOA k on l.IdKhoa = k.ID" + " where s.MaSV like '%" + s + "' and d.Diem >= 375 and d.Diem < 450 order by s.TenSV"; break; case 9: str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" + " (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" + " join SINHVIEN s on d.MaSV = s.MaSV" + " join LOP l on s.IdLop = l.ID" + " join KHOA k on l.IdKhoa = k.ID" + " where s.MaSV like '%" + s + "' and d.Diem < 450 order by s.TenSV"; break; case 10: str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" + " (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" + " join SINHVIEN s on d.MaSV = s.MaSV" + " join LOP l on s.IdLop = l.ID" + " join KHOA k on l.IdKhoa = k.ID" + " where d.Diem >= 450 order by s.TenSV"; break; } return(Conn.GetTable(str)); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); return(null); } }
protected override void DeleteRow() { try { bool xoa = false; if (dgv_DanhSach.Selected.Rows.Count > 0) { if (DialogResult.Yes == MessageBox.Show(FormResource.msgHoixoa, FormResource.MsgCaption, MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { foreach (var row in dgv_DanhSach.Selected.Rows) { var masv = row.Cells["MaSV"].Text; var idPhong = row.Cells["IdPhong"].Text; if (!string.IsNullOrEmpty(idPhong)) { var ktp = new KTPhong { IdKyThi = _idkythi, IdPhong = int.Parse(idPhong) }; _listKtPhong.Add(ktp); } var xp = new XepPhong { IdKyThi = _idkythi, IdSV = int.Parse(masv) }; _listXepPhong.Add(xp); } DeleteAndUpdate = true; dgv_DanhSach.DeleteSelectedRows(false); xoa = true; } } else if (dgv_DanhSach.ActiveRow != null) { if (DialogResult.Yes == MessageBox.Show(FormResource.msgHoixoa, FormResource.MsgCaption, MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { var masv = dgv_DanhSach.ActiveRow.Cells["MaSV"].Text; var idPhong = dgv_DanhSach.ActiveRow.Cells["IdPhong"].Text; if (!string.IsNullOrEmpty(idPhong)) { var ktp = new KTPhong { IdKyThi = _idkythi, IdPhong = int.Parse(idPhong) }; _listKtPhong.Add(ktp); } var xp = new XepPhong { IdKyThi = _idkythi, IdSV = int.Parse(masv) }; _listXepPhong.Add(xp); DeleteAndUpdate = true; dgv_DanhSach.ActiveRow.Delete(false); xoa = true; } } UpdateData.UpdateGiamSiSo(_listKtPhong); DeleteData.XoaXepPhong(_listXepPhong); if (xoa) { MessageBox.Show(@"Xóa dữ liệu thành công.", @"Thông báo"); } LoadGrid(); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
private void dgv_DanhSach_InitializeLayout(object sender, InitializeLayoutEventArgs e) { try { var band = e.Layout.Bands[0]; band.Groups.Clear(); band.Override.HeaderAppearance.FontData.SizeInPoints = 10; band.Override.HeaderAppearance.FontData.Bold = DefaultableBoolean.True; band.Columns["STT"].CellAppearance.BackColor = Color.LightCyan; #region Caption var columns = band.Columns; band.ColHeadersVisible = false; var group5 = band.Groups.Add("STT"); columns["STT"].Group = group5; var group0 = band.Groups.Add("Mã SV"); columns["MaSV"].Group = group0; var group1 = band.Groups.Add("Họ và tên"); columns["HoSV"].Group = group1; columns["TenSV"].Group = group1; var group2 = band.Groups.Add("Ngày sinh"); columns["NgaySinh"].Group = group2; var group3 = band.Groups.Add("Lớp"); columns["MaLop"].Group = group3; for (var i = 0; i < _list.Count; i++) { var ten = "Diem" + (i + 1); var ten1 = "Điểm môn " + (i + 1); var group = band.Groups.Add(ten1); band.Columns[ten].Group = group; band.Columns[ten].MinWidth = 100; band.Columns[ten].MaxWidth = 110; band.Columns[ten].CellAppearance.TextHAlign = HAlign.Center; } var group4 = band.Groups.Add("Tổng điểm"); columns["TongDiem"].Group = group4; #endregion #region Size band.Columns["STT"].MinWidth = 60; band.Columns["STT"].MaxWidth = 70; band.Columns["MaSV"].MinWidth = 100; band.Columns["MaSV"].MaxWidth = 120; band.Columns["HoSV"].MinWidth = 130; band.Columns["HoSV"].MaxWidth = 150; band.Columns["TenSV"].MinWidth = 90; band.Columns["TenSV"].MaxWidth = 100; band.Columns["NgaySinh"].MinWidth = 100; band.Columns["NgaySinh"].MaxWidth = 100; band.Columns["MaLop"].MinWidth = 100; band.Columns["MaLop"].MaxWidth = 110; band.Columns["TongDiem"].MinWidth = 100; band.Columns["TongDiem"].MaxWidth = 120; #endregion band.Columns["STT"].CellAppearance.TextHAlign = HAlign.Center; band.Columns["MaSV"].CellAppearance.TextHAlign = HAlign.Center; band.Columns["TenSV"].CellAppearance.TextHAlign = HAlign.Center; band.Columns["MaLop"].CellAppearance.TextHAlign = HAlign.Center; band.Columns["TongDiem"].CellAppearance.TextHAlign = HAlign.Center; foreach (var coloum in band.Columns) { coloum.CellActivation = Activation.NoEdit; } dgv_DanhSach.DisplayLayout.UseFixedHeaders = true; dgv_DanhSach.DisplayLayout.FixedHeaderOffImage = Properties.Resources.trang; dgv_DanhSach.DisplayLayout.FixedHeaderOnImage = Properties.Resources.trang; group0.Header.Fixed = true; group1.Header.Fixed = true; group2.Header.Fixed = true; group3.Header.Fixed = true; group5.Header.Fixed = true; } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
public ActionResult Register(CustomerItem customer) { var objr = new CustomerAppItem { Status = 0 }; try { if (!string.IsNullOrEmpty(customer.Phone) && !string.IsNullOrEmpty(customer.Password)) { if (_da.CheckUserName(customer.Phone)) { return(Json(new BaseResponse <CustomerItem>() { Erros = true, Message = "Số điện thoại đã tồn tại", }, JsonRequestBehavior.AllowGet)); } var daten = DateTime.Now; var date = daten.TotalSeconds(); var saltKey = FDIUtils.CreateSaltKey(5); var sha1PasswordHash = FDIUtils.CreatePasswordHash(customer.Password, saltKey); //get agencyinfo var agencyDA = new AgencyDA(); var agency = agencyDA.GetItem(customer.PhoneAgency); var obj = new Base.Customer { FullName = customer.FullName, Phone = customer.Phone, PasswordSalt = saltKey, PassWord = sha1PasswordHash, UserName = customer.UserName, DateCreated = date, IsDelete = false, IsActive = true, Reward = 0, AgencyID = agency?.ID }; _da.Add(obj); _da.Save(); IAuthContainerModel model = new JWTContainerModel() { Claims = new Claim[] { new Claim(ClaimTypes.Name, obj.UserName), new Claim("ID", obj.ID.ToString()), } }; IAuthService authService = new JWTService(); var token = authService.GenerateToken(model); var result = new BaseResponse <CustomerItem>() { Erros = false, Data = new CustomerItem() { FullName = obj.FullName, Phone = obj.Phone, Token = token } }; return(Json(result, JsonRequestBehavior.AllowGet)); var datee = daten.AddDays(5).TotalSeconds(); //var lg = new Ultils(); var code = Ultils.CodeLogin(daten); var dNlogin = new DN_Login { CustomerID = obj.ID, DateCreated = date, DateEnd = datee, Code = code, IsOut = false }; _dl.Add(dNlogin); _dl.Save(); objr = new CustomerAppItem { ID = obj.ID, Status = 1, }; } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } return(Json(objr, JsonRequestBehavior.AllowGet)); }
protected virtual void LoadGrid() { try { var tb1 = Statistic.GopKetQua(_list); var tb2 = Statistic.GopKetQua1(_list); if (tb2.Rows.Count > 0 && _list.Count > 1) { IList <Sinhvien> listthongke = new List <Sinhvien>(); foreach (DataRow row in tb2.Rows) { var a = int.Parse(row["MaSV"].ToString()); foreach (var sv in listthongke.Where(sv => sv.MaSV == a)) { for (var i = 0; i < _list.Count; i++) { var ten = "Diem" + (i + 1); var diem = row[ten].ToString(); if (!string.IsNullOrEmpty(diem)) { sv.Diemthi[i] = int.Parse(row[ten].ToString()); } } goto b; } var sv1 = new Sinhvien(_list.Count) { MaSV = a, HoSV = row["HoSV"].ToString(), TenSV = row["TenSV"].ToString(), MaLop = row["MaLop"].ToString(), NgaySinh = row["NgaySinh"].ToString(), }; for (var i = 0; i < _list.Count; i++) { var ten = "Diem" + (i + 1); var diem = row[ten].ToString(); if (!string.IsNullOrEmpty(diem)) { sv1.Diemthi[i] = double.Parse(row[ten].ToString()); } else { sv1.Diemthi[i] = 0; } } listthongke.Add(sv1); b :; } var t = tb1.Rows.Count; foreach (var item in listthongke) { tb1.Rows.Add(++t, item.MaSV, item.HoSV, item.TenSV, item.NgaySinh, item.MaLop); for (var i = 0; i < _list.Count; i++) { var ten = "Diem" + (i + 1); tb1.Rows[tb1.Rows.Count - 1][ten] = item.Diemthi[i]; } tb1.Rows[tb1.Rows.Count - 1]["TongDiem"] = item.Tinhtong(); } Invoke((Action)(() => _listtk = listthongke)); } Invoke((Action)(() => dgv_DanhSach.DataSource = tb1)); Invoke((Action)(() => pnl_from.Visible = true)); lock (LockTotal) { OnCloseDialog(); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }