protected void btnUpdate_Click(object sender, EventArgs e)
{
//ChangeLbUser(UserNameNew);
SYS_Session session = (SYS_Session)Session["SYS_Session"];
session.User.USERNAME = txtUserName.Text;
session.User.HOTEN = txtFullName.Text;
session.User.SODT = txtSDT.Text;
session.User.PASSWORD = session.User.PASSWORD;
session.User.XACNHAN = session.User.XACNHAN;
if (IsValidEmailAddress(txtEmail.Text))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Succsess.');", true);
session.User.EMAIL = txtEmail.Text;
_userService.UpdateDM_USER(session.User);
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Error.Improperly formatted email');", true);
return;
}
Session["SYS_Session"] = session;
//WriteLog("Cập nhật thông tin cá nhân", Action.Update);
}
protected void grdDVT_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DM_TramSelectByIDDViResult HoatDong = (CBDN.DM_TramSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
if (HoatDong.MaDVNhap != 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;
}
CBDN.DM_Tram cv = new CBDN.DM_Tram();
cv = db.DM_Trams.SingleOrDefault(x => x.IDTram == cv.IDTram && x.IDChiNhanh == cv.IDChiNhanh);
db.DM_Trams.DeleteOnSubmit(cv);
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 grdCN_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DM_DiemDoSelectByIDDViResult HoatDong = (CBDN.DM_DiemDoSelectByIDDViResult)grdCN.GetRow(grdCN.FocusedRowIndex);
if (HoatDong.MaDviNhap != int.Parse(session.User.ma_dviqly))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Không thể xóa điểm đo này vì không phải đơn vị bạn tạo ra');", true);
return;
}
var congto = db.DM_CongTos.Where(x => x.IDDiemDo == HoatDong.IDDiemDo + "");
if (congto.Count() > 0)
{
throw new Exception("Không thể xóa điểm đo này vì đang có công tơ hoạt động!");
}
CBDN.DM_DiemDo cv = new CBDN.DM_DiemDo();
cv = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == HoatDong.IDDiemDo);
db.DM_DiemDos.DeleteOnSubmit(cv);
db.SubmitChanges();
loadKH();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Xoá điêm đo thành công');", true);
}
catch (Exception ex)
{
}
finally
{
e.Cancel = true;
}
}
protected void btnSua_Click(object sender, EventArgs e)
{
if ((CBDN.DM_DiemDoSelectByIDDViResult)grdCN.GetRow(grdCN.FocusedRowIndex) == null)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Bạn chưa chọn điểm đo để sửa');", true);
return;
}
pcAddRoles.ShowOnPageLoad = true;
Session["Add"] = 0;
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DM_DiemDoSelectByIDDViResult cv = (CBDN.DM_DiemDoSelectByIDDViResult)grdCN.GetRow(grdCN.FocusedRowIndex);
txtMaDuongDat.Text = cv.MaDiemDo;
txtTenDuongDay.Text = cv.TenDiemDo;
cmbLoaiDD.Value = cv.ISLoaiDD;
cmbLoaiDD.SelectedIndex = (int)cv.ISLoaiDD;
cmbTinhChat.Text = cv.strTinhChat;
cmbTinhChat.Value = cv.TinhChatDD;
cmbTinhChat.SelectedIndex = (int)cv.TinhChatDD;
if (cv.HoatDong == 1)
{
CkHoatDong.Checked = true;
}
else
{
CkHoatDong.Checked = false;
}
txtmoTa.Text = cv.MoTa;
}
private bool TinhChuKy(int thang, int nam, int Ngay, int ChuKy, int ngaysau, int chukysau, int kiemtra)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
DataTable dt = db.SELECT_TONTHAT_CHUKY(session.User.ma_dviqlyDN, cmbMaTram.Value + "", thang, nam, Ngay, ChuKy, ngaysau, chukysau, kiemtra);
if (dt.Rows.Count == 0)
{
return(false);
}
if (dt.Rows[0]["CSUAT"] + "" == "0" || dt.Rows[0]["CSUAT"] + "" == "")
{
return(false);
}
decimal sltinhCK = 0, sanluongtrc = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
decimal slg = (decimal.Parse(dt.Rows[i]["SLGCOT"] + "") * decimal.Parse(dt.Rows[i]["CSUAT"] + "")) / decimal.Parse(dt.Rows[i]["SLDAUNGUONG"] + "");
sanluongtrc = decimal.Parse(dt.Rows[i]["SLGCOT"] + "");
sltinhCK = slg;
db.INSERT_TTTT_SLGNUT_CHUKY(session.User.ma_dviqlyDN, cmbMaTram.Value + "", dt.Rows[i]["MACOT"] + "", thang, nam, Math.Round(slg, 2), Ngay, ChuKy);
}
else
{
decimal slg = sltinhCK * decimal.Parse(dt.Rows[i]["SLGCOT"] + "") / sanluongtrc;
sanluongtrc = decimal.Parse(dt.Rows[i]["SLGCOT"] + "");
sltinhCK = slg;
db.INSERT_TTTT_SLGNUT_CHUKY(session.User.ma_dviqlyDN, cmbMaTram.Value + "", dt.Rows[i]["MACOT"] + "", thang, nam, Math.Round(slg, 2), Ngay, ChuKy);
}
}
return(true);
}
private void LoadDataDV()
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
int a = int.Parse(session.User.ma_dviqly + "");
if (MaDienLuc.Value + "" != "")
{
if (a > 38)
{
DM_DVQLYService dm_dviSer = new DM_DVQLYService();
var donvi = dm_dviSer.SelectDM_DVQLY(a);
List <DM_DS> List = new List <DM_DS>();
DM_DS Dvi = new DM_DS();
Dvi.MA_DVIQLY = session.User.ma_dviqlyDN + "";
Dvi.NAME_DVIQLY = donvi.NAME_DVIQLY.Split('-')[1].ToString().ToUpper();
List.Add(Dvi);
cmMaDvi.DataSource = List;
cmMaDvi.TextField = "NAME_DVIQLY";
cmMaDvi.ValueField = "MA_DVIQLY";
cmMaDvi.DataBind();
}
else
{
DM_DVQLYService dm_dviSer = new DM_DVQLYService();
// DataTable lst_dmdv = new DataTable();
var lst_dmdv = dm_dviSer.SelectAll_DVI_ByChild(int.Parse(MaDienLuc.Value + ""));
cmMaDvi.DataSource = lst_dmdv;
cmMaDvi.ValueField = "MA_DVIQLY";
cmMaDvi.TextField = "NAME_DVIQLY";
cmMaDvi.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
if (session == null || session.User.USERNAME == "Guest")
{
session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath;
Response.Redirect("~\\Login.aspx");
}
else
{
List <SYS_Right> right = session.User.Rights;
foreach (SYS_Right sysRight in right)
{
if (sysRight.FuncId == funcid)
{
rightOfUser = sysRight;
Session["Right"] = sysRight;
Session["UserId"] = session.User.IDUSER;
Session["FunctionId"] = sysRight.FuncId;
break;
}
}
if (rightOfUser == null)
{
Session["Status"] = "0";
Response.Redirect("~\\HeThong\\Default.aspx");
}
}
Session["SYS_Session"] = session;
_DataBind();
}
protected void PageLoad()
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
if (session == null)
{
session = new SYS_Session();
Session["SYS_Session"] = session;
Response.Redirect("~\\Login.aspx");
}
else if (session.User == null)
{
session.User = new DM_USER();
session.User.USERNAME = "******";
session.User.FullName = "Guest";
}
if (session.DonVi == null)
{
return;
}
if (session.PhanLoai == (int)PhanLoai.SoYTe)
{
if (CheckFormNhapLieuSo(this.Page.Request.RawUrl))
{
// Kiểm tra xem Session cũ có bằng Session hiện tại không, nếu không bằng thì gán lại cũ = hiện tại
if (session.IDOrganiztionCu != session.DonVi.ID)
{
session.IDOrganiztionCu = session.DonVi.ID;
}
}
}
}
protected void TreeListOrganization_NodeDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DM_Tram HoatDong = db.DM_Trams.SingleOrDefault(x => x.IDTram == int.Parse(e.Keys["IDTram"] + ""));
if (HoatDong.MaDVNhap != int.Parse(session.User.ma_dviqly))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Không thể xóa trạm lộ này vì không phải đơn vị bạn tạo ra');", true);
return;
}
var check = db.DM_DiemDos.Where(x => x.IDTram == HoatDong.IDTram + "");
if (check.Count() > 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Không thể xóa trạm lộ này vì có điểm đo đang hoạt động ');", true);
return;
}
CBDN.DM_Tram cv = new CBDN.DM_Tram();
cv = db.DM_Trams.SingleOrDefault(x => x.IDTram == HoatDong.IDTram);
db.DM_Trams.DeleteOnSubmit(cv);
db.SubmitChanges();
_DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Xoá danh mục thành công');", true);
}
catch (Exception ex)
{ }
finally
{
e.Cancel = true;
}
}
public string UploadFile()
{
string strTenFile = fileUp.FileName;
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
try
{
if (!Directory.Exists(Server.MapPath("~/") + "TonThatKyThuat" + "/" + "LuuTruFileCAD" + "/" + session.User.ma_dviqlyDN))
{
Directory.CreateDirectory(Server.MapPath("~/") + "TonThatKyThuat" + "/" + "LuuTruFileCAD" + "/" + session.User.ma_dviqlyDN);
}
if (!File.Exists(Server.MapPath("~/") + "TonThatKyThuat" + "/" + "LuuTruFileCAD" + "/" + session.User.ma_dviqlyDN + "\\" + fileUp.FileName))
{
File.Delete(Server.MapPath("~/") + "TonThatKyThuat" + "/" + "LuuTruFileCAD" + "/" + session.User.ma_dviqlyDN + "\\" + fileUp.FileName);
fileUp.PostedFile.SaveAs(Server.MapPath("~/") + "TonThatKyThuat" + "/" + "LuuTruFileCAD" + "/" + session.User.ma_dviqlyDN + "\\" + strTenFile);
}
else
{
fileUp.PostedFile.SaveAs(Server.MapPath("~/") + "TonThatKyThuat" + "/" + "LuuTruFileCAD" + "/" + session.User.ma_dviqlyDN + "\\" + fileUp.FileName);
strTenFile = fileUp.FileName;
}
hdTenFile.Value = strTenFile;
}
catch (Exception exp)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('" + exp.Message + Server.MapPath("~/") + "LuuTruFileCAD" + "/" + session.User.ma_dviqlyDN + "\\" + hdTenFile.Value + "');", true);
}
return(strTenFile);
}
protected void grdDVT_CommandButtonInitialize(object sender, ASPxGridViewCommandButtonEventArgs e)
{
return;
SYS_Session session = (SYS_Session)Session["SYS_Session"];
var lst = db.DN_Select_ThucTe(int.Parse(session.User.ma_dviqly), int.Parse(cmbThang.Value + ""), int.Parse("" + cmbNam.Value)).ToList().Where(x => x.Ngay == e.VisibleIndex + 1);
bool kt = false;
foreach (var a in lst)
{
if (a.ISLooK == 1)
{
kt = true;
}
else
{
kt = false;
}
if (e.ButtonType == DevExpress.Web.ColumnCommandButtonType.Edit)
{
e.Visible = kt;
}
// disable the selction checkbox
if (e.ButtonType == DevExpress.Web.ColumnCommandButtonType.SelectCheckbox)
{
e.Enabled = kt;
}
}
}
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;
cmbDiemDo.Value = (int)cv.IDDiemDo;
if (cv.TinhTrang == 1)
{
CkHoatDong.Checked = true;
}
else
{
CkHoatDong.Checked = false;
}
mmMoTa.Text = cv.MoTa;
txtCapDienAp.Text = cv.CapDienAp + "";
txtChungLoai.Text = cv.ChungLoai;
txtHangSanXuat.Text = cv.HangSanXuat;
txtHeSoNhan.Text = cv.HeSoNhan + "";
txtTuTi.Text = cv.TU_TI;
dtNgayTreo.Text = cv.NgayTreoThao + "";
cmbTinhChatGiao.Value = cv.GiaoTinhChat;
cmbTinhChatGiao.Text = cv.strTinhChatGiao + "";
txtHsNhanQD.Text = cv.HeSoQuyDoi + "";
}
protected void btnLuuDuLieu_Click(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
int testso = 0;
if (!int.TryParse(txtSanLuongKH.Text, out testso))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Sản lượng kế hoạch không phải là kiểu số. Bạn check lại thông tin');", true);
txtSanLuongKH.Focus();
return;
}
DataTable dt = db.SELECT_TTTT_DN_KEHOACH(session.User.ma_dviqlyDN, cmbMaTram.Value + "");
DataRow[] dr = dt.Select("THANG=" + cmbThang.Value + " AND NAM =" + cmbNam.Value);
if (dr.Length == 0)
{
db.Insert_TTTT_DN_KEHOACH(session.User.ma_dviqlyDN, cmbMaTram.Value.ToString(), int.Parse(txtSanLuongKH.Text), int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), DateTime.Now);
}
else
{
db.Update_TTTT_DN_KEHOACH(session.User.ma_dviqlyDN, cmbMaTram.Value.ToString(), int.Parse(txtSanLuongKH.Text), int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""));
}
_DataBind();
}
protected void btnIn_Click(object sender, EventArgs e)
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
string strMadviqly = session.User.ma_dviqly;
Response.Redirect("../Report/Report.aspx?ChiNhanh=" + 0 + "&Loai=1&Thang=" + cmbThang.Value + "&Nam=" + cmbNam.Value + "&ParentId=1");
}
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 override void InitializeCulture()
{
string languagePost = "";
try
{
if (Request.Form["ctl00_Category_ASPxRoundPanel1_Language_VI"] != null)
{
languagePost = Request.Form["ctl00_Category_ASPxRoundPanel1_Language_VI"];
}
}
catch (Exception)
{
}
// init variable
SYS_Language sysLanguage;
string culture = "";
int langId = 0;
if (!string.IsNullOrEmpty(languagePost))
{
langId = int.Parse(languagePost);
}
SYS_Session session = (SYS_Session)Session["SYS_Session"];
if (langId == 0)
{
if (session == null || session.langId == 0)
{
langId = _isysLanguageService.SelectDefaultLanguage().ID;
}
else
{
langId = session.langId;
}
}
sysLanguage = _isysLanguageService.SelectSYS_Language(langId);
// create culture
if (sysLanguage != null)
{
culture = sysLanguage.Code;
}
if (culture != "")
{
culture = culture.Trim();
var ci = new System.Globalization.CultureInfo(culture);
System.Threading.Thread.CurrentThread.CurrentCulture = ci;
System.Threading.Thread.CurrentThread.CurrentUICulture = ci;
}
base.InitializeCulture();
Session["SYS_Session"] = session;
PageLoad();
}
private void LoadTram()
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
DataTable ds = db.SELECT_TTTT_TRAM_CAD(session.User.ma_dviqlyDN);
grdTram.DataSource = ds;
grdTram.DataBind();
}
private void _DataBind()
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
var dt = db.SELECT_TTTT_DM_TTKD();
grdDVT.DataSource = dt;
grdDVT.DataBind();
}
private void LoadKH()
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
DataTable ds = db.SELECT_TTTT_KHACHHANG_LUUY(session.User.ma_dviqlyDN);
grdKH.DataSource = ds;
grdKH.DataBind();
}
private bool CheckName(string Name, int id)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
var dt = db.DM_Los.SingleOrDefault(x => x.MaLo == Name && x.IDMaDViQly == int.Parse(session.User.ma_dviqly) && x.IDTram != id);
if (dt != null)
return false;
return true;
}
private void LoadUser()
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
txtUserName.Text = session.User.USERNAME;
txtFullName.Text = session.User.HOTEN;
txtSDT.Text = session.User.SODT;
txtEmail.Text = session.User.EMAIL;
}
protected void cmbCuoiNguon_SelectedIndexChanged(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
DM_DVQLYService dm_dviSer = new DM_DVQLYService();
var dvDN = dm_dviSer.SelectDM_DVQLY(int.Parse(session.User.ma_dviqly));
var dvChon = dm_dviSer.SelectDM_DVQLY(int.Parse(cmbCuoiNguon.Value + ""));
txtMaDuongDat.Text = dvDN.MA_DVIQLY + "_" + dvChon.MA_DVIQLY;
}
protected void Page_Load(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
session.FuncID = funcid;
if (!IsPostBack)
{
if (session == null || session.User.USERNAME == "Guest")
{
session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath;
Response.Redirect("~\\Login.aspx");
}
else
{
if (Request.Cookies["IDUSER"].Value != "1")
{
List <SYS_Right> right = session.User.Rights;
foreach (SYS_Right sysRight in right)
{
if (sysRight.FuncId == funcid)
{
rightOfUser = sysRight;
if (!rightOfUser.IsCreate)
{
btnAdd.Enabled = false;
}
if (!rightOfUser.IsDelete)
{
btnRemove.Enabled = false;
}
if (!rightOfUser.IsUpdate)
{
btnSubmit.Enabled = false;
}
Session["UserId"] = session.User.IDUSER;
Session["FunctionId"] = sysRight.FuncId;
break;
}
}
if (rightOfUser == null)
{
Session["Status"] = "0";
Response.Redirect("~\\HeThong\\Default.aspx");
}
session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath;
}
}
Session["SYS_Session"] = session;
_DataBind();
}
else
{
grdRightOfRoles.DataSource = Session["ListRight"];
grdRightNotRoles.DataSource = Session["ListLeft"];
}
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
if (Session["Add"] + "" == "0")
{
CBDN.DM_NguoiPhuTrachSelectByIDDViResult cv = (CBDN.DM_NguoiPhuTrachSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
CBDN.DM_PhuTrachDuongDay tinhtrang = db.DM_PhuTrachDuongDays.SingleOrDefault(x => x.ID == cv.ID);
if (!CheckName(txtMaPhong.Text, cv.ID))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã cán bộ không được trùng');", true); return;
}
if (txtTenPhong.Value + "" == "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Tên cán bộ không thể bỏ trống');", true);
return;
}
//CBDN.DM_PhuTrachDuongDay qtCT = new CBDN.DM_PhuTrachDuongDay();
tinhtrang.TenNhanVien = txtTenPhong.Text;
tinhtrang.DienThoai = txtSDT.Text;
tinhtrang.ChucVu = txtChucVu.Text;
tinhtrang.DiaChi = txtDiaChi.Text;
db.SubmitChanges();
}
else
{
if (txtMaPhong.Text + "" == "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã cán bộ không được để trống');", true);
txtMaPhong.Focus(); return;
}
if (txtTenPhong.Text == "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Tên cán bộ không được để trống');", true);
txtTenPhong.Focus(); return;
}
if (!CheckName(txtMaPhong.Text, 0))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã cán bộ không được trùng');", true); return;
}
CBDN.DM_PhuTrachDuongDay cv = new CBDN.DM_PhuTrachDuongDay();
cv.MaNhanVien = txtMaPhong.Text;
cv.TenNhanVien = txtTenPhong.Text;
cv.IDDonVi = int.Parse(cmbMaDonVi.Value + "");
cv.DiaChi = txtDiaChi.Text;
cv.ChucVu = txtChucVu.Text;
cv.DienThoai = txtSDT.Text;
db.DM_PhuTrachDuongDays.InsertOnSubmit(cv);
db.SubmitChanges();
}
_DataBind();
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
if (Session["Add"] + "" == "0")
{
CBDN.DM_NhaMay cv = (CBDN.DM_NhaMay)grdDVT.GetRow(grdDVT.FocusedRowIndex);
CBDN.DM_NhaMay qtCT = db.DM_NhaMays.SingleOrDefault(x => x.ID == cv.ID);
if (!CheckName(txtMaPhong.Text, cv.ID))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã nhà máy không được trùng');", true); return;
}
if (txtTenPhong.Value + "" == "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Tên nhà máy không thể bỏ trống');", true);
return;
}
//CBDN.DM_NhaMay qtCT = new CBDN.DM_NhaMay();
qtCT.TenNhaMay = txtTenPhong.Text;
qtCT.DienThoai = txtSDT.Text;
qtCT.MoTa = txtMota.Text;
qtCT.DiaChi = txtDiaChi.Text;
db.SubmitChanges();
}
else
{
if (txtMaPhong.Text + "" == "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã nhà máy không được để trống');", true);
txtMaPhong.Focus(); return;
}
if (txtTenPhong.Text == "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Tên nhà máy không được để trống');", true);
txtTenPhong.Focus(); return;
}
if (!CheckName(txtMaPhong.Text, 0))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã nhà máy không được trùng');", true); return;
}
CBDN.DM_NhaMay cv = new CBDN.DM_NhaMay();
cv.MaNhaMay = txtMaPhong.Text;
cv.TenNhaMay = txtTenPhong.Text;
cv.IDMADVIQLY = int.Parse(session.User.ma_dviqly + "");
cv.DiaChi = txtDiaChi.Text;
cv.MoTa = txtMota.Text;
cv.DienThoai = txtSDT.Text;
db.DM_NhaMays.InsertOnSubmit(cv);
db.SubmitChanges();
}
_DataBind();
}
protected void btnSua_Click(object sender, EventArgs e)
{
pcAddRoles.ShowOnPageLoad = true;
Session["Add"] = 0;
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.HD_SanLuongThuongPham cv = (CBDN.HD_SanLuongThuongPham)grdDVT.GetRow(grdDVT.FocusedRowIndex);
txtThang.Text = cv.Thang + "";
txtNam.Value = cv.Nam + "";
txtSanLuongDien.Text = cv.SLuongThuongPham + "";
}
protected void btnThem_Click(object sender, EventArgs e)
{
var thang = cmbThang.Value;
var nam = cmbNam.Value;
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
DataTable ds = db.SELECT_TRAM_HATHE_UT_TT_DS(session.User.ma_dviqlyDN, thang + "", nam + "");
grdKH.DataSource = ds;
grdKH.DataBind();
}
private bool CheckName(string Name, int id, string idPhuongThuc)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
var dt = db.DM_Trams.SingleOrDefault(x => x.MaTram == Name && x.IDTram != id && x.IDChiNhanh == idPhuongThuc);
if (dt != null)
{
return(false);
}
return(true);
}
private bool CheckName(string Name, int id)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
var dt = db.TTTT_DM_LOAIDUONGDAY_CHECKNAME(id, session.User.ma_dviqlyDN, Name);
if (dt.Rows.Count > 0)
{
return(false);
}
return(true);
}
protected void btnSua_Click(object sender, EventArgs e)
{
pcAddRoles.ShowOnPageLoad = true;
Session["Add"] = 0;
SYS_Session session = (SYS_Session)Session["SYS_Session"];
var cv = (DataRowView)grdDVT.GetRow(grdDVT.FocusedRowIndex);
txtDienTro.Text = cv["DienTroSuat"] + "";
txtMaLoaiDay.Text = cv["MaLoaiDay"] + "";
txtTenLoaiDay.Text = cv["TenLoaiDay"] + "";
cmbLoaiDay.Value = cv["LoaiDay"] + "";
}
