protected void btnCapNhat_Click(object sender, EventArgs e) { dxdto = new DeXuatBoiThuongDTO(); //string thamchieu = Session["ThamChieu"].ToString(); //mathamchieu = cldao.LayMaTheoTen(thamchieu); string thamchieu = lblThamChieu.Text; dxdto.MaClain = thamchieu; //int stt = dxdao.SoThuTu(mathamchieu) + 1; //dxdto.Stt = stt; dxdto.DienGiai = txtDienGiai.Text; dxdto.GiaTriKhieuNai = float.Parse(txtGiaTriKhieuNai.Text); dxdto.DeXuatTinhToan = float.Parse(txtDeXuatTinhToan.Text); bool kq = dxdao.ThemDeXuatBoiThuong(dxdto); if (kq == true) { ClearInputs(Page.Controls); loadDSDeXuat(thamchieu); } else { Response.Write("<script> alert('Fail!');</script>"); } }
public bool CapNhatDeXuatTinhToan(DeXuatBoiThuongDTO dx) { string sql = "sp_DeXuatBoiThuong_update"; List <SqlParameter> ds = new List <SqlParameter>(); SqlParameter idclaim = new SqlParameter("@idclaim", SqlDbType.VarChar); idclaim.Value = dx.MaClain; ds.Add(idclaim); SqlParameter madexuat = new SqlParameter("@iddexuatboithuong", SqlDbType.Int); madexuat.Value = dx.IdDeXuatBoiThuong; ds.Add(madexuat); SqlParameter diengiai = new SqlParameter("@diengiai", SqlDbType.NVarChar); diengiai.Value = dx.DienGiai; ds.Add(diengiai); SqlParameter giatri = new SqlParameter("@giatrikhieunai", SqlDbType.Float); giatri.Value = dx.GiaTriKhieuNai; ds.Add(giatri); SqlParameter dexuat = new SqlParameter("@dexuattinhtoan", SqlDbType.Float); dexuat.Value = dx.DeXuatTinhToan; ds.Add(dexuat); return(SqlDataAcessHelper.exNonStoreParas(sql, ds)); }
protected void gvDanhSachTienDo_RowUpdating(object sender, GridViewUpdateEventArgs e) { dxdto = new DeXuatBoiThuongDTO(); string mathamchieu = lblThamChieu.Text; GridViewRow row = gvDanhSachTienDo.Rows[e.RowIndex]; TextBox textdiengia = row.Cells[1].Controls[0] as TextBox; TextBox textkhieunai = row.Cells[2].Controls[0] as TextBox; TextBox textdexuat = row.Cells[3].Controls[0] as TextBox; int iddexuat = int.Parse(gvDanhSachTienDo.DataKeys[e.RowIndex].Value.ToString()); dxdto.MaClain = mathamchieu; dxdto.IdDeXuatBoiThuong = iddexuat; dxdto.DienGiai = textdiengia.Text; dxdto.GiaTriKhieuNai = float.Parse(textkhieunai.Text); dxdto.DeXuatTinhToan = float.Parse(textdexuat.Text); bool kq = dxdao.CapNhatDeXuatTinhToan(dxdto); if (kq == true) { e.Cancel = true; gvDanhSachTienDo.EditIndex = -1; loadDSDeXuat(mathamchieu); } else { Response.Write("<script>alert('Fail!');</script>"); } }
public bool ThemDeXuatBoiThuong(DeXuatBoiThuongDTO dx) { string sql = "sp_DeXuatBoiThuong_insert"; List <SqlParameter> ds = new List <SqlParameter>(); SqlParameter idclaim = new SqlParameter("@idclaim", SqlDbType.VarChar); idclaim.Value = dx.MaClain; ds.Add(idclaim); //SqlParameter stt = new SqlParameter("@stt", SqlDbType.Int); //stt.Value = dx.Stt; //ds.Add(stt); SqlParameter diengiai = new SqlParameter("@diengiai", SqlDbType.NVarChar); diengiai.Value = dx.DienGiai; ds.Add(diengiai); SqlParameter giatri = new SqlParameter("@giatrikhieunai", SqlDbType.Float); giatri.Value = dx.GiaTriKhieuNai; ds.Add(giatri); SqlParameter dexuat = new SqlParameter("@dexuattinhtoan", SqlDbType.Float); dexuat.Value = dx.DeXuatTinhToan; ds.Add(dexuat); return(SqlDataAcessHelper.exNonStoreParas(sql, ds)); }