示例#1
0
        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);
        }
示例#2
0
        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);
        }
示例#3
0
        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);
        }
示例#4
0
        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);
        }
示例#5
0
        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);
        }
示例#6
0
        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);
        }
示例#7
0
        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);
        }
示例#8
0
        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);
        }
示例#9
0
        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);
        }
示例#10
0
        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);
        }
示例#11
0
        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);
        }
示例#12
0
        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);
        }
示例#13
0
        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);
        }
示例#14
0
        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));
        }
示例#15
0
        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));
        }
示例#16
0
        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));
        }
示例#17
0
        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);
        }
示例#18
0
        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);
        }
示例#19
0
        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));
        }
示例#20
0
        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));
        }
示例#21
0
        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));
        }
示例#22
0
        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));
        }
示例#23
0
        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);
        }
示例#24
0
        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));
        }
示例#25
0
        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));
        }
示例#26
0
        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);
        }
示例#27
0
        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));
        }
示例#28
0
        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);
        }
示例#29
0
        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));
        }
示例#30
0
        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));
        }