public void CT() { SqlConnection BaoVe = new SqlConnection("server=(local)\\SQLEXPRESS;uid=sa;pwd=123;database=QuanLyCongVan"); SqlCommand Lenh = new SqlCommand("CV_U_TT_CT", BaoVe); Lenh.CommandType = CommandType.StoredProcedure; SqlParameter ThamSo = new SqlParameter(); ThamSo = Lenh.Parameters.AddWithValue("@So", So); SqlDataReader DocDL; BaoVe.Open(); DocDL = Lenh.ExecuteReader(); if (DocDL.Read() == true) { Ma_CV = DocDL["Ma"].ToString(); So = int.Parse(DocDL["So"].ToString()); So_CV = DocDL["So_CV"].ToString(); TenCV = DocDL["TenCV"].ToString(); TenTT = DocDL["TenTT"].ToString(); TenUser = DocDL["NguoiGui"].ToString(); Ma_User = int.Parse(DocDL["Ma_User"].ToString()); Ma_UserNhan = int.Parse(DocDL["Ma_UserNhan"].ToString()); TrichYeu = DocDL["TrichYeu"].ToString(); TenFile = DocDL["TenFile"].ToString(); NgayPH = DocDL["NgayPH"].ToString(); YKienLD = DocDL["YKienLD"].ToString(); YKienCV = DocDL["YKienCV"].ToString(); ThoiGianSoan = DocDL["ThoiGianSoan"].ToString(); ThoiGianGui = DocDL["ThoiGianGui"].ToString(); ThoiGianDoc = DocDL["ThoiGianDoc"].ToString(); ThoiGianDuyet = DocDL["ThoiGianDuyet"].ToString(); } BaoVe.Close(); }
public void CT() { SqlConnection BaoVe = new SqlConnection("server=(local)\\SQLEXPRESS;uid=sa;pwd=123;database=QuanLyCongVan"); SqlCommand Lenh = new SqlCommand("CongVan_CT", BaoVe); Lenh.CommandType = CommandType.StoredProcedure; SqlParameter ThamSo = new SqlParameter(); ThamSo = Lenh.Parameters.AddWithValue("@So", So); SqlDataReader DocDL; BaoVe.Open(); DocDL = Lenh.ExecuteReader(); if (DocDL.Read() == true) { Ma = DocDL["Ma"].ToString(); So = DocDL["So"].ToString(); Ma_LCV = int.Parse(DocDL["Ma_LCV"].ToString()); TenLCV = DocDL["TenLCV"].ToString(); TenCV = DocDL["TenCV"].ToString(); TrichYeu = DocDL["TrichYeu"].ToString(); TenFile = DocDL["TenFile"].ToString(); NgayPH = DocDL["NgayPH"].ToString(); YKienLD = DocDL["YKienLD"].ToString(); YKienCV = DocDL["YKienCV"].ToString(); //MaNT = int.Parse(DocDL["MaNT"].ToString()); //MaNVDang = int.Parse(DocDL["MaNVDang"].ToString()); //MaNVDuyet = int.Parse(DocDL["MaNVDuyet"].ToString()); } BaoVe.Close(); }
public string menu(int menuid) { string result = "<ul>"; SqlConnection BaoVe = new SqlConnection("server=(local)\\SQLEXPRESS;uid=sa;pwd=123;database=QuanLyCongVan"); SqlCommand Lenh = new SqlCommand("Menu_Lay", BaoVe); Lenh.CommandType = CommandType.StoredProcedure; SqlParameter ThamSo = new SqlParameter(); ThamSo = Lenh.Parameters.AddWithValue("@CNMe", menuid); SqlDataReader DocDL; BaoVe.Open(); DocDL = Lenh.ExecuteReader(); //đọc tất cả category con từ cơ sở dữ liệu có id mẹ là menuid (cần thiết phải có cột id category mẹ) //sau đó: if (DocDL.Read() == true)//kiểm tra số phần tử con lấy được { result += "<li><a href='#'>" + DocDL["TenCN"].ToString() + "</a></li>"; result = result + "</ul>"; menu(Convert.ToInt32(DocDL["Ma"])); return(result); } else //nếu ko có phần tử nào { return(result); } }
public void LaySo(string So_CV, int Ma_User) { SqlConnection BaoVe = new SqlConnection("server=(local)\\SQLEXPRESS;uid=sa;pwd=123;database=QuanLyCongVan"); SqlCommand Lenh = new SqlCommand("CUT_LaySo", BaoVe); Lenh.CommandType = CommandType.StoredProcedure; SqlParameter ThamSo = new SqlParameter(); ThamSo = Lenh.Parameters.AddWithValue("@So_CV", So_CV); ThamSo = Lenh.Parameters.AddWithValue("@Ma_User", Ma_User); SqlDataReader DocDL; BaoVe.Open(); DocDL = Lenh.ExecuteReader(); if (DocDL.Read() == true)//nếu có dữ liệu để đọc { So = int.Parse(DocDL["So"].ToString()); } BaoVe.Close(); }
public void CT() { SqlConnection BaoVe = new SqlConnection("server=(local)\\SQLEXPRESS;uid=sa;pwd=123;database=QuanLyCongVan"); SqlCommand Lenh = new SqlCommand("TinhTrang_CT", BaoVe); Lenh.CommandType = CommandType.StoredProcedure; SqlParameter ThamSo = new SqlParameter(); ThamSo = Lenh.Parameters.AddWithValue("@Ma", Ma); SqlDataReader DocDL; BaoVe.Open(); DocDL = Lenh.ExecuteReader(); if (DocDL.Read() == true)//nếu có dữ liệu để đọc { Ma = int.Parse(DocDL["Ma"].ToString()); TenTT = DocDL["TenTT"].ToString(); } BaoVe.Close(); }
public string LoadMenu(int CNMe, int level) { string KetQua = string.Empty; SqlConnection BaoVe = new SqlConnection("server=(local)\\SQLEXPRESS;uid=sa;pwd=123;database=QuanLyCongVan"); SqlCommand Lenh = new SqlCommand("Menu_Lay", BaoVe); Lenh.CommandType = CommandType.StoredProcedure; SqlParameter ThamSo = new SqlParameter(); ThamSo = Lenh.Parameters.AddWithValue("@CNMe", CNMe); SqlDataReader DocDL; BaoVe.Open(); DocDL = Lenh.ExecuteReader(); if (!DocDL.HasRows) { return(KetQua); } else { KetQua = "<ul>"; while (DocDL.Read()) { KetQua += "<li><a href='<%# Eval('Link')%>'><span>" + DocDL["TenCN"] + "</span></a></li>"; KetQua += LoadMenu(Convert.ToInt32(DocDL["Ma"]), level + 1); } KetQua += "</ul>"; BaoVe.Close(); } return(KetQua); //SqlDataAdapter XeTai = new SqlDataAdapter("CongVan_DS", BaoVe); //DataTable ThungChua = new DataTable(); //BaoVe.Open(); //XeTai.Fill(ThungChua); //BaoVe.Close(); //return ThungChua; }
public bool DangNhap() { try { SqlConnection BaoVe = new SqlConnection("server=(local)\\SQLEXPRESS;uid=sa;pwd=123;database=QuanLyCongVan"); SqlCommand Lenh = new SqlCommand("UserN_DangNhap", BaoVe); Lenh.CommandType = CommandType.StoredProcedure; SqlParameter ThamSo = new SqlParameter(); ThamSo = Lenh.Parameters.AddWithValue("@TenUser", TenUser); ThamSo = Lenh.Parameters.AddWithValue("@MatKhau", MatKhau); SqlDataReader DocDL; BaoVe.Open(); DocDL = Lenh.ExecuteReader(); if (DocDL.Read() == true) { Ma = int.Parse(DocDL["Ma"].ToString()); Ma_NV = int.Parse(DocDL["Ma_NV"].ToString()); TenUser = DocDL["TenUser"].ToString(); MatKhau = DocDL["MatKhau"].ToString(); MaNhom = int.Parse(DocDL["MaNhom"].ToString()); Ho = DocDL["Ho"].ToString(); TenNV = DocDL["TenNV"].ToString(); BaoVe.Close(); return(true); } else { BaoVe.Close(); return(false); } } catch (Exception ex) { ThongBao = ex.Message; } return(false); }