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));
}
