protected void grdDVT_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DM_ChiNhanhSelectByIDDViResult HoatDong = (CBDN.DM_ChiNhanhSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
if (HoatDong.DiemDauNguon != int.Parse(session.User.ma_dviqly))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Không thể xóa giao nhận này vì không phải đơn vị bạn tạo ra');", true);
return;
}
var check = db.DM_Trams.Where(x => x.IDChiNhanh == HoatDong.ID + "");
if (check.Count() > 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Không thể xóa giao nhận này vì có trạm đang hoạt động ');", true);
return;
}
CBDN.DM_ChiNhanh cv = new CBDN.DM_ChiNhanh();
cv = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == HoatDong.ID && x.IDMADVIQLY.Contains(session.User.ma_dviqly));
db.DM_ChiNhanhs.DeleteOnSubmit(cv);
db.SubmitChanges();
_DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Xoá phương thức giao nhận thành công');", true);
}
catch (Exception ex)
{ }
finally
{
e.Cancel = true;
}
}
protected void grdDVT_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DM_ChiNhanhSelectByIDDViResult HoatDong = (CBDN.DM_ChiNhanhSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
CBDN.DM_ChiNhanh cv = new CBDN.DM_ChiNhanh();
cv = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == HoatDong.ID && x.IDMADVIQLY == int.Parse(session.User.ma_dviqly));
db.DM_ChiNhanhs.DeleteOnSubmit(cv);
db.SubmitChanges();
_DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Xoá phương thức giao nhận thành công');", true);
}
catch (Exception ex)
{ }
finally
{
e.Cancel = true;
}
}
private void insertdulieu()
{
SystemManageService.DM_DVQLYService dvi = new SystemManageService.DM_DVQLYService();
DataTable dt = new DataTable();
dt = dbOR.SelectAllDDo_TT("RG");
if (dt == null)
{
return;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
var donvi = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["MA_DVIQLY"] + "");
var donviG = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["DVIGIAO"] + "");
if (!CheckName(dt.Rows[i]["MA_DVI"] + "", 0, donvi.MA_DVIQLY))
{
continue;
}
if (!CheckName(dt.Rows[i]["MA_DVIB"] + "", 0, donvi.MA_DVIQLY))
{
continue;
}
CBDN.DM_ChiNhanh cv = new CBDN.DM_ChiNhanh();
cv.TenChiNhanh = dt.Rows[i]["MOTA"] + "";
cv.MaChiNhanh = dt.Rows[i]["MA_DVI"] + "";
if (dt.Rows[i]["CHIEU_GNHAN"] + "" == "G")
{
cv.IDMADVIQLY = "," + donvi.IDMA_DVIQLY + "," + donviG.IDMA_DVIQLY + ",";
}
else
{
cv.IDMADVIQLY = "," + donviG.IDMA_DVIQLY + "," + donvi.IDMA_DVIQLY + ",";
}
if (donvi.MA_DVIQLY == "PA" || donviG.MA_DVIQLY == "PA")
{
cv.LoaiPhuongThuc = 1;
}
else if (donvi.MA_DVIQLY.Length == 4 && donviG.MA_DVIQLY.Length == 4)
{
cv.LoaiPhuongThuc = 2;
}
else if (donvi.MA_DVIQLY.Length + donviG.MA_DVIQLY.Length < 12 && donvi.MA_DVIQLY.Length + donviG.MA_DVIQLY.Length > 9)
{
cv.LoaiPhuongThuc = 3;
}
else
{
cv.LoaiPhuongThuc = 4;
}
cv.MoTa = dt.Rows[i]["MOTA"] + "";
if (dt.Rows[i]["CHIEU_GNHAN"] + "" == "G")
{
cv.DiemDauNguon = donvi.IDMA_DVIQLY;
cv.DiemCuoiNguon = donviG.IDMA_DVIQLY;
}
else
{
cv.DiemCuoiNguon = donvi.IDMA_DVIQLY;
cv.DiemDauNguon = donviG.IDMA_DVIQLY;
}
cv.HoatDong = 1;
cv.HoatDong = 0;
db.DM_ChiNhanhs.InsertOnSubmit(cv);
db.SubmitChanges();
}
// insert tram
for (int i = 0; i < dt.Rows.Count; i++)
{
var donvi = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["MA_DVIQLY"] + "");
var donviG = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["DVIGIAO"] + "");
var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.MaChiNhanh == dt.Rows[i]["MA_DVI"] + "");
if (!CheckNameTramLo(dt.Rows[i]["MA_PTDIEN"] + "", 0, cn.ID + ""))
{
continue;
}
//var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(cmbDuongDay.Value + "") && x.IDMADVIQLY.Contains(session.User.ma_dviqly));
//var lstDD = db.DM_ChiNhanhs.Where(x => x.MaChiNhanh == cn.MaChiNhanh);
//foreach (var dd in lstDD)
//{
CBDN.DM_Tram cv = new CBDN.DM_Tram();
cv.MaTram = dt.Rows[i]["MA_PTDIEN"] + "";
cv.IDMaDviQly = cn.IDMADVIQLY;
cv.TenTram = dt.Rows[i]["MA_PTDIEN"] + "";
cv.MoTa = "";
cv.TinhChatDD = 0;
cv.DiaDiem = "";
cv.IDDuongDay = cn.ID;
cv.IDChiNhanh = cn.ID + "";
cv.HoatDong = 1;
cv.ParentId = 0;
cv.IsLo = 0;
cv.MaDVNhap = donviG.IDMA_DVIQLY;
db.DM_Trams.InsertOnSubmit(cv);
db.SubmitChanges();
}
// insert ma diem do
for (int i = 0; i < dt.Rows.Count; i++)
{
var donviG = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["DVIGIAO"] + "");
var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.MaChiNhanh == dt.Rows[i]["MA_DVI"] + "");
var tr = db.DM_Trams.SingleOrDefault(x => x.MaTram == dt.Rows[i]["MA_PTDIEN"] + "" && x.IDMaDviQly.Contains(cn.IDMADVIQLY));
if (!CheckNameDiemDo(dt.Rows[i]["MA_DDO"] + "", "0", tr.IDMaDviQly + ""))
{
continue;
}
//var tr = db.DM_Trams.SingleOrDefault(x => x.IDTram == int.Parse(tlDonVi.FocusedNode.Key + "") && x.IDMaDviQly.Contains("," + session.User.ma_dviqly + ","));
CBDN.DM_DiemDo cv = new CBDN.DM_DiemDo();
cv.MaDiemDo = dt.Rows[i]["MA_DDO"] + "";
cv.IDMaDViQly = tr.IDMaDviQly;
cv.TenDiemDo = dt.Rows[i]["MA_DDO"] + "";
cv.MoTa = "";
cv.IDChiNhanh = tr.IDChiNhanh;
cv.IDTram = tr.IDTram + "";
cv.TinhChatDD = 0;
cv.ISLoaiDD = 0;
cv.HoatDong = 1;
cv.MaDviNhap = donviG.IDMA_DVIQLY;
db.DM_DiemDos.InsertOnSubmit(cv);
db.SubmitChanges();
//}
}
DataTable dtCongTo = new DataTable();
for (int i = 0; i < dt.Rows.Count; i++)
{
var donvi = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["MA_DVIQLY"] + "");
var donviG = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["DVIGIAO"] + "");
dtCongTo = dbOR.SelectAllCongTo(dt.Rows[i]["MA_DDO"] + "");
if (dtCongTo.Rows.Count > 0)
{
var listddo = db.DM_DiemDos.Where(x => x.MaDiemDo == dt.Rows[i]["MA_DDO"] + "");
foreach (var ddo in listddo)
{// List<Entity.DM_DVQLY> lst = new List<DM_DVQLY>();
//var ddo = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == int.Parse(cmbDiemDo.Value + "") && x.IDMaDViQly.Contains(session.User.ma_dviqly));
if (!CheckNameCongTo(dtCongTo.Rows[0]["MA_TBI"] + "", 0, ddo.IDTram, ddo.IDChiNhanh))
{
continue;
}
//foreach (var ddo in lst)
//{
CBDN.DM_CongTo cv = new CBDN.DM_CongTo();
cv.MaCongTo = dtCongTo.Rows[0]["MA_TBI"] + "";
cv.TenCongTo = dtCongTo.Rows[0]["SO_TBI"] + "";
cv.MoTa = "";
cv.IDDiemDo = ddo.IDDiemDo + "";
cv.IDDonViQuanLy = ddo.IDMaDViQly;
cv.TinhTrang = 1;
cv.CapDienAp = dtCongTo.Rows[0]["CAPDA"] + "";
cv.ChungLoai = "";
cv.HangSanXuat = "";
cv.HeSoNhan = decimal.Parse(dtCongTo.Rows[0]["HSN"] + "");
cv.NgayTreoThao = DateTime.Now;
cv.TU_TI = "";
cv.IDTram = ddo.IDTram;
cv.IDChiNhanh = ddo.IDChiNhanh;
if (dt.Rows[i]["CHIEU_GNHAN"] + "" == "G")
{
cv.IDDonViGiao = donvi.IDMA_DVIQLY;
cv.KenhGiaoCongTo = "G";
cv.GiaoTinhChat = 0;
cv.IDDonViNhan = donviG.IDMA_DVIQLY;
cv.KenhNhanCongTo = "N";
cv.NhanTinhChat = 0;
}
else
{
cv.IDDonViGiao = donviG.IDMA_DVIQLY;
cv.KenhGiaoCongTo = "G";
cv.GiaoTinhChat = 0;
cv.IDDonViNhan = donvi.IDMA_DVIQLY;
cv.KenhNhanCongTo = "N";
cv.NhanTinhChat = 0;
}
cv.IDUser = 1;
cv.NgayTao = DateTime.Now;
cv.NgayKiemDinh = DateTime.Now;
cv.HeSoQuyDoi = 1;
cv.IDDVNhapDL = donviG.IDMA_DVIQLY;
cv.IDDVXacNhan = donvi.IDMA_DVIQLY;
cv.IsCToMotGia = false;
db.DM_CongTos.InsertOnSubmit(cv);
db.SubmitChanges();
//}
var congto = db.DM_CongTos.SingleOrDefault(x => x.IDCongTo == cv.IDCongTo);
//CBDN.DM_CongToSelectByIDDViResult HoatDong = (CBDN.DM_CongToSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
CBDN.HD_GiaoNhanThang giaonhan = new CBDN.HD_GiaoNhanThang();
giaonhan.IDCongTo = congto.IDCongTo + "";
giaonhan.IDChiNhanh = congto.IDChiNhanh;
giaonhan.IDDuongDay = congto.IDChiNhanh;
giaonhan.IDMaDViQly = donviG.IDMA_DVIQLY;
giaonhan.IDUser = 1;
giaonhan.IDTram = congto.IDTram;
if (DateTime.Now.Month == 1)
{
giaonhan.Thang = 12;
giaonhan.Nam = DateTime.Now.Year - 1;
}
else
{
giaonhan.Thang = DateTime.Now.Month - 1;
giaonhan.Nam = DateTime.Now.Year;
}
giaonhan.Nhan_P_Dau = 0;
giaonhan.Giao_P_Dau = 0;
giaonhan.Giao_P_SanLuong = 0;
giaonhan.Nhan_P_SanLuong = 0;
giaonhan.Nhan_Q_Dau = 0;
giaonhan.Giao_Q_Dau = 0;
giaonhan.Giao_Q_SanLuong = 0;
giaonhan.Nhan_Q_SanLuong = 0;
giaonhan.CosGiao = 0;
giaonhan.CosNhan = 0;
giaonhan.Giao_Bieu1_Dau = 0;
giaonhan.Nhan_Bieu1_Dau = 0;
giaonhan.Giao_Bieu1_SanLuong = 0;
giaonhan.Nhan_Bieu1_SanLuong = 0;
giaonhan.Giao_Bieu2_Dau = 0;
giaonhan.Nhan_Bieu2_Dau = 0;
giaonhan.Giao_Bieu2_SanLuong = 0;
giaonhan.Nhan_Bieu2_SanLuong = 0;
giaonhan.Giao_Bieu3_Dau = 0;
giaonhan.Nhan_Bieu3_Dau = 0;
giaonhan.Giao_Bieu3_SanLuong = 0;
giaonhan.Nhan_Bieu3_SanLuong = 0;
giaonhan.ISDoDem = 0;
giaonhan.ISChot = false;
giaonhan.LoaiNhap = 0;
giaonhan.NgayNhap = DateTime.Now;
db.HD_GiaoNhanThangs.InsertOnSubmit(giaonhan);
db.SubmitChanges();
}
}
}
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
DM_DVQLYService dm_dviSer = new DM_DVQLYService();
SYS_Session session = (SYS_Session)Session["SYS_Session"];
string dvdaunguon = dm_dviSer.SelectDM_DVQLY(int.Parse(session.User.ma_dviqly)).MA_DVIQLY;
if (Session["Add"] + "" == "0")
{
CBDN.DM_ChiNhanhSelectByIDDViResult cv = (CBDN.DM_ChiNhanhSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
var lst = db.DM_ChiNhanhs.Where(x => x.MaChiNhanh == cv.MaChiNhanh);
foreach (var qtCT in lst)
{
if (!CheckName(txtMaDuongDat.Text, cv.ID))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã phương thức giao nhận được trùng');", true); return;
}
qtCT.TenChiNhanh = txtmoTa.Text;
qtCT.MoTa = txtmoTa.Text;
if (CkHoatDong.Checked)
{
qtCT.HoatDong = 1;
}
else
{
qtCT.HoatDong = 0;
}
db.SubmitChanges();
}
}
else
{
if (txtMaDuongDat.Text + "" == "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã chi nhánh không được để trống');", true);
txtMaDuongDat.Focus(); return;
}
if (!CheckName(txtMaDuongDat.Text, 0))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã chi nhánh không được trùng');", true); return;
}
CBDN.DM_ChiNhanh cv = new CBDN.DM_ChiNhanh();
cv.TenChiNhanh = txtmoTa.Text;
cv.MaChiNhanh = txtMaDuongDat.Text;
cv.IDMADVIQLY = int.Parse(session.User.ma_dviqly);
cv.MoTa = txtmoTa.Text;
cv.DiemDauNguon = int.Parse(session.User.ma_dviqly);
cv.DiemCuoiNguon = int.Parse(session.User.ma_dviqly);
if (CkHoatDong.Checked)
{
cv.HoatDong = 1;
}
else
{
cv.HoatDong = 0;
}
cv.ISNhaMay = true;
cv.LoaiNhaMay = int.Parse(cmbloaiGiaoNhan.Value + "");
db.DM_ChiNhanhs.InsertOnSubmit(cv);
db.SubmitChanges();
}
pcAddRoles.ShowOnPageLoad = false;
_DataBind();
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
DM_DVQLYService dm_dviSer = new DM_DVQLYService();
SYS_Session session = (SYS_Session)Session["SYS_Session"];
string dvdaunguon = dm_dviSer.SelectDM_DVQLY(int.Parse(session.User.ma_dviqly)).MA_DVIQLY;
string dvcuoinguon = dm_dviSer.SelectDM_DVQLY(int.Parse(cmbCuoiNguon.Value + "")).MA_DVIQLY;
if (Session["Add"] + "" == "0")
{
CBDN.DM_ChiNhanhSelectByIDDViResult qtCT = (CBDN.DM_ChiNhanhSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
//var lst = db.DM_ChiNhanhs.Where(x => x.MaChiNhanh == cv.MaChiNhanh);
//foreach (var qtCT in lst)
//{
CBDN.DM_ChiNhanh cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == qtCT.ID);
if (!CheckName(txtMaDuongDat.Text, qtCT.ID))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã phương thức giao nhận được trùng');", true); return;
}
cn.TenChiNhanh = txtmoTa.Text;
cn.LoaiPhuongThuc = int.Parse(cmbLoaiPhuongThuc.Value + "");
cn.MoTa = txtmoTa.Text;
if (CkHoatDong.Checked)
{
cn.HoatDong = 1;
}
else
{
cn.HoatDong = 0;
}
db.SubmitChanges();
//}
}
else
{
if (txtMaDuongDat.Text + "" == "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã chi nhánh không được để trống');", true);
txtMaDuongDat.Focus(); return;
}
//if (txtTenDuongDay.Text == "")
//{
// ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Tên chi nhánh không được để trống');", true);
// txtTenDuongDay.Focus(); return;
//}
if (!CheckName(txtMaDuongDat.Text, 0))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã chi nhánh không được trùng');", true); return;
}
CBDN.DM_ChiNhanh cv = new CBDN.DM_ChiNhanh();
cv.TenChiNhanh = txtmoTa.Text;
cv.MaChiNhanh = dvdaunguon + "_" + dvcuoinguon;
if (session.User.ma_dviqly != "" + cmbCuoiNguon.Value)
{
cv.IDMADVIQLY = "," + session.User.ma_dviqly + "," + cmbCuoiNguon.Value + ",";
}
else
{
cv.IDMADVIQLY = session.User.ma_dviqly;
}
cv.LoaiPhuongThuc = int.Parse(cmbLoaiPhuongThuc.Value + "");
cv.MoTa = txtmoTa.Text;
cv.DiemDauNguon = int.Parse(session.User.ma_dviqly);
cv.DiemCuoiNguon = int.Parse(cmbCuoiNguon.Value + "");
if (CkHoatDong.Checked)
{
cv.HoatDong = 1;
}
else
{
cv.HoatDong = 0;
}
db.DM_ChiNhanhs.InsertOnSubmit(cv);
db.SubmitChanges();
//CBDN.DM_ChiNhanh cnGiaoNhan = new CBDN.DM_ChiNhanh();
//cnGiaoNhan.TenChiNhanh = txtmoTa.Text;
//cnGiaoNhan.MaChiNhanh = dvdaunguon + "_" + dvcuoinguon;
//cnGiaoNhan.IDMADVIQLY = int.Parse(cmbCuoiNguon.Value + "");
//cnGiaoNhan.MoTa = txtmoTa.Text;
//cnGiaoNhan.DiemCuoiNguon = int.Parse(session.User.ma_dviqly);
//cnGiaoNhan.DiemDauNguon = int.Parse(cmbCuoiNguon.Value + "");
//if (CkHoatDong.Checked)
// cnGiaoNhan.HoatDong = 1;
//else
// cnGiaoNhan.HoatDong = 0;
//db.DM_ChiNhanhs.InsertOnSubmit(cnGiaoNhan);
//db.SubmitChanges();
//}
}
pcAddRoles.ShowOnPageLoad = false;
_DataBind();
}