private void HienThiPhieuMuaHang() { string macongty = Session["congty"].ToString(); string idphieu = Session["maphieu"].ToString(); string manguoidung = Session["user"].ToString(); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <pdna>("select * from pdna where pdno='" + idphieu + "'and GSBH='" + macongty + "' and CFMID0='" + manguoidung + "'")); var list = db.ExecuteQuery <pdna>("select * from pdna where pdno='" + idphieu + "'and GSBH='" + macongty + "' and CFMID0='" + manguoidung + "'"); foreach (pdna phieu in list) { abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype); BDepartment donvi = BDepartmentDAO.TimMaDonVi(phieu.pddepid, macongty); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; txtTieuDe.Text = phieu.mytitle; lblPhieuMuaHang.Text = tenloaiphieuVN + " " + tenloaiphieuTW; lbldonvidenghi.Text = donvi.DepName; lblsophieu.Text = idphieu; lblMucDichSuDung.Text = phieu.UseIntent; string dinhdang = phieu.CFMDate0.ToString(); string thang = dinhdang.Substring(3, 2); string ngay = dinhdang.Substring(0, 2); string nam = dinhdang.Substring(6, 4); lblNgaytao.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + ""; } }
private void HienThiPhieuMuaHang() { string macongty = Session["congty"].ToString(); string idphieu = Session["maphieu"].ToString(); string manguoidung = Session["user"].ToString(); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <pdna>("select * from pdna where pdno='" + idphieu + "'and GSBH='" + macongty + "' and CFMID0='" + manguoidung + "'")); var list = db.ExecuteQuery <pdna>("select * from pdna where pdno='" + idphieu + "'and GSBH='" + macongty + "' and CFMID0='" + manguoidung + "'"); foreach (pdna phieu in list) { // pdna phieu = pdnaBUS.TimVanBanTheoMa(idphieu,macongty, true); if (phieu == null) { BDepartment donvi = BDepartmentDAO.TimMaDonVi(phieu.pddepid, macongty); string noidung = Session["noidung"].ToString(); string ngaytao = Session["ngaytao"].ToString(); abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; txtIDLoaiphieu.Text = loaiphieu.abtype; txtIDDonVi.Text = donvi.ID; lbldonvidenghi.Text = donvi.DepName; lblsophieu.Text = idphieu; DateTime date = DateTime.Now; string dinhdang = DateTime.Parse(date.ToShortDateString()).ToString("dd/MM/yyyy"); string thang = dinhdang.Substring(3, 2); string ngay = dinhdang.Substring(0, 2); string nam = dinhdang.Substring(6, 4); lblNgaytao.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + ""; } else { BDepartment donvi = BDepartmentDAO.TimMaDonVi(phieu.pddepid, macongty); abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; txtIDLoaiphieu.Text = loaiphieu.abtype; lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; lbldonvidenghi.Text = donvi.DepName; lblsophieu.Text = idphieu; lblMucDichSuDung.Text = phieu.UseIntent; txtIDDonVi.Text = donvi.ID; string dinhdang = phieu.CFMDate0.ToString(); string thang = dinhdang.Substring(3, 2); string ngay = dinhdang.Substring(0, 2); string nam = dinhdang.Substring(6, 4); lblNgaytao.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + ""; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] == null) { //Response.Redirect("~/presentationLayer/DangNhap.aspx"); Response.Redirect("http://portal.footgear.com.vn"); } string strNgonngu = (string)Session["languege"]; if (strNgonngu != null) { LayngonNgu(25, strNgonngu); } else { Response.Redirect("http://portal.footgear.com.vn"); } GanNgonNguVaoConTrol(); if (!IsPostBack) { string maphieu = Session["maphieu"].ToString(); string macongty = Session["congty"].ToString(); string manguoidung = Session["user"].ToString(); //pdna phieu = pnaDAO.LayVanBanChuaDichTheoNguoiDich(maphieu, macongty, manguoidung); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <pdna>("select * from pdna where pdno='" + maphieu + "'and GSBH='" + macongty + "' and IDNguoiDich='" + manguoidung + "'")); var list = db.ExecuteQuery <pdna>("select * from pdna where pdno='" + maphieu + "'and GSBH='" + macongty + "' and IDNguoiDich='" + manguoidung + "'"); foreach (pdna phieu in list) { // string ngaythang = DateTime.Parse(phieu.CFMDate0.ToString("dd/MM/yyyy")); BDepartment bophan = BDepartmentBUS.TimMaDonVi(phieu.pddepid, macongty); abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; lbBoPhan.Text = bophan.DepName; txtNguoiDUyet.Text = phieu.CFMID1; //lbNgay.Text = ; lbNoiDung.Text = phieu.pdmemovn; lbSoPhieu.Text = phieu.pdno; lblTieuDe.Text = phieu.mytitle; txtTieuDe.Text = phieu.pdnsubject; CKEditorControl1.Text = phieu.NoiDungDich; string dinhdang = phieu.CFMDate0.ToString(); string thang = dinhdang.Substring(3, 2); string ngay = dinhdang.Substring(0, 2); string nam = dinhdang.Substring(6, 4); lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + ""; } } }
public void HienThiDanhSachMuaHang() { string macongty = Session["congty"].ToString(); string idphieu = Session["maphieu"].ToString(); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + idphieu + "' and b.GSBH='" + macongty + "'")); GridView1.DataSource = db.ExecuteQuery <BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + idphieu + "' and b.GSBH='" + macongty + "'"); GridView1.DataBind(); //GridView1.DataSource = pnaDAO.LayPhieuMuaHang(idphieu, macongty); //GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] == null) { //Response.Redirect("~/presentationLayer/DangNhap.aspx"); Response.Redirect("http://portal.footgear.com.vn"); } string maphieu = Session["maphieu"].ToString(); string macongty = Session["congty"].ToString(); string manguoidung = Session["user"].ToString(); //pdna phieu = pnaDAO.LayVanBanDaDichTheoNguoiDich(maphieu, macongty, manguoidung); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <pdna>("select * from pdna where pdno='" + maphieu + "'and GSBH='" + macongty + "' and IdnguoiDich='" + manguoidung + "'")); var list = db.ExecuteQuery <pdna>("select * from pdna where pdno='" + maphieu + "'and GSBH='" + macongty + "' and IdnguoiDich='" + manguoidung + "'"); foreach (pdna phieu in list) { BDepartment bophan = BDepartmentBUS.TimMaDonVi(phieu.pddepid, macongty); abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype); if (!IsPostBack) { string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; lbBoPhan.Text = bophan.DepName; lbLoaiPhieu.Text = loaiphieu.abname; //lbNgay.Text = ; txtTieuDe.Text = phieu.pdnsubject; lbNoiDung.Text = phieu.pdmemovn; lbSoPhieu.Text = phieu.pdno; string dinhdang = phieu.CFMDate0.ToString(); string thang = dinhdang.Substring(3, 2); string ngay = dinhdang.Substring(0, 2); string nam = dinhdang.Substring(6, 4); lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + ""; CKEditorControl1.Text = phieu.NoiDungDich; CKEditorControl1.ReadOnly = true; CKEditorControl1.Enabled = false; btnLuu.Enabled = false; } } }
protected void Page_Load(object sender, EventArgs e) { string strNgonngu = (string)Session["languege"]; if (strNgonngu != null) { LayngonNgu(2, strNgonngu); } else { Response.Redirect("http://portal.footgear.com.vn"); } GanNgonNguVaoConTrol(); if (!IsPostBack) { if (Session["user"] == null) { //Response.Redirect("~/presentationLayer/DangNhap.aspx"); Response.Redirect("http://portal.footgear.com.vn"); } string macongty = Session["congty"].ToString(); string idphieu = Session["maphieu"].ToString(); string bophan = Session["bophan"].ToString(); string manguoidung = Session["user"].ToString(); // pdna phieu = pdnaBUS.TimVanBanTheoMa(idphieu, macongty, true); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <pdna>("select * from pdna where pdno='" + idphieu + "'and GSBH='" + macongty + "' and CFMID0='" + manguoidung + "'")); var list = db.ExecuteQuery <pdna>("select * from pdna where pdno='" + idphieu + "'and GSBH='" + macongty + "' and CFMID0='" + manguoidung + "'"); foreach (pdna phieu in list) { abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; lbBoPhan.Text = bophan; lbSoPhieu.Text = idphieu; CKEditorControl1.Text = phieu.pdmemovn; } } }
protected void gvDetails_RowDeleting(object sender, GridViewDeleteEventArgs e) { string macongty = Session["congty"].ToString(); string idphieu = Session["maphieu"].ToString(); Label lblID = (Label)gvDetails.Rows[e.RowIndex].FindControl("lblIDAttactFile"); PDNLink Link = new PDNLink(); Link.ID = int.Parse(lblID.Text); Link.Gsbh = macongty; Link.pdno = idphieu; Link.Cancel = true; PDNLinkBUS.UpdateFile(Link); gvDetails.DataSource = db.ExecuteQuery <PDNLink>("select * from PDNLink where pdno='" + idphieu + "' and Gsbh='" + macongty + "' and Cancel='0'"); gvDetails.DataBind(); }
private void HienThiFileDinhKem() { string macongty = Session["congty"].ToString(); string idphieu = Session["maphieu"].ToString(); List <PDNLink> list = PDNLinkBUS.GetLinkAttactFileByPDNO(macongty, idphieu); if (list.Count > 0) { divUpload2.Visible = true; gvDetails.DataSource = db.ExecuteQuery <PDNLink>("select * from PDNLink where pdno='" + idphieu + "' and Gsbh='" + macongty + "' and Cancel='0'"); gvDetails.DataBind(); } else { divUpload2.Visible = false; } }
protected void btnKhoiPhuc_Click(object sender, EventArgs e) { dalPDN dal = new dalPDN(); string maphieu = Session["maphieu"].ToString(); string macongty = Session["congty"].ToString(); string manguoidung = Session["user"].ToString(); DateTime date = DateTime.Now; //string ngaytao = DateTime.Parse(date.ToShortDateString()).ToString("dd/MM/yyyy"); #region chua dung den //List<Abcon> DSphieu = AbconDAO.QryChiTietPhieuTheoPhieuKhongDuocDuyet(maphieu, macongty, manguoidung); //foreach (Abcon phieu in DSphieu) //{ // AbconDAO.XoaChiTietTheoSoPhieu(phieu.IDCT); //} //List<VanBanDen> DsVanBanden = VanBanDenDAO.QryVanBanDen(maphieu, macongty); //foreach (VanBanDen vanban in DsVanBanden) //{ // VanBanDenDAO.XoaVanBanDen(vanban.id); //} //List<PDNSheetFlow> DsChitiet = PDNSheetFlowDAO.QryPDNSheetFlowTheoPhieu(maphieu, macongty); //foreach (PDNSheetFlow chitiet in DsChitiet) //{ // PDNSheetFlowDAO.XoaPDNSheetFlow(chitiet.Id); //} //ABTrangThaiDuyet trangthai = TrangThaiDuyetDAO.TimKiemMaVanTheoTrangThaiDuyet(maphieu, macongty); //TrangThaiDuyetDAO.XoaTrangThaiDuyet(trangthai.IDTrangThai); #endregion DataTable dt = dal.DemSoLuongPhieu(); string aa = dt.Rows[0]["pdno"].ToString().Trim(); string maphieumoi = ""; if (dt.Rows.Count != 0 && aa != "") { string dem = (int.Parse(aa) + 1).ToString(); maphieumoi = dem; } else { maphieumoi = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("yyyyMM") + "00" + 1; } pdna timphieu = pnaDAO.TimVanBanTheoMa(maphieu, macongty, true); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <pdna>("select * from pdna where pdno='" + timphieu.pdno.ToString() + "'and GSBH='" + timphieu.GSBH.ToString() + "' and CFMID0='" + timphieu.CFMID0.ToString() + "'")); if (timphieu != null && timphieu.Abtype == "PDN2") { pdna phieub = new pdna(); phieub.pdno = maphieumoi; phieub.YN = 5; phieub.GSBH = macongty; phieub.dagui = false; phieub.bixoa = false; phieub.CFMDate0 = DateTime.Today; phieub.UseIntent = timphieu.UseIntent; phieub.IdnguoiDich = null; phieub.trangthaidich = false; phieub.NoiDungDich = null; phieub.LevelDoing = 1; phieub.CFMID0 = manguoidung; phieub.Abtype = timphieu.Abtype; phieub.ABC = timphieu.ABC; phieub.mytitle = timphieu.mytitle; phieub.pddepid = timphieu.pddepid; phieub.pdmemovn = timphieu.pdmemovn; phieub.oldpdno = timphieu.pdno; pnaDAO.InsertPDNA(phieub); // lay danh sach vat tu theo so phieu List <pdna1> list = PDNA1DAO.QryHangTheoPhieu(macongty, maphieu); foreach (pdna1 vattu in list) { dal.ThemHang1(macongty, vattu.CLBH, maphieumoi, vattu.Size, decimal.Parse(vattu.Qty.ToString()), vattu.Memo0, vattu.CLmemo); } } else { pdna phieub = new pdna(); phieub.pdno = maphieumoi; phieub.YN = 5; phieub.GSBH = macongty; phieub.dagui = false; phieub.bixoa = false; phieub.CFMDate0 = DateTime.Today; phieub.CFMDate1 = null; phieub.CFMDate2 = null; phieub.CFMDate4 = null; phieub.IdnguoiDich = null; phieub.trangthaidich = false; phieub.NoiDungDich = null; phieub.LevelDoing = 1; phieub.CFMID0 = manguoidung; phieub.Abtype = timphieu.Abtype; phieub.mytitle = timphieu.mytitle; phieub.pddepid = timphieu.pddepid; phieub.pdmemovn = timphieu.pdmemovn; phieub.oldpdno = timphieu.pdno; phieub.ABC = 1; pnaDAO.InsertPDNA(phieub); } #region chua dung den //pnaDAO.CapNhatPhieuBiHuy(phieub); //db.ExecuteCommand("update pdna set GSBH='" + phieub.GSBH.ToString() + "',NoiDungDich=N'" + phieub.NoiDungDich.ToString() + "',CFMDate1='" + phieub.CFMDate1 + "',trangthaidich='" + phieub.trangthaidich.Value + "',CFMDate0=N'" + phieub.CFMDate0 + "',CFMDate2=N'" + phieub.CFMDate2 + "',bixoa='" + phieub.bixoa.Value + "',dagui='" + phieub.dagui.Value + "',YN='" + int.Parse(phieub.YN.ToString()) + "',LevelDoing='" + int.Parse(phieub.LevelDoing.ToString()) + "',IdnguoiDich=N'" + phieub.IdnguoiDich.ToString() + "' where pdno=N'" + phieub.pdno.ToString() + "' "); // db.ExecuteCommand("update pdna set GSBH='" + phieub.GSBH.ToString() + "',NoiDungDich=N'" + phieub.NoiDungDich.ToString() + "',trangthaidich='" + phieub.trangthaidich.Value + "',CFMDate0=N'" + phieub.CFMDate0 + "',bixoa='" + phieub.bixoa.Value + "',dagui='" + phieub.dagui.Value + "',YN='" + int.Parse(phieub.YN.ToString()) + "',LevelDoing='" + int.Parse(phieub.LevelDoing.ToString()) + "',IdnguoiDich=N'" + phieub.IdnguoiDich.ToString() + "' where pdno=N'" + phieub.pdno.ToString() + "' "); // db.CapNhatPhieuDaBiHuy(phieub.pdno, phieub.GSBH, phieub.dagui, phieub.bixoa, phieub.YN, phieub.NoiDungDich, phieub.IdnguoiDich, phieub.trangthaidich, phieub.CFMDate1, phieub.CFMDate0, phieub.CFMDate2, phieub.CFMDate4, phieub.ABC, phieub.LevelDoing); #endregion Response.Redirect("DanhsachphieumoikhoitaoNV.aspx"); }
public static List <ABJobAgent> Kiemtranghiphep(DateTime ngaytao, string manguoiduyet, string macongty) { var list = db.ExecuteQuery <ABJobAgent>("select * from ABJobAgent where GSBH='" + macongty + "' and IDNguoiDuyet='" + manguoiduyet + "' and '" + ngaytao + "' between TuNgay and DenNgay"); return(list.ToList()); }
protected void Button1_Click1(object sender, EventArgs e) { // tao phieu mua hang string ngonngu = Session["languege"].ToString(); //string dem = (pdnaBUS.DemSoLuongVanBan() + 1).ToString(); //string maphieu = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("yyyyMMdd") + "00" + dem; string maphieu = ""; dalPDN dal = new dalPDN(); DataTable dt = dal.DemSoLuongPhieu(); string aa = dt.Rows[0]["pdno"].ToString().Trim(); if (dt.Rows.Count != 0 && aa != "") { string dem = (int.Parse(aa) + 1).ToString(); maphieu = dem; } else { maphieu = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("yyyyMM") + "00" + 1; } string bophan = DropDonVi.SelectedItem.Value.ToString(); string tieude = txtTieuDe.Text; string noidung = CKEditorControl1.Text; string bp = DropDonVi.SelectedItem.Text; string loaiP = DropLoaiPhieu.SelectedItem.Text; string macongty = Session["congty"].ToString(); string user = Session["user"].ToString(); string ngaythang = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"); string ngaythang1 = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("Ngày " + "dd" + "Tháng " + "MM" + "Năm" + "yyyy"); //string idphieu = Session["maphieu"].ToString(); string loaiphieu = DropLoaiPhieu.SelectedValue.ToString(); Busers2 timnguoitao = UserBUS.TimNhanVienTheoMa(user, macongty); if (timnguoitao.IDCapDuyet >= 12) { string madonvi = "CBCC"; Session["bp"] = madonvi; BDepartment bd = BDepartmentBUS.TimMaDonVi(madonvi, macongty); Busers2 us = UserBUS.TimMaNhanVienTheoBoPhan(user, madonvi, macongty); if (us == null) { Busers2 kiemtra = UserDAO.TimNhanVienQuanLyDonVi(user, madonvi, macongty); if (kiemtra == null) { if (ngonngu == "lbl_VN") { lbthongbao.Text = "Người dùng này không thuộc bộ phận " + bd.DepName; tablePMH.Visible = true; btnLuuTam.Enabled = false; btnTiepTu.Enabled = false; } else if (ngonngu == "lbl_TW") { lbthongbao.Text = "该用户不属于部门 " + bd.DepName; tablePMH.Visible = true; btnLuuTam.Enabled = false; btnTiepTu.Enabled = false; } else if (ngonngu == "lbl_EN") { lbthongbao.Text = "The user does not belong to the department" + bd.DepName; tablePMH.Visible = true; btnLuuTam.Enabled = false; btnTiepTu.Enabled = false; } } else { pdna phieun = new pdna(); { phieun.GSBH = macongty; phieun.pdno = maphieu; phieun.pddepid = bophan; phieun.mytitle = tieude; phieun.pdmemovn = noidung; phieun.CFMDate0 = DateTime.Parse(ngaythang); phieun.USERID = user; phieun.Abtype = DropLoaiPhieu.SelectedValue.ToString(); phieun.bixoa = false; phieun.CFMID0 = user; phieun.YN = 5; phieun.bixoa = false; phieun.USERDATE = DateTime.Parse(ngaythang); phieun.UseIntent = txtMucDich.Text; } db.pdnas.InsertOnSubmit(phieun); db.SubmitChanges(); string tenhang = txtTenHang.Text; //string tenhang = dropTenHang.SelectedValue; string donvitinh = txtdonvitinh.Text; string soluong = txtSoLuong.Text; string ghichu = txtGhiChu.Text; string Size = ""; if (txtSize.Text.Trim() == "") { Size = "."; } else { Size = txtSize.Text.Trim(); } pdna1 hang = new pdna1(); hang.GSBH = macongty; hang.pdNO = maphieu; db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'")); //GridView1.DataSource = db.ExecuteQuery<BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'"); //GridView1.DataBind(); tablePMH.Visible = false; btnLuuTam.Enabled = true; btnTiepTu.Enabled = true; } Busers2 usertao = UserBUS.TimNhanVienTheoMa(user, macongty); if (usertao != null && usertao.IDCapDuyet > 12) { Response.Redirect("FrmViewCB.aspx"); } else { if (ngonngu == "lbl_VN") { lbthongbao.Text = "Người dùng này không thuộc bộ phận " + bd.DepName; tablePMH.Visible = true; btnLuuTam.Enabled = false; btnTiepTu.Enabled = false; } else if (ngonngu == "lbl_TW") { lbthongbao.Text = "该用户不属于部门 " + bd.DepName; tablePMH.Visible = true; btnLuuTam.Enabled = false; btnTiepTu.Enabled = false; } else if (ngonngu == "lbl_EN") { lbthongbao.Text = "The user does not belong to the department" + bd.DepName; tablePMH.Visible = true; btnLuuTam.Enabled = false; btnTiepTu.Enabled = false; } } } else { pdna phieun = new pdna(); { phieun.GSBH = macongty; phieun.pdno = maphieu; phieun.pddepid = bophan; phieun.mytitle = tieude; phieun.pdmemovn = noidung; phieun.CFMDate0 = DateTime.Parse(ngaythang); phieun.USERID = user; phieun.Abtype = DropLoaiPhieu.SelectedValue.ToString(); phieun.bixoa = false; phieun.CFMID0 = user; phieun.YN = 5; phieun.bixoa = false; phieun.USERDATE = DateTime.Parse(ngaythang); phieun.UseIntent = txtMucDich.Text; } db.pdnas.InsertOnSubmit(phieun); db.SubmitChanges(); string tenhang = txtTenHang.Text; //string tenhang = dropTenHang.SelectedValue; string donvitinh = txtdonvitinh.Text; string soluong = txtSoLuong.Text; string ghichu = txtGhiChu.Text; BOfSupply hang = new BOfSupply(); hang.GSBH = macongty; hang.pdno = maphieu; hang.OfSuppliesName = tenhang; hang.BUnit = donvitinh; hang.BNumber = int.Parse(soluong); hang.BCommnent = ghichu; SuppliesDAO.ThemVatTu(hang); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'")); //GridView1.DataSource = db.ExecuteQuery<BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'"); //GridView1.DataBind(); tablePMH.Visible = false; btnLuuTam.Enabled = true; btnTiepTu.Enabled = true; } } else { BDepartment bd = BDepartmentBUS.TimMaDonVi(bophan, macongty); Busers2 us = UserBUS.TimMaNhanVienTheoBoPhan(user, bophan, macongty); if (us == null) { Busers2 kiemtra = UserDAO.TimNhanVienQuanLyDonVi(user, bophan, macongty); if (kiemtra == null) { if (ngonngu == "lbl_VN") { lbthongbao.Text = "Người dùng này không thuộc bộ phận " + bd.DepName; tablePMH.Visible = true; btnLuuTam.Enabled = false; btnTiepTu.Enabled = false; } else if (ngonngu == "lbl_TW") { lbthongbao.Text = "该用户不属于部门 " + bd.DepName; tablePMH.Visible = true; btnLuuTam.Enabled = false; btnTiepTu.Enabled = false; } else if (ngonngu == "lbl_EN") { lbthongbao.Text = "The user does not belong to the department" + bd.DepName; tablePMH.Visible = true; btnLuuTam.Enabled = false; btnTiepTu.Enabled = false; } } else { pdna phieun = new pdna(); { phieun.GSBH = macongty; phieun.pdno = maphieu; phieun.pddepid = bophan; phieun.mytitle = tieude; phieun.pdmemovn = noidung; phieun.CFMDate0 = DateTime.Parse(ngaythang); phieun.USERID = user; phieun.Abtype = DropLoaiPhieu.SelectedValue.ToString(); phieun.bixoa = false; phieun.CFMID0 = user; phieun.YN = 5; phieun.bixoa = false; phieun.USERDATE = DateTime.Parse(ngaythang); phieun.UseIntent = txtMucDich.Text; } db.pdnas.InsertOnSubmit(phieun); db.SubmitChanges(); string tenhang = txtTenHang.Text.ToUpper(); //string tenhang = dropTenHang.SelectedValue; string donvitinh = txtdonvitinh.Text.ToUpper(); string soluong = txtSoLuong.Text; string ghichu = txtGhiChu.Text; BOfSupply hang = new BOfSupply(); hang.GSBH = macongty; hang.pdno = maphieu; hang.OfSuppliesName = tenhang; hang.BUnit = donvitinh; hang.BNumber = int.Parse(soluong); hang.BCommnent = ghichu; SuppliesDAO.ThemVatTu(hang); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'")); //GridView1.DataSource = db.ExecuteQuery<BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'"); //GridView1.DataBind(); tablePMH.Visible = false; btnLuuTam.Enabled = true; btnTiepTu.Enabled = true; } //Busers2 usertao = UserBUS.TimNhanVienTheoMa(user, macongty); //if (usertao != null && usertao.IDCapDuyet > 12) //{ //} //else //{ // if (ngonngu == "lbl_VN") // { // lbthongbao.Text = "Người dùng này không thuộc bộ phận " + bp; // } // else if (ngonngu == "lbl_TW") // { // lbthongbao.Text = "该用户不属于部门 " + bp; // } // else if (ngonngu == "lbl_EN") // { // lbthongbao.Text = "The user does not belong to the department" + bp; // } //} } else { pdna phieun = new pdna(); { phieun.GSBH = macongty; phieun.pdno = maphieu; phieun.pddepid = bophan; phieun.mytitle = tieude; phieun.pdmemovn = noidung; phieun.CFMDate0 = DateTime.Parse(ngaythang); phieun.USERID = user; phieun.Abtype = DropLoaiPhieu.SelectedValue.ToString(); phieun.bixoa = false; phieun.CFMID0 = user; phieun.YN = 5; phieun.bixoa = false; phieun.USERDATE = DateTime.Parse(ngaythang); phieun.UseIntent = txtMucDich.Text; } db.pdnas.InsertOnSubmit(phieun); db.SubmitChanges(); string tenhang = txtTenHang.Text; //string tenhang = dropTenHang.SelectedValue; string donvitinh = txtdonvitinh.Text; string soluong = txtSoLuong.Text; string ghichu = txtGhiChu.Text; BOfSupply hang = new BOfSupply(); hang.GSBH = macongty; hang.pdno = maphieu; hang.OfSuppliesName = tenhang; hang.BUnit = donvitinh; hang.BNumber = int.Parse(soluong); hang.BCommnent = ghichu; SuppliesDAO.ThemVatTu(hang); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'")); //GridView1.DataSource = db.ExecuteQuery<BOfSupply>("select b.IDOfSupplies,b.OfSuppliesName,b.pdno,b.GSBH,b.BUnit,b.BNumber,b.BCommnent from pdna p left join BOfSupplies b on p.pdno=b.pdno and p.GSBH=b.GSBH where b.pdno='" + maphieu + "' and b.GSBH='" + macongty + "'"); //GridView1.DataBind(); tablePMH.Visible = false; btnLuuTam.Enabled = true; btnTiepTu.Enabled = true; } } // them vat tu Session["bp"] = bophan; Session["bophan"] = bp; Session["loaiP"] = loaiP; Session["loaiphieu"] = loaiphieu; Session["maphieu"] = maphieu; Session["noidung"] = noidung; Session["ngaytao"] = ngaythang; Session["tieude"] = tieude; }
protected void Button1_Click(object sender, EventArgs e) { try { // string maloai = Session["loaiphieu"].ToString(); string phieu = Session["maphieu"].ToString(); string idnguoidich = DropDownNguoiDich.SelectedValue.ToString(); string congty = Session["congty"].ToString(); string user = Session["user"].ToString(); pdna kiemtra = pnaDAO.TimVanBanTheoMa(phieu, congty); if (kiemtra != null && kiemtra.trangthaidich == false && kiemtra.YN == 6) { //string ngonngu = Session["languege"].ToString(); //if (ngonngu == "lbl_VN") //{ // LbThongBao.Text = "Phiếu đã được gửi đến người dịch"; //} //else if (ngonngu == "lbl_TW") //{ // LbThongBao.Text = "资料已经转送翻译成中文(越文)。请巡查名单"; //} //else if (ngonngu == "lbl_EN") //{ // LbThongBao.Text = "Phiếu đã được gửi đến người dịch"; //} } else { pdna phieun = new pdna(); phieun.GSBH = congty; phieun.pdno = phieu; phieun.trangthaidich = false; db.CapNhaPhieuGuiNguoiKhacDich(phieun.pdno, phieun.GSBH, idnguoidich, phieun.trangthaidich); } // pdna layvanban = pdnaBUS.LayVanBanDaGuiDenNguoiDuyetTheoNGuoiTrinhDuyet(phieu, manguoiduyet, congty); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <pdna>("select * from pdna where pdno='" + phieu + "'and GSBH='" + congty + "' and CFMID0='" + idnguoidich + "'")); var list = db.ExecuteQuery <pdna>("select * from pdna where pdno='" + phieu + "'and GSBH='" + congty + "' and CFMID0='" + idnguoidich + "'"); if (list == null) { //LbThongBao.Text = "Lỗi không thể gửi được đến người cần dịch. Xin liên hệ bộ phận IT"; string ngonngu = Session["languege"].ToString(); if (ngonngu == "lbl_VN") { LbThongBao.Text = "Lỗi không thể gửi được đến người cần dịch. Xin liên hệ bộ phận IT"; } else if (ngonngu == "lbl_TW") { LbThongBao.Text = "Error! "; } else if (ngonngu == "lbl_EN") { LbThongBao.Text = "Error can not be sent to people who need services. Please contact the IT department"; } } else { Busers2 nhanvientao = UserDAO.TimNhanVienTheoMa(user, congty); Busers2 nhanviendich = UserBUS.TimMaNhanVienDich(idnguoidich, congty); if (nhanvientao != null && nhanviendich != null) { string ngonngu = Session["languege"].ToString(); String noidung2 = "Chào anh/chị. Tôi có 1 phiếu nhờ anh/chị dịch giúp với"; noidung2 += "- Mã văn bản: " + kiemtra.pdno + "\n"; noidung2 += "- Tiêu đề: " + kiemtra.mytitle + "\n"; noidung2 += "- Ngày tạo: " + kiemtra.CFMDate0.Value.ToShortDateString() + "\n"; noidung2 += "- Người nhờ dịch: " + nhanvientao.USERNAME + "\n"; //noidung2 += "Click on link " + "http://192.168.11.8/pdn/presentationLayer/NguoiDich/danhsachphieuchuadich.aspx"; Until.SendMailNguoiDich(nhanvientao.EMAIL, nhanviendich.EMAIL, "[Ty Hung-eOffice] Thông báo có phiếu cần dịch ", noidung2, nhanviendich.USERID, congty, ngonngu); if (ngonngu == "lbl_VN") { LbThongBao.Text = "Phiếu đã được gửi đến người dịch"; } else if (ngonngu == "lbl_TW") { LbThongBao.Text = "资料已经转送翻译成中文(越文)。请巡查名单"; } else if (ngonngu == "lbl_EN") { LbThongBao.Text = "Phiếu đã được gửi đến người dịch"; } } } Button1.Enabled = false; Button1.Attributes.CssStyle.Add("opacity", "0.5"); } catch (Exception) { throw; } }