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