public DataTable LayTenMaHoa(int maNBH)
{
string sql = "sp_DonViBaoHiem_TenMaHoa";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ma = new SqlParameter("@manhabh", SqlDbType.Int);
ma.Value = maNBH;
ds.Add(ma);
return(SqlDataAcessHelper.exStoreParas(sql, ds));
}
public DataTable DanhSachHangMuc(string idclaim)
{
string sql = "sp_LoaiHangMuc_Select";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter id = new SqlParameter("@idclaim", SqlDbType.VarChar);
id.Value = idclaim;
ds.Add(id);
return(SqlDataAcessHelper.exStoreParas(sql, ds));
}
public DataTable LaySummaryAll(string idclaim)
{
string sql = "sp_SummaryDetail_SelectAll";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter id = new SqlParameter("idclaim", SqlDbType.VarChar);
id.Value = idclaim;
ds.Add(id);
return(SqlDataAcessHelper.exStoreParas(sql, ds));
}
public DataTable TimesheetIncomeGDVDetail(string thamchieu, int gdv)
{
string sql = "sp_Income_Detail";
List <SqlParameter> ds = new List <SqlParameter>();
ds.Add(new SqlParameter("@idclaim", thamchieu));
ds.Add(new SqlParameter("@idgdv", gdv));
DataTable dt = new DataTable();
return(SqlDataAcessHelper.exStoreParas(sql, ds));
}
public DataRow GetDanhMucThietHai(String ma)
{
string sql = "sp_DanhMucThietHai_getDM";
List <SqlParameter> ds = new List <SqlParameter>();
ds.Add(new SqlParameter("@id", ma));
DataTable dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt.Rows[0]);
}
public DataTable DSItem(int maloai)
{
DataTable dt = new DataTable();
string sql = "sp_Item_Select";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ma = new SqlParameter("@maloai", SqlDbType.Int);
ma.Value = maloai;
ds.Add(ma);
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable DanhSachDeXuat(string id)
{
string sql = "sp_DeXuatBoiThuong_select";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter idclaim = new SqlParameter("@idclaim", SqlDbType.VarChar);
idclaim.Value = id;
ds.Add(idclaim);
DataTable dt = new DataTable();
return(dt = SqlDataAcessHelper.exStoreParas(sql, ds));
}
public DataTable ChiTiet(int mawr)
{
string sql = "sp_WeeklyReport_ChiTiet";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter id = new SqlParameter("@idweekly", SqlDbType.Int);
id.Value = mawr;
ds.Add(id);
DataTable dt = new DataTable();
return(dt = SqlDataAcessHelper.exStoreParas(sql, ds));
}
public DataTable ItemListUpdate(string maclaim)
{
string sql = "sp_DocsRequesr_SelectAllClaim";
DataTable dt = new DataTable();
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter id = new SqlParameter("@maclaim", SqlDbType.NVarChar);
id.Value = maclaim;
ds.Add(id);
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable LayKhaoSatRuiRo(string thamchieu)
{
DataTable dt = new DataTable();
String sql = "sp_LayKhaoSatRuiRoTheoThamChieu";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ten = new SqlParameter("@thamchieu", SqlDbType.VarChar);
ten.Value = thamchieu;
ds.Add(ten);
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable TimKiem(string tukhoa)
{
DataTable dt = new DataTable();
string sql = "sp_QuiTrinh_TimKiem";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter tu = new SqlParameter("@tukhoa", SqlDbType.NVarChar);
tu.Value = tukhoa;
ds.Add(tu);
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable ThongTinDVBH(int ma)
{
DataTable dt = new DataTable();
string sql = "sp_ThongTinDonViBaoHiem";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter machinhanh = new SqlParameter("@manhabaohiem", SqlDbType.Int);
machinhanh.Value = ma;
ds.Add(machinhanh);
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable DanhSachLiability(string id)
{
string sql = "sp_Summary_DanhSachL";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter idclaim = new SqlParameter("@idclaim", SqlDbType.VarChar);
idclaim.Value = id;
ds.Add(idclaim);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable DanhSachTienDoXuLy(string matc)
{
string sql = "sp_TienDoXuLy_select";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter thamchieu = new SqlParameter("@idclaim", SqlDbType.VarChar);
thamchieu.Value = matc;
ds.Add(thamchieu);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable DSDiaryTheoThamChieu(string thamchieu)
{
string sql = "sp_Diary_select_ThamChieu2";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter tc = new SqlParameter("@maClaim", SqlDbType.VarChar);
tc.Value = thamchieu;
ds.Add(tc);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable DSTimeSheetTheoGDV(int magdv)
{
string sql = "sp_Diary_timesheet_gdv2";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ma = new SqlParameter("@magdv", SqlDbType.Int);
ma.Value = magdv;
ds.Add(ma);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable DSTimeSheetTheoThamChieu(string thamchieu)
{
string sql = "sp_Diary_timesheet_thamchieu2";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ma = new SqlParameter("@mathamchieu", SqlDbType.VarChar);
ma.Value = thamchieu;
ds.Add(ma);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable ThongTinCLaim_Diary(string ma)
{
string sql = "sp_Claim_Diary2";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter madr = new SqlParameter("@mathamchieu", SqlDbType.VarChar);
madr.Value = ma;
ds.Add(madr);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable TongThietHai(string thamchieu)
{
string sql = "sp_Summary_DanhSachSum";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter thamChieu = new SqlParameter("@thamchieu", SqlDbType.VarChar);
thamChieu.Value = thamchieu;
ds.Add(thamChieu);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable DSDiaryTheoGDV(int maGDV)
{
string sql = "sp_Diary_select_GDV2";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ma = new SqlParameter("@maGDV", SqlDbType.Int);
ma.Value = maGDV;
ds.Add(ma);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable LayGDVClaim(string thamchieu)
{
string sql = "sp_LayGDVClaim";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter tenclaim = new SqlParameter("@tenclaim", SqlDbType.VarChar);
tenclaim.Value = thamchieu;
ds.Add(tenclaim);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable DSNguoiDBHTheoDonVi(int madv)
{
string sql = "sp_KhachHang_DonViBH";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter madvbh = new SqlParameter("@madvbh", SqlDbType.Int);
madvbh.Value = madv;
ds.Add(madvbh);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable LayTenNBH_DonVi(string maclaim)
{
string sql = "sp_NhaBaoHiem_DonViBH_Ten";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter macl = new SqlParameter("@maclaim", SqlDbType.VarChar);
macl.Value = maclaim;
ds.Add(macl);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable LayMaLinhVucTonThat(string mathamchieu)
{
string sql = "sp_ChiTietThietHai_KiemTraMa";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter macl = new SqlParameter("@maclaim", SqlDbType.VarChar);
macl.Value = mathamchieu;
ds.Add(macl);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable TimesheetGDVCase(string id, int gdv)
{
string sql = "sp_TimeSheet_GDVClaimAdjuster";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter maGDV = new SqlParameter("@gdv", SqlDbType.Int);
maGDV.Value = gdv;
ds.Add(maGDV);
SqlParameter caseno = new SqlParameter("@idclaim", SqlDbType.VarChar);
caseno.Value = id;
ds.Add(caseno);
return(SqlDataAcessHelper.exStoreParas(sql, ds));
}
public static DataTable SelectSummaryDetail(string idclaim, int idLoaiHangMuc)
{
string sql = "sp_Summary_Select_Claim_LoaiHangMuc";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter id = new SqlParameter("@claimID", SqlDbType.VarChar);
id.Value = idclaim;
ds.Add(id);
SqlParameter paramLoaiHangMuc = new SqlParameter("@idLoaiHangMuc", SqlDbType.VarChar);
paramLoaiHangMuc.Value = idLoaiHangMuc;
ds.Add(paramLoaiHangMuc);
return(SqlDataAcessHelper.exStoreParas(sql, ds));
}
public DataTable KiemTraDangNhap(string username, string password)
{
string sql = "sp_GiamDinhVien_KTDN";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter user = new SqlParameter("@user", SqlDbType.NVarChar);
user.Value = username;
ds.Add(user);
SqlParameter pass = new SqlParameter("@pass", SqlDbType.NVarChar);
pass.Value = password;
ds.Add(pass);
return(SqlDataAcessHelper.exStoreParas(sql, ds));
}
public DataTable DSNguoiDaiDien(int madonvi)
{
DataTable dt = new DataTable();
string sql = "sp_DanhSachNguoiDaiDienTheoDonVi";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter maDV = new SqlParameter("@madonvi", SqlDbType.Int);
maDV.Value = madonvi;
ds.Add(maDV);
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public DataTable TimesheetDate(string date1, string date2)
{
string sql = "sp_Timesheet_Date";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ngay = new SqlParameter("@ngay", SqlDbType.VarChar);
ngay.Value = date1;
ds.Add(ngay);
SqlParameter ngay2 = new SqlParameter("@ngayden", SqlDbType.VarChar);
ngay2.Value = date2;
ds.Add(ngay2);
return(SqlDataAcessHelper.exStoreParas(sql, ds));
}
public DataTable DSTimeSheet(int gdv, string thamchieu)
{
string sql = "sp_TimeSheet_DS";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter id = new SqlParameter("@magdv", SqlDbType.Int);
id.Value = gdv;
ds.Add(id);
SqlParameter tc = new SqlParameter("@Tc", SqlDbType.VarChar);
tc.Value = thamchieu;
ds.Add(tc);
return(SqlDataAcessHelper.exStoreParas(sql, ds));
}
