private void btnSearchAdvance_Click(object sender, EventArgs e)
{
lvTrips_Load(Chuyen.Find(expression));
expression = "";
lv.Items.Clear();
RadiosCheckState();
}
private void FrmLCDNangSuatCum_Load(object sender, EventArgs e)
{
try
{
LoadLCDConfig();
//Get list Chuyen
listChuyen = chuyenDAO.GetListChuyenInfByListId(AccountSuccess.strListChuyenId);
if (listChuyen != null && listChuyen.Count > 0)
{
line = listChuyen.First();
listClusterOfLine = cumDAO.GetListClusterOfLine(line.MaChuyen);
titleLCD += " " + line.TenChuyen;
listModelWorkHours = BLLShift.GetListWorkHoursOfLineByLineId(int.Parse(line.MaChuyen));// shiftDAO.GetListWorkHoursOfLineByLineId(line.MaChuyen);
}
//Get config information
listTableLayoutPanelConfig = tableLayoutPanelConfigDAO.GetTableLayoutPanelConfig(tableType);
//Get config panel
listPanelConfig = panelConfigDAO.GetPanelConfig(tableType);
//Get label config
listLabelConfig = labelConfigDAO.GetLabelConfig(tableType);
//Get label for tablepanel
listLabelForTablePanel = labelConfigDAO.GetLabelForTablePanel(tableType);
BuildPanelHeader();
BuildPanelTitle1();
BuildPanelContent();
BuildPanelBody();
initTimerDateTime();
LoadDataLCDNSCum();
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message);
}
}
private void UpdateStatus()
{
List <Chuyen> list = listTrip.FindAll(
delegate(Chuyen t)
{
return(t.TrangThai == 1 && t.NgayDi >= DateTime.Now);
});
if (list.Count > 0)
{
foreach (Chuyen item in list)
{
item.TrangThai = 0;
if (!Chuyen.Update(item))
{
DialogResult dlg = MessageBox.Show(String.Format("Updating had been failse at the trip which has code {0}! Do you want to be Updeting?", item.MChuyen), "Error", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (dlg == System.Windows.Forms.DialogResult.No)
{
return;
}
}
}
MessageBox.Show("Updating is sucessful!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
private bool FindKey(Chuyen t)
{
string value = txtSearchKey.Text;
if (t.MChuyen.ToString().Contains(value))
{
return(true);
}
else if (t.TenTour.ToString().Contains(value))
{
return(true);
}
else if (t.TrangThai.ToString().Contains(value))
{
return(true);
}
else if (t.XuatPhat.ToString().Contains(value))
{
return(true);
}
else if (t.NgayDi.ToShortDateString().Contains(value))
{
return(true);
}
else if (t.NgayVe.ToShortDateString().Contains(value))
{
return(true);
}
else
{
return(false);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (listGuideChoose.Count > 0)
{
if (TestPrice())
{
current.TrangThai = cbbStatus.SelectedItem.ToString() == "Đang mở" ? 1 : cbbStatus.SelectedItem.ToString() == "Đã đóng" ? 0 : -1;
current.MTour = (cbbTours.SelectedItem as Tour).ID;
current.NgayDi = dtpStart.Value;
current.NgayVe = dtpEnd.Value;
current.Gia = MyConvert.ToDouble(txtPrice.Text);
if (Chuyen.Update(current))
{
MessageBox.Show("Updating is sucessful!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
MessageBox.Show("Updating had been failse!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return;
}
}
MessageBox.Show("You need choose the guiders!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
private void LoadTaiKhoanRaDataGridView()
{
var floor = ((PMS.Data.Floor)cboFloor.SelectedItem);
Chuyen chuyen = ((Chuyen)cbbChuyen.SelectedItem);
dgThongTinTaiKhoan.Rows.Clear();
dgThongTinTaiKhoan.Refresh();
taikhoanDAO.LoadOBJToDataGirdview(dgThongTinTaiKhoan, chuyen.MaChuyen, floor.IdFloor.ToString());
}
private void btnAdd_Click(object sender, EventArgs e)
{
Tripfrm frm = new Tripfrm();
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
listTrip = Chuyen.All();
btnAll.PerformClick();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
Tripfrm frm = new Tripfrm();
frm.MChuyen = MyConvert.ToInt32(lvTrips.SelectedItems[0].SubItems[0].Text);
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
listTrip = Chuyen.All();
btnAll.PerformClick();
}
}
private void lvGuide_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvGuide.SelectedItems.Count > 0)
{
lvTours_Load(Tour.FindByMHDV(lvGuide.SelectedItems[0].SubItems[0].Text));
lvTrips_Load(Chuyen.FindByHDV(lvGuide.SelectedItems[0].SubItems[0].Text));
btnUpdate.Enabled = true;
}
else
{
btnUpdate.Enabled = false;
}
}
private Chuyen controls_Load()
{
Chuyen result = new Chuyen();
result.MChuyen = _MChuyen;
Tour t = cbbTours.SelectedItem as Tour;
result.MTour = t.ID;
result.NgayDi = dtpStart.Value;
result.NgayVe = dtpEnd.Value;
result.Gia = MyConvert.ToDouble(txtPrice.Text);
result.TrangThai = cbbStatus.SelectedItem.ToString() == "Đang mở" ? 1 : cbbStatus.SelectedItem.ToString() == "Đã hủy" ? -1 : 0;
return(result);
}
private void LoadDSChuyen()
{
List <Chuyen> listChuyen = new List <Chuyen>();
Chuyen chuyenf = new Chuyen();
chuyenf.MaChuyen = "";
chuyenf.TenChuyen = "(None)";
listChuyen.Add(chuyenf);
listChuyen.AddRange(chuyenDAO.GetListChuyenInfByListId(AccountSuccess.strListChuyenId));
// Load thong tin vao combobox chuyen san xuat cua tad thanh pham
cboChuyen.DataSource = listChuyen;
cboChuyen.DisplayMember = "TenChuyen";
cboChuyen.SelectedIndex = 0;
}
private void cbbTours_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbbTours.SelectedIndex > -1)
{
Tour t = cbbTours.SelectedItem as Tour;
listGuideNoChoose = HuongDanVien.FindBy_MTour_NotBusy(t.ID);
if (MChuyen == 0)
{
listGuideChoose = new List <HuongDanVien>();
lvGuidesChosed.Items.Clear();
}
else
{
//Load ds huong dan vien duoc phan cong len
listGuideChoose = HuongDanVien.FindByMChuyen(MChuyen);
lvGuidesChosed_Load(listGuideChoose);
//Chuyen thanh tour khac
if (current != null && (cbbTours.SelectedItem as Tour).ID != current.MTour)
{
DialogResult dlg = MessageBox.Show("Program remove all guides had been chose! Are you wanting repair this trip?", "Wraning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dlg == System.Windows.Forms.DialogResult.Yes)
{
PhanCongHDV.DeletePhanCong(MChuyen);
lvGuidesChosed.Items.Clear();
listGuideChoose = new List <HuongDanVien>();
listGuideNoChoose = HuongDanVien.FindBy_MTour_NotBusy((cbbTours.SelectedItem as Tour).ID);
lvGuidesNoChoose_Load(listGuideNoChoose);
//btnAdd.Enabled = false;
//btnUpdate.Enabled = false;
}
else
{
int count = cbbTours.Items.Count;
for (int i = 0; i < count; i++)
{
if ((cbbTours.Items[i] as Tour).ID == current.MTour)
{
cbbTours.SelectedIndex = i;
break;
}
}
}
}
}
lvGuidesNoChoose_Load(listGuideNoChoose);
//Thoong ke tinh gia
listPrice = Chuyen.FindByMTour(t.ID);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (TestPrice())
{
if (listGuideChoose == null || listGuideChoose.Count == 0)
{
MessageBox.Show("You do not choose the Guiders!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
btnAdd.Enabled = false;
return;
}
DialogResult dlg = MessageBox.Show("Are you adding this trip?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dlg == System.Windows.Forms.DialogResult.Yes)
{
Chuyen ch = controls_Load();
int _MT = (cbbTours.SelectedItem as Tour).ID;
int _MC = Chuyen.Add(ch);
if (_MC > 0)
{
PhanCongHDV pc;
List <PhanCongHDV> listPC = new List <PhanCongHDV>();
foreach (HuongDanVien item in listGuideChoose)
{
pc = new PhanCongHDV();
pc.MChuyen = _MC;
pc.MTour = _MT;
pc.MHDV = item.ID;
if (!PhanCongHDV.Add(pc))
{
DialogResult dl = MessageBox.Show(String.Format("Division had been failse with the guide has code: {0} and name: {1} {2}! Are you wanting to continue?", item.ID, item.Ho, item.Ten), "Error", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (dl == System.Windows.Forms.DialogResult.No)
{
return;
}
}
}
MessageBox.Show("Adding is successful!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
int index = cbbTours.SelectedIndex;
cbbTours.SelectedIndex = -1;
cbbTours.SelectedIndex = index;
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
MessageBox.Show("Adding had been failse!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
public int UpdateObj(Chuyen chuyen)
{
int kq = 0;
try
{
string sql = "update Chuyen set Code='" + chuyen.Code + "', TenChuyen =N'" + chuyen.TenChuyen + "', DinhNghia = N'" + chuyen.DinhNghia + "', Sound=N'" + chuyen.Sound + "', Floor=" + chuyen.Floor + ", LaoDongDinhBien=" + chuyen.LaoDongDinhBien + " where MaChuyen = '" + chuyen.MaChuyen + "' and IsDeleted=0";
kq = dbclass.TruyVan_XuLy(sql);
}
catch (Exception ex)
{
throw ex;
}
return(kq);
}
public int AddObj(Chuyen chuyen)
{
int kq = 0;
try
{
string sql = "insert into Chuyen(Code, TenChuyen, DinhNghia, Sound, Floor, LaoDongDinhBien) values('" + chuyen.Code + "',N'" + chuyen.TenChuyen + "',N'" + chuyen.DinhNghia + "', N'" + chuyen.Sound + "', " + chuyen.Floor + ", " + chuyen.LaoDongDinhBien + ")";
kq = dbclass.TruyVan_XuLy(sql);
}
catch (Exception ex)
{
throw ex;
}
return(kq);
}
private void Tripfrm_Load(object sender, EventArgs e)
{
cbbTours_Load();
if (_MChuyen == 0)
{
btnUpdate.Visible = false;
listTrips = Chuyen.FindByStatus(1);
cbbStatus.SelectedIndex = 0;
}
else
{
btnAdd.Visible = false;
current = Chuyen.Single(MChuyen);
txtCode.Text = MChuyen.ToString();
txtPrice.Text = current.Gia.ToString();
int count = cbbTours.Items.Count;
for (int i = 0; i < count; i++)
{
if ((cbbTours.Items[i] as Tour).ID == current.MTour)
{
cbbTours.SelectedIndex = i;
break;
}
}
dtpStart.Value = current.NgayDi;
dtpEnd.Value = current.NgayVe;
if (current.TrangThai >= 1)
{
cbbStatus.SelectedIndex = 0;
}
else
if (current.TrangThai == 0)
{
cbbStatus.SelectedIndex = 1;
}
else
{
cbbStatus.SelectedIndex = 2;
}
if (current.NgayDi < DateTime.Today)
{
cbbTours.Enabled = false;
}
}
}
private void LoadPhanCongRaDataGridView()
{
listPCC = new List <ChuyenSanPham>();
Chuyen chuyen = ((Chuyen)cbbChuyen.SelectedItem);
if (chuyen != null)
{
gridControl1.DataSource = null;
asigns = BLLAssignmentForLine.Instance.GetDataForGridView(chuyen.MaChuyen);
gridControl1.DataSource = asigns;
if (asigns != null && asigns.Count > 0)
{
txtSTTThucHien.Value = asigns.OrderByDescending(x => x.STT_TH).FirstOrDefault().STT_TH + 1;
}
}
}
private void GetDayInformationToGridView()
{
try
{
Chuyen line = (Chuyen)cbbChuyen.SelectedItem;
if (line != null)
{
gridControl.DataSource = null;
var listInformation = BLLProductivity.GetDailyWorkerInformation(line.MaChuyen, dtpNgayLamViec.Value);
if (listInformation != null && listInformation.Count > 0)
{
gridControl.DataSource = listInformation;
}
}
}
catch (Exception) { }
}
private void cbbStatus_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbbStatus.SelectedIndex >= 0)
{
//lvTrips_Load(listTrip.FindAll(
// delegate(Chuyen t)
// {
// return t.TrangThai == (cbbStatus.SelectedItem.ToString() == "Đang mở" ? 1 : cbbStatus.SelectedItem.ToString() == "Đã hủy" ? -1 : 0);
// }
// ));
lvTrips_Load(Chuyen.FindByStatus(cbbStatus.SelectedItem.ToString() == "Đang mở" ? 1 : cbbStatus.SelectedItem.ToString() == "Đã hủy" ? -1 : 0));
}
else
{
btnAll.PerformClick();
}
}
public Chuyen GetLineById(string lineId, string strListLineId)
{
try
{
Chuyen chuyen = null;
var listLine = GetListChuyenInfByListId(strListLineId);
if (listLine != null && listLine.Count > 0)
{
chuyen = listLine.Where(c => c.MaChuyen.Trim() == lineId.Trim()).FirstOrDefault();
}
return(chuyen);
}
catch (Exception ex)
{
throw ex;
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult dlg = MessageBox.Show("Are you want to delete this trip?", "Quession", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dlg == System.Windows.Forms.DialogResult.Yes)
{
if (!Chuyen.Delete(MyConvert.ToInt32(lvTrips.SelectedItems[0].SubItems[0].Text)))
{
MessageBox.Show("Deleting had been faile", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Deleting is sucessful", "Error", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
btnAll.PerformClick();
}
}
}
public ActionResult Guests(string chuyenDi)
{
//Session["driver"] = "1";
// //Lấy mã nv từ session
short manv = short.Parse(Session["driver"].ToString());
// //Lấy danh sách các chuyến xe của tài xế đó
DataTable tableChuyenXe = load.queryTable("select MACHUYEN, TENCHUYEN from NHANVIEN, XE, CHUYENXE where NHANVIEN.MANV = XE.MANV and XE.MAXE = CHUYENXE.MAXE and NHANVIEN.MANV = " + manv); //(from CHUYENXE in db.CHUYENXEs where CHUYENXE.MANV == manv select CHUYENXE).ToList();
List <CHUYENXE> listChuyenXe = new List <CHUYENXE>();
for (int i = 0; i < tableChuyenXe.Rows.Count; i++)
{
CHUYENXE item = new CHUYENXE();
item.MACHUYEN = tableChuyenXe.Rows[i][0].ToString();
item.TENCHUYEN = tableChuyenXe.Rows[i][1].ToString();
listChuyenXe.Add(item);
}
// //đổ dữ liệu vào select với value là MACHUYEN, text là TENCHUYEN
CHUYENXE init = new CHUYENXE();
init.MACHUYEN = "0";
init.TENCHUYEN = "Chọn chuyến xe";
listChuyenXe.Add(init);
SelectList select = new SelectList(listChuyenXe, "MACHUYEN", "TENCHUYEN", init);
// //gắn select vào view
ViewBag.select = select;
string queryListVe = "select mave, tenkh, vitrighengoi from VEXE, KHACHHANG where VEXE.MAKH = KHACHHANG.MAKH ";
if (chuyenDi != null)
{
queryListVe += "and MACHUYENXE = " + chuyenDi;
}
DataTable tbVe = load.queryTable(queryListVe);
List <Chuyen> listLinks = new List <Chuyen>();
for (int i = 0; i < tbVe.Rows.Count; i++)
{
Chuyen temp = new Chuyen();
temp.MAVE = tbVe.Rows[i][0].ToString();
temp.HOTEN = tbVe.Rows[i][1].ToString();
temp.SOGHE = int.Parse(tbVe.Rows[i][2].ToString());
listLinks.Add(temp);
}
ViewBag.ls = listLinks;
return(View());
}
private void LoadDSSanPham()
{
dtSanPham.Clear();
Chuyen chuyen = ((Chuyen)cboChuyen.SelectedItem);
listSPCuaChuyen.Clear();
if (chuyen.MaChuyen != "")
{
//load sanpham cua chuyen
dtSanPham = chuyen_sanphamDAO.DSPhanCongCuaChuyen_BTPLoi(chuyen.MaChuyen);
if (dtSanPham.Rows.Count > 0)
{
foreach (DataRow drow in dtSanPham.Rows)
{
SanPhamCuaChuyen spcuachuyen = new SanPhamCuaChuyen();
spcuachuyen.STT = drow["STT"].ToString();
spcuachuyen.TenSanPham = drow["TenSanPham"].ToString();
spcuachuyen.NangXuatSanXuat = float.Parse(drow["NangXuatSanXuat"].ToString());
spcuachuyen.SanLuongKeHoach = int.Parse(drow["SanLuongKeHoach"].ToString());
spcuachuyen.LuyKeTH = int.Parse(drow["LuyKeTH"].ToString());
spcuachuyen.BTPLoi = int.Parse(drow["BTPLoi"].ToString());
cboSanPham.Items.Add(spcuachuyen);
}
}
else
{
MessageBox.Show("Bạn chưa phân công mặt hàng cho chuyền này hay chưa nhập thông tin trong ngày cho chuyền, Vui lòng thực hiện thao tác Phân Công Cho Chuyên", "Lỗi Thực Hiện", MessageBoxButtons.OK, MessageBoxIcon.Error);
SanPhamCuaChuyen spcuachuyen = new SanPhamCuaChuyen {
STT = "", TenSanPham = "(None)", LuyKeTH = 0, SanLuongKeHoach = 0, MaSanPham = "", NangXuatSanXuat = 0
};
cboSanPham.Items.Add(spcuachuyen);
}
}
else
{
SanPhamCuaChuyen spcuachuyen = new SanPhamCuaChuyen {
STT = "", TenSanPham = "(None)", LuyKeTH = 0, SanLuongKeHoach = 0, MaSanPham = "", NangXuatSanXuat = 0
};
cboSanPham.Items.Add(spcuachuyen);
}
cboSanPham.DisplayMember = "TenSanPham";
cboSanPham.SelectedIndex = 0;
}
private bool AddTrip(int _codeTrip)
{
Chuyen newTrip = ListTrips.Single(_codeTrip);
if (newTrip != null)
{
foreach (Chuyen item in listOrder)
{
if (item.TrangThai == 1 && ((item.NgayDi >= newTrip.NgayDi && item.NgayVe >= newTrip.NgayVe) || (item.NgayDi <= newTrip.NgayDi && item.NgayVe >= newTrip.NgayVe) ||
(item.NgayDi <= newTrip.NgayDi && item.NgayVe <= newTrip.NgayVe)))
{
return(false);
}
}
listOrder.Add(newTrip);
return(true);
}
return(false);
}
public List <Chuyen> GetListChuyenInfByListId(string listIdstr)
{
List <Chuyen> listChuyenInf = new List <Chuyen>();
try
{
if (!string.IsNullOrEmpty(listIdstr))
{
string sql = "select c.MaChuyen, c.Code, c.TenChuyen, c.Sound, c.FloorId, c.IdDen, c.IdDenNangSuat, c.IdTyLeDoc, c.IsEndDate, c.IntSTT, c.STTReadNS, r.Name TenTyLeDoc from Chuyen c left join ReadPercent r on c.IdTyLeDoc=r.Id Where c.MaChuyen in (" + listIdstr + ")";
DataTable dt = dbclass.TruyVan_TraVe_DataTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Chuyen Chuyen = new Chuyen();
Chuyen.MaChuyen = row["MaChuyen"].ToString();
Chuyen.TenChuyen = row["TenChuyen"].ToString();
int sttReadNS = 0;
int.TryParse(row["STTReadNS"].ToString(), out sttReadNS);
Chuyen.STTReadNS = sttReadNS;
int idDen = 0;
int.TryParse(row["IdDen"].ToString(), out idDen);
Chuyen.IdDen = idDen;
int idDenNangSuat = 0;
int.TryParse(row["IdDenNangSuat"].ToString(), out idDenNangSuat);
Chuyen.IdDenNangSuat = idDenNangSuat;
Chuyen.Floor = row["FloorId"].ToString();
Chuyen.Sound = row["Sound"].ToString();
int idTyLeDoc = 0;
int.TryParse(row["IdTyLeDoc"].ToString(), out idTyLeDoc);
Chuyen.IdTyLeDoc = idTyLeDoc;
Chuyen.TenTyLeDoc = row["TenTyLeDoc"].ToString().Trim();
listChuyenInf.Add(Chuyen);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(listChuyenInf);
}
private void LoadListTeam(string idfloor)
{
cbbChuyen.DataSource = null;
cbbChuyen.Refresh();
DataTable dtchuyen = new DataTable();
List <Chuyen> listChuyen = new List <Chuyen>();
Chuyen chuyen1 = new Chuyen();
chuyen1.MaChuyen = "0";
chuyen1.TenChuyen = "(None)";
listChuyen.Add(chuyen1);
var listChuyenInDB = chuyenDAO.GetListChuyenInfByListId(AccountSuccess.strListChuyenId);
if (listChuyenInDB != null && listChuyenInDB.Count > 0)
{
listChuyen.AddRange(listChuyenInDB);
}
cbbChuyen.DataSource = listChuyen;
cbbChuyen.DisplayMember = "TenChuyen";
}
private void Tripsfrm_Load(object sender, EventArgs e)
{
btnAdd.Visible = false;
btnUpdate.Visible = false;
btnDelete.Visible = false;
if (Powers == PowersLog.Administrator || Powers == PowersLog.Saler)
{
btnAdd.Visible = true;
btnUpdate.Visible = true;
btnDelete.Visible = true;
}
dtpValue.EditValue = DateTime.Now;
dtpValue.Visible = false;
listTrip = Chuyen.All();
UpdateStatus();
listTrip = Chuyen.All();
btnAll.PerformClick();
cbbColumn_Load();
RadiosCheckState();
}
private void FrmLCDError_Load(object sender, EventArgs e)
{
try
{
LoadLCDConfig();
//Get list Chuyen
listChuyen = chuyenDAO.GetListChuyenInfByListId(AccountSuccess.strListChuyenId);
if (listChuyen != null && listChuyen.Count > 0)
{
line = listChuyen.First();
titleLCD += " " + line.TenChuyen;
}
//Get config information
listTableLayoutPanelConfig = tableLayoutPanelConfigDAO.GetTableLayoutPanelConfig(tableType);
//Get config panel
listPanelConfig = panelConfigDAO.GetPanelConfig(tableType);
//Get label config
listLabelConfig = labelConfigDAO.GetLabelConfig(tableType);
//Get label for tablepanel
listLabelForTablePanel = labelConfigDAO.GetLabelForTablePanel(tableType);
modelLCDError = BLLError.GetListGroupErrors();// groupErrorDAO.GetListGroupErrorDetail();
BuildPanelHeader();
BuildPanelTitle1();
BuildPanelContent();
BuildPanelBody();
initTimerDateTime();
LoadDataErorForChuyen();
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message);
}
}
private void btnLuuTK_Click(object sender, EventArgs e)
{
Floor floor = ((Floor)cboFloor.SelectedItem);
Chuyen chuyen = ((Chuyen)cbbChuyen.SelectedItem);
TaiKhoan obj = new TaiKhoan();
obj.TenChuTK = txtTenNhanVien.Text;
obj.TenTaiKhoan = txtTaiKhoan.Text;
obj.MatKhau = txtMatKhau.Text;
obj.Floor = floor.IdFloor.ToString();
if (rdbThanhPham.Checked == true)
{
obj.ThanhPhan = 1;
obj.BTP = 0;
}
else if (rdbBTP.Checked == true)
{
obj.ThanhPhan = 0;
obj.BTP = 1;
}
else
{
obj.ThanhPhan = 1;
obj.BTP = 1;
}
if (chkQuyenThaoTac.Checked)
{
obj.ThaoTac = 1;
}
else
{
obj.ThaoTac = 0;
}
if (sukienphanquyen == "them")
{
int kq = 0;
kq = taikhoanDAO.ThemOBJ(obj);
if (kq != -1)
{
MessageBox.Show("Thêm tài khoản thành công.");
btnThemTK.Enabled = true;
btnSuaTK.Enabled = true;
btnXoaTK.Enabled = true;
btnLuuTK.Enabled = false;
btnHuyTK.Enabled = false;
txtTenNhanVien.Enabled = false;
txtTaiKhoan.Enabled = false;
txtMatKhau.Enabled = false;
cbbHienMatKau.Enabled = false;
rdbBTP.Enabled = false;
rdbThanhPham.Enabled = true;
rdbThanhPhamVaBTP.Enabled = false;
LoadTaiKhoanRaDataGridView();
}
else
{
MessageBox.Show("Quá trình thêm tài khoản thất bại.\n Lỗi: " + dbclass.error);
}
}
else
{
int kq = 0;
kq = taikhoanDAO.SuaThongTinOBJ(obj);
if (kq != -1)
{
MessageBox.Show("Thay đổi thông tin tài khoản thành công.");
btnThemTK.Enabled = true;
btnSuaTK.Enabled = true;
btnXoaTK.Enabled = true;
btnLuuTK.Enabled = false;
btnHuyTK.Enabled = false;
txtTenNhanVien.Enabled = false;
txtTaiKhoan.Enabled = false;
txtMatKhau.Enabled = false;
cbbHienMatKau.Enabled = false;
rdbBTP.Enabled = false;
rdbThanhPham.Enabled = true;
rdbThanhPhamVaBTP.Enabled = false;
LoadTaiKhoanRaDataGridView();
}
else
{
MessageBox.Show("Quá trình thay đổi tài khoản thất bại.\n Lỗi: " + dbclass.error);
}
}
}
public static ResponseBase InsertOrUpdate(Chuyen obj)
{
var result = new ResponseBase();
try
{
var db = new PMSEntities();
Chuyen line = null;
line = db.Chuyens.FirstOrDefault(x => !x.IsDeleted && !x.Floor.IsDeleted && x.MaChuyen != obj.MaChuyen && x.Code.Trim().ToUpper().Equals(obj.Code.Trim().ToUpper()));
if (line != null)
{
result.IsSuccess = false;
result.Messages.Add(new Message()
{
Title = "Lỗi trùng mã", msg = "Mã chuyền này đã tồn tại vui lòng chọn mã chuyền khác."
});
}
else
{
var check = false;
if (obj.MaChuyen == 0)
{
db.Chuyens.Add(obj);
check = true;
}
else
{
line = db.Chuyens.FirstOrDefault(x => !x.IsDeleted && !x.Floor.IsDeleted && x.MaChuyen == obj.MaChuyen);
if (line != null)
{
line.Code = obj.Code;
line.TenChuyen = obj.TenChuyen;
line.DinhNghia = obj.DinhNghia;
line.Sound = obj.Sound;
line.LaoDongDinhBien = obj.LaoDongDinhBien;
line.FloorId = obj.FloorId;
check = true;
}
}
if (check)
{
db.SaveChanges();
result.IsSuccess = true;
result.Messages.Add(new Message()
{
Title = "Thông Báo", msg = "Lưu thành công."
});
}
else
{
result.IsSuccess = true;
result.Messages.Add(new Message()
{
Title = "Lỗi", msg = "không tìm thấy thông tin chuyền."
});
}
}
}
catch (Exception ex)
{
result.IsSuccess = true;
result.Messages.Add(new Message()
{
Title = "Lỗi", msg = "Lỗi Lưu thông tin không thành công.\n" + ex.Message
});
}
return(result);
}
