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 bool Insert(string ten)
{
string sql = "sp_DonViTinh_Insert";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter tendonvi = new SqlParameter("@tendonvi", SqlDbType.NVarChar);
tendonvi.Value = ten;
ds.Add(tendonvi);
bool kq = false;
kq = SqlDataAcessHelper.exNonStoreParas(sql, ds);
return(kq);
}
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 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 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 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 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 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 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 bool Delete(int ma)
{
string sql = "sp_DonViTinh_Delete";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter id = new SqlParameter("@madonvi", SqlDbType.Int);
id.Value = ma;
ds.Add(id);
bool kq = false;
kq = SqlDataAcessHelper.exNonStoreParas(sql, ds);
return(kq);
}
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 void updateAllField(IDictionary <string, string> Dic)
{
string sql = "[sp_Summary_Detail_UpdateAllField]";
List <SqlParameter> ds = new List <SqlParameter>();
foreach (KeyValuePair <string, string> entry in Dic)
{
// do something with entry.Value or entry.Key
ds.Add(new SqlParameter("@" + entry.Key, entry.Value));
}
SqlDataAcessHelper.exNonStoreParas(sql, ds);
}
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 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 bool CapNhat(int ma, string ten)
{
string sql = "sp_TheLoaiSum_Update";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter maTL = new SqlParameter("@id", SqlDbType.Int);
maTL.Value = ma;
ds.Add(maTL);
SqlParameter theloai = new SqlParameter("@theloai", SqlDbType.NVarChar);
theloai.Value = ten;
ds.Add(theloai);
return(SqlDataAcessHelper.exNonStoreParas(sql, ds));
}
public bool SuaGiaiDoan(int a, string b)
{
string sql = "sp_GiaiDoan_Sua";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ma = new SqlParameter("@Id", SqlDbType.Int);
ma.Value = a;
SqlParameter ten = new SqlParameter("@ten", SqlDbType.NVarChar);
ten.Value = b;
ds.Add(ma);
ds.Add(ten);
return(SqlDataAcessHelper.exNonStoreParas(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 bool XoaDanhMucThietHai(int ma)
{
string sql = "sp_DanhMucThietHai_delete";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter madanhmuc = new SqlParameter("@ma", SqlDbType.Int);
madanhmuc.Value = ma;
ds.Add(madanhmuc);
bool kq = SqlDataAcessHelper.exNonStoreParas(sql, ds);
return(kq);
}
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));
}
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 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 bool CapNhat(int ma, string ten)
{
string sql = "sp_MenhGia_Update";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter id = new SqlParameter("@id", SqlDbType.Int);
id.Value = ma;
ds.Add(id);
SqlParameter menhgia = new SqlParameter("@ten", SqlDbType.NVarChar);
menhgia.Value = ten;
ds.Add(menhgia);
return(SqlDataAcessHelper.exNonStoreParas(sql, ds));
}
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 bool DoiMatKhau(int id, string newpass)
{
string sql = "sp_GiamDinhVien_CapNhatMauKhau";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ma = new SqlParameter("@idgdv", SqlDbType.Int);
ma.Value = id;
ds.Add(ma);
SqlParameter pas = new SqlParameter("@pass", SqlDbType.VarChar);
pas.Value = newpass;
ds.Add(pas);
return(SqlDataAcessHelper.exNonStoreParas(sql, ds));
}
public bool ThemMoi(int id, string ten)
{
string sql = "sp_HangMuc_Insert";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ma = new SqlParameter("@id", SqlDbType.Int);
ma.Value = id;
ds.Add(ma);
SqlParameter name = new SqlParameter("@tenhangmuc", SqlDbType.NVarChar);
name.Value = ten;
ds.Add(name);
return(SqlDataAcessHelper.exNonStoreParas(sql, ds));
}
public DataTable ChiTietQuiTrinh(int maquitrinh)
{
string sql = "sp_QuiTrinh_ChiTiet";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ma = new SqlParameter("@maquitrinh", SqlDbType.Int);
ma.Value = maquitrinh;
ds.Add(ma);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
public bool CapNhat(int ma, string ten)
{
string sql = "sp_LoaiHinhTonThat_CapNhat";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ID = new SqlParameter("@ma", SqlDbType.Int);
ID.Value = ma;
ds.Add(ID);
SqlParameter loai = new SqlParameter("@ten", SqlDbType.NVarChar);
loai.Value = ten;
ds.Add(loai);
return(SqlDataAcessHelper.exNonStoreParas(sql, ds));
}
public DataTable MemosOther(int id)
{
string sql = "sp_Memos_OtherSubject";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ma = new SqlParameter("@id", SqlDbType.Int);
ma.Value = id;
ds.Add(ma);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
return(dt);
}
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 TimeSheetDangThucHien_Claim(int ma, string thamchieu)
{
string sql = "sp_TimeSheetDangThucHien_Claim";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter id = new SqlParameter("@maGDV", SqlDbType.Int);
id.Value = ma;
ds.Add(id);
SqlParameter claim = new SqlParameter("@claim", SqlDbType.NVarChar);
claim.Value = thamchieu;
ds.Add(claim);
return(SqlDataAcessHelper.exStoreParas(sql, ds));
}