protected void grdDVT_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DM_DiemDo ddo = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == int.Parse(e.Keys[0] + ""));
CBDN.DM_DVQLY dv = db.DM_DVQLies.SingleOrDefault(c => c.IDMA_DVIQLY == ddo.MaDviNhap);
CBDN.HD_DiemDoLienKet cv = db.HD_DiemDoLienKets.SingleOrDefault(x => x.MaDiemDo == ddo.MaDiemDo);
if (cv == null)
{
CBDN.HD_DiemDoLienKet ddoLK = new CBDN.HD_DiemDoLienKet();
ddoLK.DDo = e.NewValues[0] + "";
ddoLK.Nguon = e.NewValues[1] + "";
ddoLK.MaDiemDo = ddo.MaDiemDo;
ddoLK.IDMaDVIQLY = ddo.MaDviNhap;
ddoLK.MaDDVIQLY = dv.MA_DVIQLY;
ddoLK.IsChieuGiao = (bool)e.NewValues["IsChieuGiao"];
ddoLK.IsChieuNhan = (bool)e.NewValues["IsChieuNhan"];
ddoLK.IsDaoChieu = (bool)e.NewValues["IsDaoChieu"];
ddoLK.Nhan = decimal.Parse(e.NewValues["Nhan"] + "");
ddoLK.Chia = decimal.Parse(e.NewValues["Chia"] + "");
db.HD_DiemDoLienKets.InsertOnSubmit(ddoLK);
db.SubmitChanges();
}
else
{
//CBDN.HD_DiemDoLienKet ddoLK = db.HD_DiemDoLienKets.SingleOrDefault(x => x.MaDiemDo == cv.MaDiemDo);
cv.DDo = e.NewValues[0] + "";
cv.Nguon = e.NewValues[1] + "";
cv.IsChieuGiao = (bool)e.NewValues["IsChieuGiao"];
cv.IsChieuNhan = (bool)e.NewValues["IsChieuNhan"];
cv.IsDaoChieu = (bool)e.NewValues["IsDaoChieu"];
cv.Nhan = decimal.Parse(e.NewValues["Nhan"] + "");
cv.Chia = decimal.Parse(e.NewValues["Chia"] + "");
// ddoLK.MaDiemDo = e.NewValues[0] + "";
db.SubmitChanges();
}
grdDVT.CancelEdit();
e.Cancel = true;
db.SubmitChanges();
_DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Xoá người phụ trách thành công');", true);
}
catch (Exception ex)
{ }
finally
{
e.Cancel = true;
}
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DM_DiemDoLienKetResult lk = (CBDN.DM_DiemDoLienKetResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
CBDN.DM_DiemDo ddo = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == lk.IDDiemDo);
CBDN.DM_DVQLY dv = db.DM_DVQLies.SingleOrDefault(c => c.IDMA_DVIQLY == ddo.MaDviNhap);
CBDN.HD_DiemDoLienKet cv = db.HD_DiemDoLienKets.SingleOrDefault(x => x.MaDiemDo == ddo.MaDiemDo);
if (cv == null)
{
CBDN.HD_DiemDoLienKet ddoLK = new CBDN.HD_DiemDoLienKet();
ddoLK.DDo = txtMaDiemDoLK.Text;
ddoLK.Nguon = txtNguon.Text;
ddoLK.MaDiemDo = ddo.MaDiemDo;
ddoLK.IDMaDVIQLY = ddo.MaDviNhap;
ddoLK.MaDDVIQLY = dv.MA_DVIQLY;
ddoLK.IsChieuGiao = ckGiao.Checked;
ddoLK.IsChieuNhan = CkNhan.Checked;
ddoLK.IsDaoChieu = ckDaoChieu.Checked;
db.HD_DiemDoLienKets.InsertOnSubmit(ddoLK);
db.SubmitChanges();
}
else
{
//CBDN.HD_DiemDoLienKet ddoLK = db.HD_DiemDoLienKets.SingleOrDefault(x => x.MaDiemDo == cv.MaDiemDo);
cv.DDo = txtMaDiemDoLK.Text;
cv.Nguon = txtNguon.Text;
cv.IsChieuGiao = ckGiao.Checked;
cv.IsChieuNhan = CkNhan.Checked;
cv.IsDaoChieu = ckDaoChieu.Checked;
// ddoLK.MaDiemDo = e.NewValues[0] + "";
db.SubmitChanges();
}
db.SubmitChanges();
_DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Cập nhật dữ liệu thành công');", true);
}
catch (Exception ex)
{ }
finally
{
}
}
protected void btnSua_Click(object sender, EventArgs e)
{
pcAddRoles.ShowOnPageLoad = true;
Session["Add"] = 0;
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DM_CongToSelectByIDDViResult cv = (CBDN.DM_CongToSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
txtMaDuongDat.Text = cv.MaCongTo;
txtTenDuongDay.Text = cv.TenCongTo;
loadDanhMuc();
cmbDiemDo.Text = cv.MaDiemDo;
cmbDiemDo.Value = cv.IDDiemDo;
if (cv.TinhTrang == 1)
{
CkHoatDong.Checked = true;
}
else
{
CkHoatDong.Checked = false;
}
mmMoTa.Text = cv.MoTa;
cmbCapDienAp.Value = cv.CapDienAp + "";
txtChungLoai.Text = cv.ChungLoai;
txtHangSanXuat.Text = cv.HangSanXuat;
txtHeSoNhan.Text = cv.HeSoNhan + "";
if (cv.ISTonThatNhan != null)
{
ckNhanTonThat.Checked = (bool)cv.ISTonThatNhan;
}
else
{
ckNhanTonThat.Checked = false;
}
if (cv.IsTonThat != null)
{
ckGiaoTonThat.Checked = (bool)cv.IsTonThat;
}
else
{
ckGiaoTonThat.Checked = false;
}
txtTuTi.Text = cv.TU_TI;
dtNgayTreo.Text = cv.NgayTreoThao + "";
ckCongTo1Gia.Checked = (bool)cv.IsCToMotGia;
//cmbDvGiao.Value = cv.IDDonViGiao;
//cmbDvGiao.Text = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == cv.IDDonViGiao).TEN_DVIQLY;
//cmbNhan.Value = cv.IDDonViNhan;
//cmbNhan.Text = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == cv.IDDonViNhan).TEN_DVIQLY;
CBDN.DM_DVQLY giao = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == cv.IDDonViGiao);
CBDN.DM_DVQLY nhan = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == cv.IDDonViNhan);
List <CBDN.DM_DVQLY> lst = new List <CBDN.DM_DVQLY>();
lst.Add(giao);
lst.Add(nhan);
cmbDvGiao.DataSource = lst;
cmbDvGiao.ValueField = "IDMA_DVIQLY";
cmbDvGiao.TextField = "TEN_DVIQLY";
cmbDvGiao.DataBind();
cmbDvGiao.Value = cv.IDDonViGiao; cmbDvGiao.Text = giao.TEN_DVIQLY;
cmbNhan.DataSource = lst;
cmbNhan.ValueField = "IDMA_DVIQLY";
cmbNhan.TextField = "TEN_DVIQLY";
cmbNhan.DataBind();
cmbNhan.Value = cv.IDDonViNhan; cmbNhan.Text = nhan.TEN_DVIQLY;
txtHsNhanQD.Text = cv.HeSoQuyDoi + "";
}
