public List<Branch_Model> GetListTrungTam() { List<Branch_Model> rs = new List<Branch_Model>(); ThuVien tv = new ThuVien(); try { DataTable tbBranch = tv.SP_SelectDataTable("USP_Branch_GetAll", new string[] { "@First", "@Count" }, new object[] { "0", "10" }); if (tbBranch.Rows.Count > 0) { for (int i = 0; i < tbBranch.Rows.Count; i++) { Branch_Model bmodel = new Branch_Model(); bmodel.BranchID = tbBranch.Rows[i]["BranchID"].ToString(); bmodel.BranchName = tbBranch.Rows[i]["BranchName"].ToString(); rs.Add(bmodel); } } } catch (Exception ex) { throw (ex); } return rs; }
public List<cAdMin_DMObject_Model> GetDMObject(string PeopleID) { List<cAdMin_DMObject_Model> rs = new List<cAdMin_DMObject_Model>(); ThuVien tv = new ThuVien(); try { DataTable tbDMObject = tv.SP_SelectDataTable("USP_DMObject_GetByID", new string[] { "@PeopleID" }, new object[] { PeopleID }); if (tbDMObject.Rows.Count > 0) { for (int i = 0; i < tbDMObject.Rows.Count; i++) { cAdMin_DMObject_Model omodel = new cAdMin_DMObject_Model(); //omodel.PeopleID = tbDMObject.Rows[i]["PeopleID"].ToString(); //omodel.PeopleName = tbDMObject.Rows[i]["PeopleName"].ToString(); omodel.ObjectCode = tbDMObject.Rows[i]["ObjectCode"].ToString(); omodel.ParentObjectCode = tbDMObject.Rows[i]["ParentObjectCode"].ToString(); //omodel.Level = tbDMObject.Rows[i]["Level"].ToString(); //omodel.GroupName = tbDMObject.Rows[i]["GroupName"].ToString(); //omodel.ModifyPeopleID = tbDMObject.Rows[i]["ModifyPeopleID"].ToString(); rs.Add(omodel); } } } catch (Exception ex) { throw (ex); } return rs; }
public List<People_Model> GetListGiaoVien(string BranchID) { List<People_Model> rs = new List<People_Model>(); ThuVien tv = new ThuVien(); try { DataTable tbBranch = tv.SP_SelectDataTable("USP_People_GetBySomeConditional", new string[] { "@flag", "@PeopleCode", "@BranchID" }, new object[] { 4,"GV", BranchID }); if (tbBranch.Rows.Count > 0) { for (int i = 0; i < tbBranch.Rows.Count; i++) { People_Model pmodel = new People_Model(); pmodel.PeopleID = tbBranch.Rows[i]["TeacherID"].ToString(); pmodel.PeopleName = tbBranch.Rows[i]["PeopleName"].ToString(); //pmodel.PeopleCode = tbBranch.Rows[i]["PeopleCode"].ToString(); rs.Add(pmodel); } } } catch (Exception ex) { throw (ex); } return rs; }
protected void Page_Load(object sender, EventArgs e) { //Top Lời giới thiệu tv = new ThuVien(); DataTable tb = tv.SP_SelectDataTable("USP_Article_GetBySomeConditional", new string[] { "@flag", "@Count" }, new object[] { 3, 3 }); cd.DataSource = tb; cd.DataBind(); }
public List<SchoolFeeOfStudent_Model> SearchSchoolFeeOfStudent(string BranchID, string PPID, string PPCode, string HPFrom, string HPTo, string TrangThaiHP, string isDangHoc, string isNgungHoc) { List<SchoolFeeOfStudent_Model> rs = new List<SchoolFeeOfStudent_Model>(); ThuVien tv = new ThuVien(); try { if (isDangHoc == "true") isDangHoc = "2"; if (isNgungHoc == "true") isNgungHoc = "1"; else isNgungHoc = "0"; DataTable tbSchoolFeeOfStudent = tv.SP_SelectDataTable("USP_SchoolFeeOfStudent_GetBySomeConditional", new string[] { "@BranchID", "@PeopleID", "@peopleCode", "@From", "@To", "@StudentStatusID" }, new object[] { BranchID, PPID, PPCode, HPFrom, HPTo, isDangHoc + ", " + isNgungHoc }); if (tbSchoolFeeOfStudent.Rows.Count > 0) { int OrderNumber = 1; for (int i = 0; i < tbSchoolFeeOfStudent.Rows.Count; i++) { SchoolFeeOfStudent_Model sfmodel = new SchoolFeeOfStudent_Model(); sfmodel.OrderNumber = OrderNumber++; sfmodel.PeopleID = tbSchoolFeeOfStudent.Rows[i]["PeopleID"].ToString(); sfmodel.LastName = tbSchoolFeeOfStudent.Rows[i]["LastName"].ToString(); sfmodel.FirstName = tbSchoolFeeOfStudent.Rows[i]["FirstName"].ToString(); sfmodel.ClassID = tbSchoolFeeOfStudent.Rows[i]["ClassID"].ToString(); sfmodel.ClassName = tbSchoolFeeOfStudent.Rows[i]["ClassName"].ToString().Replace("-","_"); sfmodel.DegreeID = tbSchoolFeeOfStudent.Rows[i]["DegreeID"].ToString(); sfmodel.DegreeCode = tbSchoolFeeOfStudent.Rows[i]["DegreeCode"].ToString(); sfmodel.DegreeName = tbSchoolFeeOfStudent.Rows[i]["DegreeNameVN"].ToString(); sfmodel.BranchID = tbSchoolFeeOfStudent.Rows[i]["BranchID"].ToString(); sfmodel.BranchName = tbSchoolFeeOfStudent.Rows[i]["BranchName"].ToString(); sfmodel.Money = tbSchoolFeeOfStudent.Rows[i]["Money"].ToString(); sfmodel.PayDate = tbSchoolFeeOfStudent.Rows[i]["PayDate"].ToString(); sfmodel.From = tbSchoolFeeOfStudent.Rows[i]["From"].ToString(); sfmodel.To = tbSchoolFeeOfStudent.Rows[i]["To"].ToString(); sfmodel.Period = tbSchoolFeeOfStudent.Rows[i]["Period"].ToString(); sfmodel.StudiedSessionNumber = tbSchoolFeeOfStudent.Rows[i]["StudiedSessionNumber"].ToString(); sfmodel.SessionNumber = tbSchoolFeeOfStudent.Rows[i]["SessionNumber"].ToString(); rs.Add(sfmodel); } } } catch (Exception ex) { throw (ex); } return rs; }
protected void btnSearch_Click(object sender, EventArgs e) { tv = new ThuVien(); ddlThanhVien.Items.Clear(); string Name = txtTimTV.Text; tbPeople = tv.SP_SelectDataTable("USP_People_GetByName", new string[] { "@flag", "@PeopleName", "@PeopleCode" }, new object[] { 1, Name, "" }); DataRow drPeople = tbPeople.NewRow(); drPeople["PeopleID"] = 0; drPeople["PeopleName"] = "-- Chọn --"; tbPeople.Rows.InsertAt(drPeople, 0); ddlThanhVien.DataSource = tbPeople; ddlThanhVien.DataTextField = "PeopleName"; ddlThanhVien.DataValueField = "MaPhanQuyen"; //ddlThanhVien.DataValueField = "PeopleID"; ddlThanhVien.DataBind(); }
public List<Student_Model> GetDSHV_trongTrungTam(string BranchID) { List<Student_Model> rs = new List<Student_Model>(); ThuVien tv = new ThuVien(); DataTable tbStudent = tv.SP_SelectDataTable("USP_Student_GetBySomeConditional", new string[] { "@flag", "@BranchID" }, new object[] { 12, BranchID }); if (tbStudent.Rows.Count > 0) { for (int i = 0; i < tbStudent.Rows.Count; i++) { Student_Model stmodel = new Student_Model(); stmodel.StudentID = tbStudent.Rows[i]["StudentID"].ToString(); stmodel.StudentName = tbStudent.Rows[i]["StudentName"].ToString(); rs.Add(stmodel); } } return rs; }
//Lấy danh sách các buổi có thể học thử public List<NgayCoTheHocThu_Model> GetListNgayCoTheHocThu(string ClassID) { ThuVien tv = new ThuVien(); List<NgayCoTheHocThu_Model> rs = new List<NgayCoTheHocThu_Model>(); DataTable dtNgayCoTheHocThu = tv.SP_SelectDataTable("USP_Student_NgayCoTheHocThu", new string[] { "@ClassID" }, new object[] { ClassID }); if (dtNgayCoTheHocThu.Rows.Count > 0) { for (int i = 0; i < dtNgayCoTheHocThu.Rows.Count; i++) { NgayCoTheHocThu_Model HocThumodel = new NgayCoTheHocThu_Model(); HocThumodel.ScheduleID = dtNgayCoTheHocThu.Rows[i]["ScheduleID"].ToString(); HocThumodel.NgayHocThu = dtNgayCoTheHocThu.Rows[i]["NgayHoc"].ToString(); HocThumodel.ThuTrongTuan = dtNgayCoTheHocThu.Rows[i]["ThuTrongTuan"].ToString(); rs.Add(HocThumodel); } } return rs; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Page.Title = "Nghi phep"; if (Session["PeopleCode"].ToString().IndexOf("GH") == -1) { Response.Redirect("?s=sigin"); } //Bind data cho combobox ddlTrungTam Start tv1 = new ThuVien(); tbBranch = tv1.SP_SelectDataTable("USP_Branch_GetAll", new string[] { "@First", "@Count" }, new object[] { "0", "10" }); DataRow drBranch = tbBranch.NewRow(); drBranch["BranchID"] = 0; drBranch["BranchName"] = "-- Chọn --"; tbBranch.Rows.InsertAt(drBranch, 0); ddlTrungTam.DataSource = tbBranch; ddlTrungTam.DataTextField = "BranchName"; ddlTrungTam.DataValueField = "BranchID"; ddlTrungTam.DataBind(); lblOperator.Text = Session["PeopleName"].ToString(); gvPhongHc.PageSize = Convert.ToInt32(WebConfigurationManager.AppSettings["PageSize"]); } }
protected void ddlLop_SelectedIndexChanged(object sender, EventArgs e) { if (ddlLop.SelectedIndex == 0) { lblGiaoVien.Text = ""; } else { tbClass = (DataTable)Session["tbClass"]; //Lấy tên giáo viên chủ nhiệm tbClass.PrimaryKey = new DataColumn[] { tbClass.Columns["ClassID"] }; DataRow dr = tbClass.Rows.Find(Convert.ToInt32(ddlLop.SelectedValue)); ClassID = dr["ClassID"].ToString(); lblGiaoVien.Text = dr["TeacherName"].ToString(); } //Lịch học của lớp này tv1 = new ThuVien(); DataTable tbSchedule = tv1.SP_SelectDataTable("USP_Schedule_GetBySomeConditional", new string[] { "@flag", "@ClassID" }, new object[] { 2, ClassID }); //if (tbSchedule.Rows.Count > 0) //{ DataRow drSchedule = tbSchedule.NewRow(); drSchedule["ScheduleID"] = 0; drSchedule["Date"] = "-- Chọn ngày --"; tbSchedule.Rows.InsertAt(drSchedule, 0); ddlNgayThuNhat.DataSource = tbSchedule; ddlNgayThuNhat.DataTextField = "Date"; ddlNgayThuNhat.DataValueField = "ScheduleID"; ddlNgayThuNhat.DataBind(); ddlNgayThuHai.DataSource = tbSchedule; ddlNgayThuHai.DataTextField = "Date"; ddlNgayThuHai.DataValueField = "ScheduleID"; ddlNgayThuHai.DataBind(); // } //Danh sách Học viên tv1 = new ThuVien(); tbPeople = tv1.SP_SelectDataTable("USP_Student_GetBySomeConditional", new string[] { "@flag", "@ClassID", "@StudentStatusID" }, new object[] { 11, ClassID, 2 }); if (tbPeople.Rows.Count > 0) { DataRow drPeople = tbPeople.NewRow(); drPeople["StudentID"] = 0; drPeople["StudentName"] = "-- Chọn tên --"; tbPeople.Rows.InsertAt(drPeople, 0); ddlHocVien.DataSource = tbPeople; ddlHocVien.DataTextField = "StudentName"; ddlHocVien.DataValueField = "StudentID"; ddlHocVien.DataBind(); } }
protected void ddlHocVien_SelectedIndexChanged(object sender, EventArgs e) { StudentID = ddlHocVien.SelectedValue; tv1 = new ThuVien(); tbEnterClass = tv1.SP_SelectDataTable("USP_EnterClass_GetBySomeConditional", new string[] { "@flag", "@StudentID" }, new object[] { 2, StudentID }); if (tbEnterClass.Rows.Count > 0) { lblNgayNhapHoc.Text = Convert.ToDateTime(tbEnterClass.Rows[0]["EnterClassDate"]).ToString("dd/MM/yyyy"); lblNgayTinhHP.Text = Convert.ToDateTime(tbEnterClass.Rows[0]["PayDate"]).ToString("dd/MM/yyyy"); Session["EnterClassID"] = tbEnterClass.Rows[0]["EnterClassID"]; } //Danh sách những ngày học tiếp theo tv2 = new ThuVien(); DataTable tb = tv2.SP_SelectDataTable("USP_Study_GetBySomeConditional", new string[] { "@flag", "@StudentID" }, new object[] { 0, StudentID }); if (tb.Rows.Count > 0) { DataRow dr = tb.NewRow(); dr["StudyID"] = 0; dr["Ngay"] = "-- Chọn ngày --"; tb.Rows.InsertAt(dr, 0); ddlNgayThuNhat.DataSource = tb; ddlNgayThuNhat.DataTextField = "Ngay"; ddlNgayThuNhat.DataValueField = "StudyID"; ddlNgayThuNhat.DataBind(); // ddlNgayThuHai.DataSource = tb; ddlNgayThuHai.DataTextField = "Ngay"; ddlNgayThuHai.DataValueField = "StudyID"; ddlNgayThuHai.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Bind data cho combobox ddlTrungTam Start tv1 = new ThuVien(); tbBranch = tv1.SP_SelectDataTable("USP_Branch_GetAll", new string[] { "@First", "@Count" }, new object[] { "0", "10" }); DataRow drBranch = tbBranch.NewRow(); drBranch["BranchID"] = 0; drBranch["BranchName"] = "-- Tất cả --"; tbBranch.Rows.InsertAt(drBranch, 0); ddlTrungTam.DataSource = tbBranch; ddlTrungTam.DataTextField = "BranchName"; ddlTrungTam.DataValueField = "BranchID"; ddlTrungTam.DataBind(); txtNgayDeIn.Text = DateTime.Now.ToString("dd/MM/yyyy"); } btnPreview_Click(null, null); }
protected void brnPrint_Click(object sender, EventArgs e) { ReportDocument rpt = new ReportDocument(); CrystalReportViewer1.Enabled = true; string str = "rptClassReport.rpt"; rpt.Load(Server.MapPath(str)); ///////////////////// //Get danh sách lớp dưới db tv1 = new ThuVien(); DataTable dt = tv1.SP_SelectDataTable("USP_Statistic_ClassesReport", new string[] { "@BranchID" }, new object[] { ddlTrungTam.SelectedValue }); dsForReport.LopDataTable lopDataTable = new dsForReport.LopDataTable(); string[] sParam; string hs; hs = ""; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { DataRow r = lopDataTable.NewRow(); //Khuôn dạng của table trong Dataset r["idLop"] = dt.Rows[i]["idLop"]; r["tenlop"] = dt.Rows[i]["tenlop"]; r["giaovien"] = dt.Rows[i]["giaovien"]; // sParam = dt.Rows[i]["hs1"].ToString().Split(new char[] { ' ' }); if (sParam.Length > 2) hs = sParam[sParam.Length - 2] + " " + sParam[sParam.Length - 1]; else hs = dt.Rows[i]["hs1"].ToString(); r["hs1"] = hs; r["phone1"] = dt.Rows[i]["phone1"]; // sParam = dt.Rows[i]["hs2"].ToString().Split(new char[] { ' ' }); if (sParam.Length > 2) hs = sParam[sParam.Length - 2] + " " + sParam[sParam.Length - 1]; else hs = dt.Rows[i]["hs2"].ToString(); r["hs2"] = hs; r["phone2"] = dt.Rows[i]["phone2"]; // sParam = dt.Rows[i]["hs2"].ToString().Split(new char[] { ' ' }); if (sParam.Length > 2) hs = sParam[sParam.Length - 2] + " " + sParam[sParam.Length - 1]; else hs = dt.Rows[i]["hs3"].ToString(); r["hs3"] = hs; r["phone3"] = dt.Rows[i]["phone3"]; // sParam = dt.Rows[i]["hs4"].ToString().Split(new char[] { ' ' }); if (sParam.Length > 2) hs = sParam[sParam.Length - 2] + " " + sParam[sParam.Length - 1]; else hs = dt.Rows[i]["hs4"].ToString(); r["hs4"] = hs; r["phone4"] = dt.Rows[i]["phone4"]; // sParam = dt.Rows[i]["hs5"].ToString().Split(new char[] { ' ' }); if (sParam.Length > 2) hs = sParam[sParam.Length - 2] + " " + sParam[sParam.Length - 1]; else hs = dt.Rows[i]["hs5"].ToString(); r["hs5"] = hs; r["phone5"] = dt.Rows[i]["phone5"]; // sParam = dt.Rows[i]["hs6"].ToString().Split(new char[] { ' ' }); if (sParam.Length > 2) hs = sParam[sParam.Length - 2] + " " + sParam[sParam.Length - 1]; else hs = dt.Rows[i]["hs6"].ToString(); r["hs6"] = hs; r["phone6"] = dt.Rows[i]["phone6"]; lopDataTable.Rows.Add(r); //Thêm vào bảng có khuôn dạng trong dataset } ////////////////////////////////////////// //rpt.SetDataSource((DataTable)lopDataTable); CrystalReportViewer1.ReportSource = rpt; CrystalReportViewer1.Visible = true; } }
private int fnCalBaoLuu() { tv = new ThuVien(); dt = tv.SP_SelectDataTable("USP_Study_GetBySomeConditional", new string[] { "@flag", "@StudentID", "@Date" }, new object[] { 3, selectedPeopleID, Convert.ToDateTime(txtNgayBaoLuu.Text).ToString("MM/dd/yyyy") }); if (txtNgayBaoLuu.Text.Equals("")) { lblTrangThai.Text = "<br/>Chọn ngày Bảo lưu chuyển"; return 0; } else if (Convert.ToDateTime(txtNgayBaoLuu.Text) < DateTime.Now.Date) { lblTrangThai.Text = "<br/>Ngày Bảo lưu k hợp lý."; return 0; } else if (dt.Rows.Count > 0) { txtNgayBaoLuu.Text = Convert.ToDateTime(dt.Rows[0]["NgayBaoLuu"]).ToString("dd/MM/yyyy"); lblTrangThai.ForeColor = System.Drawing.Color.Yellow; lblTrangThai.Text = "Học tại: " + dt.Rows[0]["BranchName"] + ", " + dt.Rows[0]["ClassName"] + " chưa học: " + dt.Rows[0]["SoBuoiChuaHoc"] + " , sẽ được bảo lưu"; return 1; } else { lblTrangThai.ForeColor = System.Drawing.Color.Red; lblTrangThai.Text = "_Không còn buổi học nào"; return 0; } }
private void f_ShowData() { gvPhongHc.Columns[2].Visible = true; gvPhongHc.Columns[3].Visible = true; gvPhongHc.Columns[5].Visible = true; gvPhongHc.Columns[6].Visible = true; gvPhongHc.Columns[7].Visible = true; gvPhongHc.Columns[12].Visible = true; //gvPhongHc.Columns[11].Visible = true; tv5 = new ThuVien(); tbEnterClass = tv5.SP_SelectDataTable("USP_EnterClass_GetBySomeConditional", new string[] { "@flag", "@First", "@Count" }, new object[] { 1, "0", "1000" }); gvPhongHc.DataSource = tbEnterClass; gvPhongHc.DataBind(); Session["tbEnterClass"] = tbEnterClass; //Tự mở khóa Khi chạy if (Session["isHideAspectParameter"] + "" == "1") { gvPhongHc.Columns[2].Visible = false; gvPhongHc.Columns[3].Visible = false; gvPhongHc.Columns[5].Visible = false; gvPhongHc.Columns[6].Visible = false; gvPhongHc.Columns[7].Visible = false; gvPhongHc.Columns[12].Visible = false; //gvPhongHc.Columns[10].Visible = false; // gvPhongHc.Columns[11].Visible = false; } setEmpty(); }
protected void gvPhongHc_SelectedIndexChanged(object sender, EventArgs e) { //xóa các textbox setEmpty(); try { EnterClassID = gvPhongHc.SelectedDataKey["EnterClassID"].ToString(); ddlTrungTam.SelectedIndex = ddlTrungTam.Items.IndexOf(ddlTrungTam.Items.FindByValue(Convert.ToString(gvPhongHc.SelectedRow.Cells[3].Text))); ddlTrungTam_SelectedIndexChanged(null, null); string BranchID = ddlTrungTam.SelectedValue.ToString(); ddlLop.Items.Clear(); ddlHocVien.Items.Clear(); //Lấy các lớp thuộc chi nhánh tv2 = new ThuVien(); tbClass = tv2.SP_SelectDataTable("USP_Class_GetBySomeConditional", new string[] { "@flag", "@BranchID" }, new object[] { 1, BranchID }); DataRow drBranchInClass = tbClass.NewRow(); drBranchInClass["ClassID"] = 0; drBranchInClass["ClassName"] = "-- Chọn --"; tbClass.Rows.InsertAt(drBranchInClass, 0); ddlLop.DataSource = tbClass; ddlLop.DataTextField = "ClassName"; ddlLop.DataValueField = "ClassID"; ddlLop.DataBind(); ddlLop.SelectedIndex = ddlLop.Items.IndexOf(ddlLop.Items.FindByValue(Convert.ToString(gvPhongHc.SelectedRow.Cells[5].Text))); //Lấy tên giáo viên chủ nhiệm tbClass.PrimaryKey = new DataColumn[] { tbClass.Columns["ClassID"] }; DataRow dr = tbClass.Rows.Find(Convert.ToInt32(ddlLop.SelectedValue)); lblGiaoVien.Text = dr["TeacherName"].ToString(); ddlTrinhDo.SelectedIndex = ddlTrinhDo.Items.IndexOf(ddlTrinhDo.Items.FindByValue(Convert.ToString(gvPhongHc.SelectedRow.Cells[7].Text))); int stuID = Convert.ToInt32(gvPhongHc.SelectedRow.Cells[12].Text); string stuName = HttpUtility.HtmlDecode(gvPhongHc.SelectedRow.Cells[13].Text); Dictionary<int, string> listItm = new Dictionary<int, string>(); listItm.Add(stuID, stuName); ddlHocVien.DataSource = listItm; ddlHocVien.DataTextField = "Value"; ddlHocVien.DataValueField = "Key"; ddlHocVien.DataBind(); //Dont del this: Nếu đã đóng Học phí thì Ẩn textbox Ngày Nhập học //tv1 = new ThuVien(); //int isPayAny = tv1.SP_ExcecutePro("USP_SchoolFee_GetBySomeCondition", new string[] { "@flag", "@StudentID" }, new object[] { "2", stuID }); //if (isPayAny != 0) //{ // txtNgayNhapHoc.Enabled = false; //} //else //{ // txtNgayNhapHoc.Enabled = true; //} string strNgayNhapHoc = HttpUtility.HtmlDecode(gvPhongHc.SelectedRow.Cells[16].Text).Trim(); if (strNgayNhapHoc + "" != "") { txtNgayNhapHoc.Text = Convert.ToDateTime(strNgayNhapHoc).ToString("dd/MM/yyyy"); } txtGhiChu.Text = HttpUtility.HtmlDecode(gvPhongHc.SelectedRow.Cells[15].Text); Session["EnterClassID"] = gvPhongHc.SelectedRow.Cells[2].Text; Session["themsua"] = 2; f_ThemXoaLuu(true, true, true); } catch (Exception ex) { //Gửi email báo lỗi sendEmail.SendMailForTechnical("*****@*****.**", "Lỗi", ex.ToString(), true); } }
private void f_ShowData() { setEmpty(); //gvPhongHc.Columns[1].Visible = true; // gvPhongHc.Columns[2].Visible = true; //gvPhongHc.Columns[4].Visible = true; //gvPhongHc.Columns[9].Visible = true; //gvPhongHc.Columns[13].Visible = true; //gvPhongHc.Columns[14].Visible = true; //cm tv2 = new ThuVien(); tb = tv2.SP_SelectDataTable("USP_TeacherType_GetAll", new string[] { "@First", "@Count" }, new object[] { "0", "100" }); gvPhongHc.DataSource = tb; gvPhongHc.DataBind(); Session["tbTeacherType"] = tb; //gvPhongHc.Columns[1].Visible = false; //gvPhongHc.Columns[2].Visible = false; //cm gvPhongHc.Columns[4].Visible = false; //cm gvPhongHc.Columns[9].Visible = false; //cm gvPhongHc.Columns[13].Visible = false; //cm gvPhongHc.Columns[14].Visible = false; setEmpty(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Page.Title = "Xep luong theo Rank"; //Nếu không có quyền cho trang thì Cút bool ChoDiTiep; ChoDiTiep = false; DataTable tbQuyen = (DataTable)Session["tbQuyen"]; if (tbQuyen != null) { if (tbQuyen.Rows.Count > 0) { foreach (DataRow dr_q in tbQuyen.Rows) { if ((dr_q["ObjectCode"].ToString() == "multiLienQuanLuongGV") && (dr_q["AllowAccess"] + "" == "True")) { ChoDiTiep = true; break; } } } } if (ChoDiTiep == false) { Response.Redirect(WebConfigurationManager.AppSettings["WebHome"]); } btnXoa.Attributes.Add("onClick", "javascript:return confirm('Bạn có chắc muốn xoá dữ liệu?');"); //Bind data cho combobox ddlLoaiGiaoVien Start tv1 = new ThuVien(); tbTeacherType = tv1.SP_SelectDataTable("USP_TeacherType_GetAll", new string[] { "@First", "@Count" }, new object[] { "0", "10" }); DataRow drTeacherType = tbTeacherType.NewRow(); drTeacherType["TeacherTypeID"] = DBNull.Value; drTeacherType["TeacherTypeName"] = "-- Chọn --"; tbTeacherType.Rows.InsertAt(drTeacherType, 0); ddlLoaiGiaoVien.DataSource = tbTeacherType; ddlLoaiGiaoVien.DataTextField = "TeacherTypeName"; ddlLoaiGiaoVien.DataValueField = "TeacherTypeID"; ddlLoaiGiaoVien.DataBind(); //Bind data cho combobox ddlTrungTam Start tv1 = new ThuVien(); tbBranch = tv1.SP_SelectDataTable("USP_Branch_GetAll", new string[] { "@First", "@Count" }, new object[] { "0", "10" }); DataRow drBranch = tbBranch.NewRow(); drBranch["BranchID"] = DBNull.Value; drBranch["BranchName"] = "-- Giống nhau --"; tbBranch.Rows.InsertAt(drBranch, 0); ddlTrungTam.DataSource = tbBranch; ddlTrungTam.DataTextField = "BranchName"; ddlTrungTam.DataValueField = "BranchID"; ddlTrungTam.DataBind(); f_ShowData(); } }
private void f_ShowData() { gvPhongHc.Columns[3].Visible = true; gvPhongHc.Columns[4].Visible = true; tv1 = new ThuVien(); tbTeacherSalary = tv1.SP_SelectDataTable("USP_TeacherSalary_GetBySomeConditional", new string[] { "@flag", "@First", "@Count" }, new object[] { 2, "0", "1000" }); gvPhongHc.DataSource = tbTeacherSalary; gvPhongHc.DataBind(); Session["tbTeacherSalary"] = tbTeacherSalary; gvPhongHc.Columns[3].Visible = false; gvPhongHc.Columns[4].Visible = false; setEmpty(); }
private void f_ShowData() { setEmpty(); gvPhongHc.Columns[2].Visible = true; gvPhongHc.Columns[4].Visible = true; gvPhongHc.Columns[5].Visible = true; gvPhongHc.Columns[8].Visible = true; //cmGridview1.Columns[13].Visible = true; //cmGridview1.Columns[14].Visible = true; //cm tv2 = new ThuVien(); tb = tv2.SP_SelectDataTable("USP_Degree_GetBySomeConditional", new string[] { "@Flag" }, new object[] { 1 }); gvPhongHc.DataSource = tb; gvPhongHc.DataBind(); Session["tbDegree"] = tb; if (Session["isHideAspectParameter"] + "" == "1") { gvPhongHc.Columns[2].Visible = false; gvPhongHc.Columns[4].Visible = false; gvPhongHc.Columns[5].Visible = false; gvPhongHc.Columns[8].Visible = false; } setEmpty(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Page.Title = "Danh muc Trinh do"; //Nếu không có quyền cho trang thì Cút bool ChoDiTiep; ChoDiTiep = false; //DataTable tbQuyen = (DataTable)Session["tbQuyen"]; //if (tbQuyen != null) //{ // if (tbQuyen.Rows.Count > 0) // { // foreach (DataRow dr_q in tbQuyen.Rows) // { // if ((dr_q["ObjectCode"].ToString() == "mnDegree") && (dr_q["AllowAccess"] + "" == "True")) // { // ChoDiTiep = true; // break; // } // } // } //} //if (ChoDiTiep == false) //{ // Response.Redirect(WebConfigurationManager.AppSettings["WebHome"]); //} //.................. btnXoa.Attributes.Add("onClick", "javascript:return confirm('Bạn có chắc muốn xoá dữ liệu?');"); Session["themsua"] = 1; tv1 = new ThuVien(); tb = tv1.SP_SelectDataTable("USP_DegreeType_GetBySomeConditional", new string[] { "@flag" }, new object[] { 1 }); DataRow dr = tb.NewRow(); dr["DegreeTypeID"] = 0; dr["DegreeTypeName"] = "-- Chọn --"; tb.Rows.InsertAt(dr, 0); ddlLoaiChuongTrinh.DataSource = tb; ddlLoaiChuongTrinh.DataTextField = "DegreeTypeName"; ddlLoaiChuongTrinh.DataValueField = "DegreeTypeID"; ddlLoaiChuongTrinh.DataBind(); f_ShowData(); f_ThemXoaLuu(false, false, true); } }
private int fnCalChuyenLop() { txtNgayChuyenLop.Text = txtNgayChuyenLop.Text.Trim(); //lblSoBuoiCon.ForeColor = System.Drawing.Color.Red; lblThongBao.ForeColor = System.Drawing.Color.Red; if (!((Session["ClassID"] + "" != "") && (Session["ClassID"] + "" == ddlLop.SelectedValue) && (Session["BranchID"] + "" == ddlTrungTam.SelectedValue))) { if (txtNgayChuyenLop.Text.Equals("")) { lblSoBuoiCon.Text = "<br/>Chọn ngày chuyển"; return 0; } else if (Convert.ToDateTime(txtNgayChuyenLop.Text) < DateTime.Now.Date) { lblSoBuoiCon.Text = "<br/>Ngày chuyển k hợp lý."; return 0; } else if (!chkChuyenLop.Checked) { lblThongBao.Text = "Check để xác nhận chuyển lớp"; return 0; } else if (Session["StudentStatusID"] + "" == "2") { tv = new ThuVien(); tbDegree = tv.SP_SelectDataTable("USP_Study_GetBySomeConditional", new string[] { "@flag", "@BranchID", "@ClassID", "@DegreeID", "@NewBranchID", "@NewClassID", "@Dic_SchoolFeeID", "@NewEnterClassDate", "@StudentID" }, new object[] { 4, Session["BranchID"], Session["ClassID"], Session["DegreeID"], ddlTrungTam.SelectedValue, ddlLop.SelectedValue, ddlTrinhDo.SelectedValue, Convert.ToDateTime(txtNgayChuyenLop.Text).ToString("MM/dd/yyyy"), Session["selectedPeopleID"] }); lblSoBuoiCon.Text = tbDegree.Rows[0]["SoBuoiMoi"].ToString(); Session["NewSchoolFee"] = tbDegree.Rows[0]["NewSchoolFee"]; return 1; } else if (Session["StudentStatusID"] + "" == "3") //Đang bảo lưu -> Đang học: Đi học lại có chuyển lớp { tv = new ThuVien(); DataTable dt = tv.SP_SelectDataTable("USP_Study_GetBySomeConditional", new string[] { "@flag", "@Dic_SchoolFeeID", "@StudentID" }, new object[] { 6, ddlTrinhDo.SelectedValue, Session["selectedPeopleID"] }); lblSoBuoiCon.Text = dt.Rows[0]["TotalSession"].ToString(); Session["NewSchoolFee"] = dt.Rows[0]["Money"]; return 1; } } else //Vẫn học lớp cũ { if (Session["StudentStatusID"] + "" == "3") //Đang bảo lưu -> Đang học { tv = new ThuVien(); DataTable dt = tv.SP_SelectDataTable("USP_Study_GetBySomeConditional", new string[] { "@flag", "@StudentID" }, new object[] { 5, Session["selectedPeopleID"] }); lblSoBuoiCon.Text = dt.Rows[0]["TotalSession"].ToString(); Session["NewSchoolFee"] = dt.Rows[0]["Money"]; return 1; } } return 1; }
protected void ddlTrungTam_SelectedIndexChanged(object sender, EventArgs e) { string BranchID = ddlTrungTam.SelectedValue.ToString(); tv2 = new ThuVien(); tbClass = tv2.SP_SelectDataTable("USP_Class_GetBySomeConditional", new string[] {"@flag", "@BranchID" }, new object[] {1, BranchID }); DataRow drBranchInClass = tbClass.NewRow(); drBranchInClass["ClassID"] = 0; drBranchInClass["ClassName"] = "-- Chọn --"; tbClass.Rows.InsertAt(drBranchInClass, 0); ddlLop.DataSource = tbClass; ddlLop.DataTextField = "ClassName"; ddlLop.DataValueField = "ClassID"; ddlLop.DataBind(); Session["tbClass"] = tbClass; }
protected void ddlXepLoai_SelectedIndexChanged(object sender, EventArgs e) { tv = new ThuVien(); dt = tv.SP_SelectDataTable("USP_TeacherSalary_GetBySomeConditional", new string[] { "@flag", "@TeacherTypeID" }, new object[] { 1, ddlXepLoai.SelectedValue }); if (dt.Rows.Count > 0 && dt.Rows[0]["MonthlySalary"] + "" != "") { lblLuong.Text = Convert.ToDecimal(dt.Rows[0]["MonthlySalary"]).ToString("#,###"); } else lblLuong.Text = "Chưa xác định"; }
protected void Page_Load(object sender, EventArgs e) { Page.Title = "Nhap hoc"; if (!IsPostBack) { //Nếu không có quyền cho trang thì Cút bool ChoDiTiep; ChoDiTiep = false; DataTable tbQuyen = (DataTable)Session["tbQuyen"]; if (tbQuyen != null) { if (tbQuyen.Rows.Count > 0) { foreach (DataRow dr_q in tbQuyen.Rows) { if ((dr_q["ObjectCode"].ToString() == "mnNhapHoc") && (dr_q["AllowAccess"] + "" == "True")) { ChoDiTiep = true; break; } } } } if (ChoDiTiep == false) { Response.Redirect(WebConfigurationManager.AppSettings["WebHome"]); } //....................... btnXoa.Attributes.Add("onClick", "javascript:return confirm('Bạn có chắc muốn xoá dữ liệu?');"); //Bind data cho combobox ddlTrungTam Start tv1 = new ThuVien(); tbBranch = tv1.SP_SelectDataTable("USP_Branch_GetAll", new string[] { "@First", "@Count" }, new object[] { "0", "10" }); DataRow drBranch = tbBranch.NewRow(); drBranch["BranchID"] = 0; drBranch["BranchName"] = "-- Chọn --"; tbBranch.Rows.InsertAt(drBranch, 0); ddlTrungTam.DataSource = tbBranch; ddlTrungTam.DataTextField = "BranchName"; ddlTrungTam.DataValueField = "BranchID"; ddlTrungTam.DataBind(); //ddl trình độ tv1 = new ThuVien(); tbDegree = tv1.SP_SelectDataTable("USP_Degree_GetBySomeConditional", new string[] { "@flag" }, new object[] { "2" }); DataRow drDegree = tbDegree.NewRow(); drDegree["DegreeID"] = 0; drDegree["DegreeNameVN"] = "-- Chọn --"; tbDegree.Rows.InsertAt(drDegree, 0); ddlTrinhDo.DataSource = tbDegree; ddlTrinhDo.DataTextField = "DegreeNameVN"; ddlTrinhDo.DataValueField = "DegreeID"; ddlTrinhDo.DataBind(); Session["tbDegree"] = tbDegree; Session["themsua"] = 1; f_ShowData(); //set tháng năm hiện tại DateTime dtnow = DateTime.Now; txtNgayNhapHoc.Text = dtnow.ToString("dd/MM/yyyy"); //f_ThemXoaLuu(false, false, true); //Get giá trị redirect từ trang khác string tt = Request.QueryString["tt"]; if (!string.IsNullOrEmpty(tt)) { ddlTrungTam.SelectedIndex = ddlTrungTam.Items.IndexOf(ddlTrungTam.Items.FindByValue(Convert.ToString(tt))); ddlTrungTam_SelectedIndexChanged(null, null); } string cl = Request.QueryString["cl"]; if (!string.IsNullOrEmpty(cl)) { ddlLop.SelectedIndex = ddlLop.Items.IndexOf(ddlLop.Items.FindByValue(Convert.ToString(cl))); ddlLop_SelectedIndexChanged(null, null); } if (Session["isHideAspectParameter"] + "" == "1") { stt_col.Visible = false; } //gvPhongHc.PageSize = Convert.ToInt32(WebConfigurationManager.AppSettings["PageSize"]); } }
protected void btnPreview_Click(object sender, EventArgs e) { ReportDocument crystalReport = new ReportDocument(); crystalReport.Load(Server.MapPath("~/Report/rptClassReport.rpt")); DataTable dt; dsForReport.LopDataTable lopDataTable = new dsForReport.LopDataTable(); //Get danh sách lớp dưới db tv1 = new ThuVien(); dt = tv1.SP_SelectDataTable("USP_Statistic_ClassesReport", new string[] { "@BranchID", "@ReportDate" }, new object[] { ddlTrungTam.SelectedValue, Convert.ToDateTime(txtNgayDeIn.Text).ToString("MM/dd/yyyy") }); string[] sParam; string hs; hs = ""; string tenlop=""; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { DataRow r = lopDataTable.NewRow(); //Khuôn dạng của table trong Dataset r["idLop"] = dt.Rows[i]["idLop"]; tenlop= dt.Rows[i]["tenlop"].ToString(); r["tenlop"] = tenlop.Substring(0, tenlop.IndexOf("(")) + "/ " + dt.Rows[i]["tenphong"]; r["giaovien"] = dt.Rows[i]["giaovien"]; // sParam = dt.Rows[i]["hs1"].ToString().Replace(" ", " ").Split(new char[] { ' ' }); if (sParam.Length > 2) hs = sParam[sParam.Length - 2] + " " + sParam[sParam.Length - 1]; else hs = dt.Rows[i]["hs1"].ToString(); r["hs1"] = hs; r["phone1"] = dt.Rows[i]["phone1"]; // sParam = dt.Rows[i]["hs2"].ToString().Replace(" ", " ").Split(new char[] { ' ' }); if (sParam.Length > 2) hs = sParam[sParam.Length - 2] + " " + sParam[sParam.Length - 1]; else hs = dt.Rows[i]["hs2"].ToString(); r["hs2"] = hs; r["phone2"] = dt.Rows[i]["phone2"]; // sParam = dt.Rows[i]["hs3"].ToString().Replace(" ", " ").Split(new char[] { ' ' }); if (sParam.Length > 2) hs = sParam[sParam.Length - 2] + " " + sParam[sParam.Length - 1]; else hs = dt.Rows[i]["hs3"].ToString(); r["hs3"] = hs; r["phone3"] = dt.Rows[i]["phone3"]; // sParam = dt.Rows[i]["hs4"].ToString().Replace(" ", " ").Split(new char[] { ' ' }); if (sParam.Length > 2) hs = sParam[sParam.Length - 2] + " " + sParam[sParam.Length - 1]; else hs = dt.Rows[i]["hs4"].ToString(); r["hs4"] = hs; r["phone4"] = dt.Rows[i]["phone4"]; // sParam = dt.Rows[i]["hs5"].ToString().Replace(" ", " ").Split(new char[] { ' ' }); if (sParam.Length > 2) hs = sParam[sParam.Length - 2] + " " + sParam[sParam.Length - 1]; else hs = dt.Rows[i]["hs5"].ToString(); r["hs5"] = hs; r["phone5"] = dt.Rows[i]["phone5"]; // sParam = dt.Rows[i]["hs6"].ToString().Replace(" ", " ").Split(new char[] { ' ' }); if (sParam.Length > 2) hs = sParam[sParam.Length - 2] + " " + sParam[sParam.Length - 1]; else hs = dt.Rows[i]["hs6"].ToString(); r["hs6"] = hs; r["phone6"] = dt.Rows[i]["phone6"]; lopDataTable.Rows.Add(r); //Thêm vào bảng có khuôn dạng trong dataset } //QUESTION: dataset đéo chạy, bắt nhập Mật khẩu //dsreport.Tables.Add((DataTable)lopDataTable); //ép kiểu về dạng table bình thường //Truyền một số giá trị vào form CrystalDecisions.CrystalReports.Engine.TextObject str_txtDate; str_txtDate = (CrystalDecisions.CrystalReports.Engine.TextObject)crystalReport.ReportDefinition.ReportObjects["txtDate"]; str_txtDate.Text = "DATE: " + txtNgayDeIn.Text; //DateTime.Now.ToString("dd/MM/yyyy"); CrystalDecisions.CrystalReports.Engine.TextObject str_txtTenTT; str_txtTenTT = (CrystalDecisions.CrystalReports.Engine.TextObject)crystalReport.ReportDefinition.ReportObjects["txtTenTT"]; str_txtTenTT.Text = "Center: " + ddlTrungTam.SelectedItem.Text; crystalReport.SetDataSource((DataTable)lopDataTable); CrystalReportViewer1.ReportSource = crystalReport; } }
protected void btnSearch_Click(object sender, EventArgs e) { ddlHocVien.Items.Clear(); string Name = txtTimHV.Text; tv4 = new ThuVien(); tbPeople = tv4.SP_SelectDataTable("USP_People_GetBySomeConditional", new string[] { "@flag", "@PeopleName", "@PeopleCode" }, new object[] { 7, Name, "HV" }); if (tbPeople.Rows.Count > 0) { DataRow drPeople = tbPeople.NewRow(); drPeople["PeopleID"] = 0; drPeople["PeopleName"] = "-- Các học viên tìm được --"; tbPeople.Rows.InsertAt(drPeople, 0); ddlHocVien.DataSource = tbPeople; ddlHocVien.DataTextField = "PeopleName"; ddlHocVien.DataValueField = "PeopleID"; ddlHocVien.DataBind(); } else { if (Name.Equals("")) lblThongBao.Text = "Các Học viên đã nhập học đầy đủ"; else lblThongBao.Text = "Không tìm được Học viên nào theo điều kiện trên"; } }
private void BoTriThongTinVaoViTri(string BranchID, string ClassID, string Dic_SchoolFeeID) { ddlTrungTam.SelectedIndex = ddlTrungTam.Items.IndexOf(ddlTrungTam.Items.FindByValue(BranchID)); //return; //ddlTrungTam_SelectedIndexChanged(null, null); ddlLop.Items.Clear(); //Lấy các lớp thuộc chi nhánh tv = new ThuVien(); tbClass = tv.SP_SelectDataTable("USP_Class_GetBySomeConditional", new string[] { "@flag", "@BranchID" }, new object[] { 1, BranchID }); DataRow drClassInBranch = tbClass.NewRow(); drClassInBranch["ClassID"] = 0; drClassInBranch["ClassName"] = "-- Chọn --"; tbClass.Rows.InsertAt(drClassInBranch, 0); ddlLop.DataSource = tbClass; ddlLop.DataTextField = "ClassName"; ddlLop.DataValueField = "ClassID"; ddlLop.DataBind(); ddlLop.SelectedIndex = ddlLop.Items.IndexOf(ddlLop.Items.FindByValue(ClassID)); //return; //Lấy tên giáo viên chủ nhiệm tbClass.PrimaryKey = new DataColumn[] { tbClass.Columns["ClassID"] }; DataRow dr = tbClass.Rows.Find(Convert.ToInt32(ddlLop.SelectedValue)); //lblGiaoVien.Text = dr["TeacherName"].ToString(); ddlTrinhDo.SelectedIndex = ddlTrinhDo.Items.IndexOf(ddlTrinhDo.Items.FindByValue(Dic_SchoolFeeID)); //question: tại sao cần dòng dưới đây //ddlTrinhDo_SelectedIndexChanged(null, null); }
protected void Page_Load(object sender, EventArgs e) { if (Session["PeopleCode"] + "" == "" || Session["PeopleCode"].ToString() == "HV") Response.Redirect("?s=home"); // string qs = Request.QueryString["PeopleID"]; if (!Common.IsNumeric(qs)) { lblThongBao.Text = "Không tìm thấy dữ liệu"; return; } selectedPeopleID = Convert.ToInt32(qs); if (!IsPostBack) { Page.Title = "Cap nhat Thanh vien"; Session["selectedPeopleID"] = selectedPeopleID; btnXoa.Attributes.Add("onClick", "javascript:return confirm('Bạn có chắc muốn xoá dữ liệu?');"); //Xet quyen login vao trang Start if (Session["lstLoginMenu"] != null) { List<LoginMenuAuthority_Model> lstLoginMenu = (List<LoginMenuAuthority_Model>)Session["lstLoginMenu"]; string url = HttpContext.Current.Request.RawUrl; string[] ArrUrl = url.Split('?'); string urlCheck = "?" + ArrUrl[1]; for (int i = 0; i < lstLoginMenu.Count; i++) { if (lstLoginMenu[i].HREF == urlCheck && lstLoginMenu[i].Security == 0) { //Session["URLRedirectAfterLogin"] = HttpContext.Current.Request.RawUrl;//Luu session cho trang muon vao Response.Redirect("?s=sigin"); return; } } } else { //Session["URLRedirectAfterLogin"] = HttpContext.Current.Request.RawUrl;//Luu session cho trang muon vao Response.Redirect("?s=sigin"); return; } //Xet quyen login vao trang End imgBtnAnhAvatar.Attributes.Add("onclick", "document.getElementById('" + FileUploadAvatar.ClientID + "').click()"); daPeople.USP_People_GetByID_Reader(selectedPeopleID); daPeople.U_Fetch_Reader(true); SelectedPeopleCode = daPeople.fPeopleCode; Session["SelectedPeopleCode"] = SelectedPeopleCode; lblTenDangNhap.Text = daPeople.fUserName.ToString(); lblEmail.Text = daPeople.fEmail.ToString(); txtFirstName.Text = daPeople.fFirstName; txtLastName.Text = daPeople.fLastName; //Xử lý hiển thị ảnh if (daPeople.fPhoto != null) Session["Image"] = daPeople.fPhoto.ToString(); if (daPeople.fBirthday + "" != "") txtDateNgaySinh.Text = Common.FormatDateddMMyyyy(Convert.ToDateTime(daPeople.fBirthday)); //Thường trú txtThuongTru.Text = daPeople.fResident; txtTT_ToaDo.Text = (daPeople.fLatitude + "").ToString().Replace(",", ".") + ", " + (daPeople.fLongitude + "").ToString().Replace(",", "."); if (txtTT_ToaDo.Text == ", ") txtTT_ToaDo.Text = ""; if (Convert.ToBoolean(daPeople.fGender) == true) { RadioButtonList1.Items[0].Selected = true; } else { RadioButtonList1.Items[1].Selected = true; } //Tạm trú txtTamTru.Text = daPeople.fStayProvisionally.ToString(); txtTam_ToaDo.Text = (daPeople.fLatitudeStayProvisionally + "").ToString().Replace(",", ".") + ", " + (daPeople.fLongitudeStayProvisionally + "").ToString().ToString().Replace(",", "."); if (txtTam_ToaDo.Text == ", ") txtTam_ToaDo.Text = ""; txtCellPhone.Text = daPeople.fCellPhone.ToString(); txtHomePhone.Text = daPeople.fHomePhone.ToString(); txtYahoo.Text = daPeople.fYahoo.ToString(); txtSkyper.Text = daPeople.fSkyper.ToString(); txtFaceweb.Text = daPeople.fSocialWebiste.ToString(); txtNgheNghiep.Text = daPeople.fCareer.ToString(); //Cập nhật cho Học viên if (SelectedPeopleCode == "HV") { hv1.Visible = true; hv2.Visible = true; hv3.Visible = true; rwTrangThai.Visible = false; //Hiển thị ddlTrangThai Học viên tbStatus = tv.SP_SelectDataTable("USP_People_GetStatus", new string[] { "@PeopleCode" }, new object[] { "HV" }); DataRow dr = tbStatus.NewRow(); dr["StudentStatusID"] = 0; dr["StudentStatusName"] = "-- Chọn --"; tbStatus.Rows.InsertAt(dr, 0); ddlTrangThai.DataSource = tbStatus; ddlTrangThai.DataTextField = "StudentStatusName"; ddlTrangThai.DataValueField = "StudentStatusID"; ddlTrangThai.DataBind(); // tv = new ThuVien(); dt = tv.SP_SelectDataTable("USP_Student_GetByID", new string[] { "@StudentID" }, new object[] { selectedPeopleID }); if (dt.Rows.Count > 0) { ddlTrangThai.SelectedIndex = ddlTrangThai.Items.IndexOf(ddlTrangThai.Items.FindByValue(dt.Rows[0]["StudentStatusID"].ToString())); if (dt.Rows[0]["StudentStatusID"] + "" == "3") { hvBaoLuu.Visible = false; } Session["StudentStatusID"] = dt.Rows[0]["StudentStatusID"]; txtLoiGioiThieu.Text = dt.Rows[0]["Introduction"].ToString(); txtBaiHatUaThich.Text = dt.Rows[0]["FavouriteSong"].ToString(); txtKhaNangAmNhac.Text = dt.Rows[0]["Ability"].ToString(); } tv = new ThuVien(); DataTable tbHV = tv.SP_SelectDataTable("USP_EnterClass_GetBySomeConditional", new string[] { "@flag", "@StudentID" }, new object[] { 2, selectedPeopleID }); if (tbHV.Rows.Count > 0) { string BranchID = tbHV.Rows[0]["BranchID"].ToString(); string ClassID = tbHV.Rows[0]["ClassID"].ToString(); string DegreeID = tbHV.Rows[0]["DegreeID"].ToString(); string Dic_SchoolFeeID = tbHV.Rows[0]["Dic_SchoolFeeID"].ToString(); Session["BranchID"] = BranchID; Session["ClassID"] = ClassID; Session["DegreeID"] = DegreeID; Session["Dic_SchoolFeeID"] = Dic_SchoolFeeID; } } else if (SelectedPeopleCode.IndexOf("GV") != -1) { rwTrangThai.Visible = true; gv1.Visible = true; gv2.Visible = true; gv3.Visible = true; //load danh sách Trạng thái giáo viên tv = new ThuVien(); tbStatus = tv.SP_SelectDataTable("USP_People_GetStatus", new string[] { "@PeopleCode" }, new object[] { "GV" }); DataRow dr = tbStatus.NewRow(); dr["TeacherStatusID"] = 0; dr["TeacherStatusName"] = "-- Chọn --"; tbStatus.Rows.InsertAt(dr, 0); ddlTrangThai.DataSource = tbStatus; ddlTrangThai.DataTextField = "TeacherStatusName"; ddlTrangThai.DataValueField = "TeacherStatusID"; ddlTrangThai.DataBind(); //Load xếp loại giáo viên tv = new ThuVien(); tbXepLoai = tv.SP_SelectDataTable("USP_TeacherType_GetAll", new string[] { }, new object[] { }); dr = tbXepLoai.NewRow(); dr["TeacherTypeID"] = 0; dr["TeacherTypeName"] = "-- Chọn --"; tbXepLoai.Rows.InsertAt(dr, 0); ddlXepLoai.DataSource = tbXepLoai; ddlXepLoai.DataTextField = "TeacherTypeName"; ddlXepLoai.DataValueField = "TeacherTypeID"; ddlXepLoai.DataBind(); tv = new ThuVien(); dt = tv.SP_SelectDataTable("USP_Teacher_GetBySomeConditional", new string[] { "@flag", "@TeacherID" }, new object[] { 1, selectedPeopleID }); if (dt.Rows.Count > 0) { ddlTrangThai.SelectedIndex = ddlTrangThai.Items.IndexOf(ddlTrangThai.Items.FindByValue(dt.Rows[0]["TeacherStatusID"].ToString())); ddlXepLoai.SelectedIndex = ddlXepLoai.Items.IndexOf(ddlXepLoai.Items.FindByValue(dt.Rows[0]["TeacherTypeID"].ToString())); txtDanhGia.Text = dt.Rows[0]["Evaluate"].ToString(); if (dt.Rows[0]["MonthlySalary"] + "" != "") lblLuong.Text = Convert.ToDecimal(dt.Rows[0]["MonthlySalary"]).ToString("#,###"); } } //Hiển thị phần chi tiết lbHienChiTiet_Click(null, null); } // imgBtnAnhAvatar.ImageUrl = WebImgFolder + Session["Image"].ToString(); //Ẩn đi những phần mà Login User không có thẩm quyền //Không phải giáo viên if (Session["PeopleCode"].ToString().IndexOf("GV") == -1) { hv1.Visible = false; hv2.Visible = false; hv3.Visible = false; } //là giáo viên. Không bao gồm Operator if (Session["PeopleCode"].ToString() == "GV") { rwFace.Visible = false; txtLastName.Enabled = false; Color clDisable = ColorTranslator.FromHtml("#CCCCCC"); txtLastName.BackColor = clDisable; rwMatKhau.Visible = false; txtDateNgaySinh.Enabled = false; txtDateNgaySinh.BackColor = clDisable; rwNgheNghiep.Visible = false; txtHomePhone.Enabled = false; txtHomePhone.BackColor = clDisable; txtThuongTru.Enabled = false; txtThuongTru.BackColor = clDisable; //rwToaDoThuongTru.Visible = false; txtTamTru.Enabled = false; txtTamTru.BackColor = clDisable; //rwToaDoTamTru.Visible = false; txtFirstName.Enabled = false; txtFirstName.BackColor = clDisable; txtCellPhone.Enabled = false; txtCellPhone.BackColor = clDisable; rwXacNhanPass.Visible = false; txtYahoo.Enabled = false; txtYahoo.BackColor = clDisable; txtSkyper.Enabled = false; txtSkyper.BackColor = clDisable; rwTrangThai.Visible = false; } //Không phải hiệu trưởng if (Session["isHieuTruong"] + "" != "True") { gv1.Visible = false; gv2.Visible = false; gv3.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Page.Title = "Lich Day va Hoc"; // //Bind data cho combobox ddlTrungTam Start // tv1 = new ThuVien(); // tbBranch = tv1.SP_SelectDataTable("USP_Branch_GetAll", new string[] { "@First", "@Count" }, new object[] { "0", "10" }); // DataRow drBranch = tbBranch.NewRow(); // drBranch["BranchID"] = 0; // drBranch["BranchName"] = "-- Chọn --"; // tbBranch.Rows.InsertAt(drBranch, 0); // ddlTrungTam.DataSource = tbBranch; // ddlTrungTam.DataTextField = "BranchName"; // ddlTrungTam.DataValueField = "BranchID"; // ddlTrungTam.DataBind(); //tb1 = tv1.SP_SelectDataTable("USP_People_GetBySomeConditional", new string[] { "@flag", "@PeopleCode" }, new object[] { 4,"GV" }); //ddlGiaoVien_.DataSource = tb1; //ddlGiaoVien_.DataTextField = "PeopleName"; //ddlGiaoVien_.DataValueField = "TeacherID"; //ddlGiaoVien_.DataBind(); //Trang này cho ai vào cũng được, giảm tải thành viên đăng ký //Xet quyen login vao trang Start //if (Session["lstLoginMenu"] != null) //{ // List<LoginMenuAuthority_Model> lstLoginMenu = (List<LoginMenuAuthority_Model>)Session["lstLoginMenu"]; // string url = HttpContext.Current.Request.RawUrl; // string[] ArrUrl = url.Split('?'); // string urlCheck = "?" + ArrUrl[1]; // for (int i = 0; i < lstLoginMenu.Count; i++) // { // if (lstLoginMenu[i].HREF == urlCheck && lstLoginMenu[i].Security == 0) // { // ////Session["URLRedirectAfterLogin"] = HttpContext.Current.Request.RawUrl;//Luu session cho trang muon vao // Response.Redirect("?s=sigin"); // return; // } // } //} //else //{ // ////Session["URLRedirectAfterLogin"] = HttpContext.Current.Request.RawUrl;//Luu session cho trang muon vao // Response.Redirect("?s=sigin"); // return; //} //Xet quyen login vao trang End } //Chỉ chạy 1 lần tv1 = new ThuVien(); tb = tv1.SP_SelectDataTable("USP_ElseProcedure", new string[] { "@flag", "@Date" }, new object[] { "1", DateTime.Now }); TuanHienTai = tb.Rows[0]["OrderWeekInMonth"].ToString(); SoTuanTrongThang = tb.Rows[0]["numberWeekInMonth"].ToString(); }