public DataTable DSLoaiKH() { string sql = "sp_DSLoaiKH"; DataTable dt = new DataTable(); return(SqlDataAcessHelper.exStoreNoParas(sql)); }
public DataTable DSNDBH() { string sql = "sp_KhachHang_DanhSach"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DSNguoiDaiDien() { string sql = "sp_DSNguoiDaiDien"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DanhSachCongTac() { string sql = "sp_CongTacTimeSheet_Lay"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DSLoaiHinhTT() { string sql = "sp_DSLoaiHinhTonThat"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable JobManage() { string sql = "sp_JobList_SelectFollow"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DSLinhVucKinhDoanh() { string sql = "sp_DSLinhVucKD"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DanhSachLinhVuc() { string sql = "sp_LinhVucTonThat_select"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DSIncomeWorking() { string sql = "sp_GiamDinhVien_ThuNhap"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DSQuiTrinh() { DataTable dt = new DataTable(); string sql = "sp_QuiTrinh_DS"; dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DanhSachWRClaimDangThucHien() { string sql = "sp_WeeklyReport_DangThucHien"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DSChucVu() { DataTable dt = new DataTable(); string sql = "sp_DSChucVu"; dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
//Lay timesheet public DataTable DSTimeSheetPending() { string sql = "sp_Diary_timesheet_allpending2"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DSDVMaHoa() { DataTable dt = new DataTable(); string sql = "sp_DonViBH_DSMaHoa"; dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DSAllDonVi() { DataTable dt = new DataTable(); string sql = "sp_LayDanhSachDonVi"; dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DanhSach() { string sql = "sp_MenhGia_DanhSach"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DSGiaiDoan() { DataTable dt = new DataTable(); string sql = "sp_GIAIDOAN_select"; dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DanhSachHangMuc() { DataTable dt = new DataTable(); string sql = "sp_HangMuc_Select"; dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DSCongTyTong() { DataTable dt = new DataTable(); string sql = "sp_DSNhaBH"; dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DanhSachLoai() { string sql = "sp_LoaiDR_Select"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DanhSachGiamDinhVien() { string sql = "sp_DanhSachGDV"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DanhSachQuanLyGDV() { string sql = "sp_DanhSachGDVManager"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public DataTable DSNguoiDuocBaoHiem() { string sql = "sp_DSNGuoiDuocBaoHiem"; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); return(dt); }
public int MaMax() { string sql = "sp_HangMuc_MaxID"; int ma = 0; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; ma = int.Parse(dr[0].ToString()); } return(ma); }
public int LayMaKH() { string sql = "sp_KhachHang_LayMa"; int ma = 0; DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; int temp = int.Parse(dr[0].ToString()); if (temp != 0) { ma = temp; } } return(ma + 1); }
public bool KiemTraMa(string ma) { string sql = "sp_KiemTraMaCongTacTimeSheet"; List <SqlParameter> ds = new List <SqlParameter>(); SqlParameter ID = new SqlParameter("@ma", SqlDbType.VarChar); ID.Value = ma; ds.Add(ID); DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreNoParas(sql); bool kq = false; if (dt.Rows.Count > 0) { kq = true; } return(kq); }
public DataTable GetListMostView() { string sql = "sp_News_List_MostView"; return(SqlDataAcessHelper.exStoreNoParas(sql)); }
public DataTable GetListHot() { string sql = "sp_News_List_Hot"; return(SqlDataAcessHelper.exStoreNoParas(sql)); }
public DataTable GroupByYear() { string sql = "sp_News_GroupByYear"; return(SqlDataAcessHelper.exStoreNoParas(sql)); }
public DataTable DanhSach() { string sql = "sp_NhomHangMuc_select"; return(SqlDataAcessHelper.exStoreNoParas(sql)); }