protected void btnLuu_Click(object sender, EventArgs e) { if (lblThongBao.Text.Trim() != "") { lblThongBao.Text = ""; } string congty = DropCty.SelectedValue.ToString(); string bophan = DropDownBoPhan.SelectedValue.ToString(); string tenbophan = DropDownBoPhan.SelectedItem.ToString(); string manhanvien = txtChuQuan.Text.Trim(); if (manhanvien == "") { lblThongBao.Text = "Input Incorrect"; } else { BDepartment bs = new BDepartment(); bs.GSBH = congty; bs.ID = bophan; bs.DepName = tenbophan; bs.IdUserChuQuan = manhanvien; bs.DepartmentTypeID = int.Parse(DropDownLoaiDonVi.SelectedValue.ToString()); BDepartmentBUS.SuaBoPhan(bs); } }
protected void DropCty_SelectedIndexChanged1(object sender, EventArgs e) { string congty = DropCty.SelectedValue.ToString(); GridView1.DataSource = BDepartmentBUS.DanhSachBoPhan(congty); GridView1.DataBind(); }
private void HienThiDonViThongQua() { DropDownDonViThongQua.DataSource = BDepartmentBUS.DanhSachBoPhan(); DropDownDonViThongQua.DataValueField = "ID"; DropDownDonViThongQua.DataTextField = "DepName"; DropDownDonViThongQua.DataBind(); }
private void HienThiDropDownList() { string congty = Session["congty"].ToString(); DropBoPhan.DataSource = BDepartmentBUS.DanhSachBoPhan(congty); DropBoPhan.DataValueField = "ID"; DropBoPhan.DataTextField = "DepName"; DropBoPhan.DataBind(); }
private void HienThiDropDownList() { string congty = DropCty.SelectedValue.ToString(); DropDownBoPhan.DataSource = BDepartmentBUS.DanhSachBoPhan(congty); DropDownBoPhan.DataValueField = "ID"; DropDownBoPhan.DataTextField = "DepName"; DropDownBoPhan.DataBind(); }
private void HienThi() { string macongty = Session["congty"].ToString(); string idphieu = Session["maphieu"].ToString(); //string bophan = Session["bophan"].ToString(); string manguoidung = Session["user"].ToString(); //string tenloaiphieu = Session["loaiP"].ToString(); DateTime date = DateTime.Now; //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) { if (phieu == null) { string noidung = Session["noidung"].ToString(); string ngaytao = Session["ngaytao"].ToString(); abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; BDepartment donvi = BDepartmentBUS.TimMaDonVi(phieu.pddepid, macongty); lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; lbBoPhan.Text = donvi.DepName; lbSoPhieu.Text = idphieu; lbNoiDung.Text = noidung; //lbNgay.Text = ngaytao; string dinhdang = DateTime.Parse(date.ToShortDateString()).ToString("dd/MM/yyyy"); string ngay = dinhdang.Substring(3, 2); string thang = dinhdang.Substring(0, 2); string nam = dinhdang.Substring(6, 4); lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + ""; } else { BDepartment donvi = BDepartmentBUS.TimMaDonVi(phieu.pddepid, macongty); lbBoPhan.Text = donvi.DepName; lbSoPhieu.Text = idphieu; lbNoiDung.Text = phieu.pdmemovn; //lbNgay.Text = phieu.CFMDate0.ToString(); abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; lblNoiDungDich.Text = phieu.NoiDungDich; string dinhdang = phieu.CFMDate0.ToString(); string ngay = dinhdang.Substring(3, 2); string thang = dinhdang.Substring(0, 2); string nam = dinhdang.Substring(6, 4); lbNgay.Text = "Ngày 日 " + ngay + " Tháng 月 " + thang + " Năm 年 " + nam + ""; } } }
protected void Page_Load(object sender, EventArgs e) { DropDownNguoiDich.Enabled = false; // string ngaythang = DateTime.Parse(phieu.CFMDate0.ToString("dd/MM/yyyy")); if (!IsPostBack) { 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(32, strNgonngu); } else { Response.Redirect("http://portal.footgear.com.vn"); } btnLuu.Attributes.Add("opacity", "0.3"); btnLuu.Enabled = false; GanNgonNguVaoConTrol(); string maphieu = Session["maphieu"].ToString(); string macongty = Session["congty"].ToString(); string manguoidung = Session["user"].ToString(); DataTable dt = dal.TimPhieuTheoMaNguoiTao(maphieu, macongty, manguoidung); if (dt.Rows.Count > 0) { string madonvi = dt.Rows[0]["pddepid"].ToString(); string maloaiphieu = dt.Rows[0]["Abtype"].ToString(); BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, macongty); abill loaiphieu = abillBUS.SearchAbillByID(maloaiphieu); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; txtTieuDe.Text = dt.Rows[0]["mytitle"].ToString(); lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; lbBoPhan.Text = bophan.DepName; lbSoPhieu.Text = dt.Rows[0]["pdno"].ToString(); string dinhdang = dt.Rows[0]["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 + ""; //lbNgay.Text = ; CKEditorControl1.Text = dt.Rows[0]["pdmemovn"].ToString(); } DropDownNguoiDich.Enabled = false; CKEditorControl1.Enabled = false; HienThiNguoiDich(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { 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(3, strNgonngu); } else { Response.Redirect("http://portal.footgear.com.vn"); } GanNgonNguVaoConTrol(); string maphieu = Session["maphieu"].ToString(); string macongty = Session["congty"].ToString(); string manguoidung = Session["user"].ToString(); List <pdna> list = db.pdnas.ToList(); if (list.Count() > 0) { //pdna phieu = pnaDAO.LayVanBanChuaDichTheoNguoiTrinhKy(maphieu, macongty, manguoidung); DataTable dt = dal.TimPhieuGuiNguoiDich(maphieu, macongty, manguoidung); if (dt.Rows.Count > 0) { string madonvi = dt.Rows[0]["pddepid"].ToString(); string abtype = dt.Rows[0]["Abtype"].ToString(); string noidung = dt.Rows[0]["pdmemovn"].ToString(); string ngayt = dt.Rows[0]["CFMDate0"].ToString(); BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, macongty); abill loaiphieu = abillBUS.SearchAbillByID(abtype); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; lbBoPhan.Text = bophan.DepName; //lbNgay.Text = ; lblNoiDung.Text = noidung; lbSoPhieu.Text = maphieu; string dinhdang = ngayt; 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 + ""; } } } // string ngaythang = DateTime.Parse(phieu.CFMDate0.ToString("dd/MM/yyyy")); }
private void HienThi() { string idphieu = Session["maphieu"].ToString(); //string bophan = Session["bophan"].ToString(); //string noidung = Session["noidung"].ToString(); //string ngaytao = Session["ngaythang"].ToString(); string user = Session["user"].ToString(); string congty = Session["congty"].ToString(); DataTable dt = dalP.TimPhieuTheoMaNguoiTao(idphieu, congty, user); if (dt.Rows.Count > 0) { string madonvi = dt.Rows[0]["pddepid"].ToString(); string maloaiphieu = dt.Rows[0]["Abtype"].ToString(); int Abc = int.Parse(dt.Rows[0]["ABC"].ToString()); BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, congty); abill loaiphieu = abillBUS.SearchAbillByID(maloaiphieu); aABC douutien = ABCDAO.TimDoUuTien(Abc); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; if (douutien != null) { lblDoUutien.Text = douutien.NameABC + "-" + douutien.NameABCTW; } lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; lblTieuDe.Text = dt.Rows[0]["mytitle"].ToString() + " " + dt.Rows[0]["pdnsubject"].ToString(); lbBoPhan.Text = bophan.DepName; lbSoPhieu.Text = idphieu; lbNoiDung.Text = dt.Rows[0]["pdmemovn"].ToString(); LbNoiDungDich.Text = dt.Rows[0]["NoiDungDich"].ToString(); //lbNgay.Text = phieu.CFMDate0.ToString(); string dinhdang = dt.Rows[0]["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 + ""; } Busers2 user0 = AbconBUS.LayMaNguoiTaoTheoIDVanBan(idphieu, congty); if (user0 != null) { TextBox1.Text = user0.USERID; //ImageLevel0.ImageUrl = users.signatue; ImageLevel0.Width = 100; ImageLevel0.Height = 100; ImageLevel0.ImageUrl = "~/MyPhoto.ashx?USERID=" + TextBox1.Text; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { 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(3, strNgonngu); } else { Response.Redirect("http://portal.footgear.com.vn"); } GanNgonNguVaoConTrol(); string maphieu = Session["maphieu"].ToString(); string macongty = Session["congty"].ToString(); string manguoidung = Session["user"].ToString(); DataTable dt = dal.TimPhieuTheoMaNguoiTao(maphieu, macongty, manguoidung); if (dt.Rows.Count > 0) { string ngaythang = dt.Rows[0]["CFMDate0"].ToString(); string madonvi = dt.Rows[0]["pddepid"].ToString().Trim(); string maloaiphieu = dt.Rows[0]["Abtype"].ToString().Trim(); string noidung = dt.Rows[0]["pdmemovn"].ToString().Trim(); string tieude = dt.Rows[0]["mytitle"].ToString().Trim(); string tieudedich = dt.Rows[0]["pdnsubject"].ToString().Trim(); string noidungdich = dt.Rows[0]["NoiDungDich"].ToString(); int Yn = int.Parse(dt.Rows[0]["Yn"].ToString()); BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, macongty); abill loaiphieu = abillBUS.SearchAbillByID(maloaiphieu); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; lbBoPhan.Text = bophan.DepName; //lbNgay.Text = ; lblNoiDung.Text = noidung; lbSoPhieu.Text = maphieu; string dinhdang = ngaythang; 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 + ""; } } }
private void HienThi() { string macongty = Session["congty"].ToString(); string idphieu = Session["maphieu"].ToString(); //string bophan = Session["bophan"].ToString(); string manguoidung = Session["user"].ToString(); DataTable dt = dap.TimPhieuTheoMaNguoiTao(idphieu, macongty, manguoidung); if (dt.Rows.Count > 0) { string ngaythang = dt.Rows[0]["CFMDate0"].ToString(); string madonvi = dt.Rows[0]["pddepid"].ToString().Trim(); string maloaiphieu = dt.Rows[0]["Abtype"].ToString().Trim(); string noidung = dt.Rows[0]["pdmemovn"].ToString().Trim(); string tieude = dt.Rows[0]["mytitle"].ToString().Trim(); string tieudedich = dt.Rows[0]["pdnsubject"].ToString().Trim(); string noidungdich = dt.Rows[0]["NoiDungDich"].ToString(); int Yn = int.Parse(dt.Rows[0]["Yn"].ToString()); abill loaiphieu = abillBUS.SearchAbillByID(maloaiphieu); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, macongty); Session["bp"] = bophan.ID; Session["bophan"] = bophan.DepName; lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; lbBoPhan.Text = bophan.DepName; lbSoPhieu.Text = idphieu; lbNoiDung.Text = noidung; //lbNgay.Text = phieu.CFMDate0.ToString(); lblTieuDe.Text = tieude; string dinhdang = ngaythang; 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 + ""; if (Yn != 6) { btnEdit.Enabled = true; btnNhoNguoi.Enabled = true; btnEdit.Attributes.Add("opacity", "100"); btnNhoNguoi.Attributes.Add("opacity", "100"); } else { btnEdit.Enabled = false; btnNhoNguoi.Enabled = false; btnEdit.Attributes.Add("opacity", "0.3"); btnNhoNguoi.Attributes.Add("opacity", "0.3"); } } }
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 + ""; } } }
private void HienThi() { string maphieu = Session["maphieu"].ToString(); string macongty = Session["congty"].ToString(); string manguoidung = Session["user"].ToString(); // pdna phieu = pnaDAO.LayVanBanTheoNguoiTrinh(maphieu, macongty,manguoidung); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <pdna>("select * from pdna where pdno='" + maphieu + "'and GSBH='" + macongty + "' and CFMID0='" + manguoidung + "'")); var list = db.ExecuteQuery <pdna>("select * from pdna where pdno='" + maphieu + "'and GSBH='" + macongty + "' and CFMID0='" + manguoidung + "'"); foreach (pdna phieu in list) { Session["loaiphieu"] = phieu.Abtype; Session["bp"] = phieu.pddepid; Session["noidung"] = phieu.pdmemovn; Session["noidungdich"] = phieu.NoiDungDich; Session["tieude"] = phieu.mytitle; if (phieu == null) { return; } else { if (phieu.trangthaidich == true) { 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; // lbNgay.Text =ngaytao ; lbNoiDung.Text = phieu.pdmemovn; lbSoPhieu.Text = phieu.pdno; LbNoiDungDich.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 + ""; } } } }
private void HienThi() { string idphieu = Session["maphieu"].ToString(); //string bophan = Session["bophan"].ToString(); //string noidung = Session["noidung"].ToString(); //string ngaytao = Session["ngaythang"].ToString(); string user = Session["user"].ToString(); string bp = Session["bp"].ToString(); string congty = Session["congty"].ToString(); BDepartment bophan = BDepartmentBUS.TimMaDonVi(bp, congty); //string loaiphieu = Session["loaiphieu"].ToString(); pdna phieu = pdnaBUS.TimVanBanTheoMa(idphieu, congty, true); abill loaiphieu = abillBUS.SearchAbillByID(phieu.Abtype); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; // lbBoPhan.Text = bophan; // lbNoiDung.Text = phieu.pdmemovn.ToString(); // lbNgay.Text =Convert.ToString(phieu.CFMDate0); // Buser users = UserBUS.TimMaNhanVienTheoBoPhan(user, bp); lblTieuDe.Text = phieu.mytitle + phieu.pdnsubject; lbldonvidenghi.Text = bophan.DepName; lbSoPhieu.Text = idphieu; lblMucDichSuDung.Text = phieu.UseIntent; //lbNgay.Text = phieu.CFMDate0.ToString(); 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 + ""; Busers2 user0 = AbconBUS.LayMaNguoiTaoTheoIDVanBan(idphieu, congty); if (user0 != null) { TextBox1.Text = user0.USERID; //ImageLevel0.ImageUrl = users.signatue; ImageLevel0.Width = 100; ImageLevel0.Height = 100; ImageLevel0.ImageUrl = "~/MyPhoto.ashx?USERID=" + TextBox1.Text; } }
private void HienThi() { string idphieu = Session["maphieu"].ToString(); string user = Session["user"].ToString(); //string bp = Session["bp"].ToString(); string congty = Session["congty"].ToString(); //pdna phieu = pdnaBUS.TimVanBanTheoMa(idphieu, congty, true); DataTable dt = dalPDN.TimPhieuTheoMaPhieu(idphieu, congty); if (dt.Rows.Count > 0) { string madonvi = dt.Rows[0]["pddepid"].ToString(); string maloaip = dt.Rows[0]["Abtype"].ToString(); int dout = int.Parse(dt.Rows[0]["ABC"].ToString()); BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, congty); abill loaiphieu = abillBUS.SearchAbillByID(maloaip); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; lbldonvidenghi.Text = bophan.DepName; lbSoPhieu.Text = idphieu; lblMucDichSuDung.Text = dt.Rows[0]["UseIntent"].ToString(); lblTieuDe.Text = dt.Rows[0]["mytitle"].ToString() + "-" + dt.Rows[0]["pdnsubject"].ToString(); //lbNgay.Text = phieu.CFMDate0.ToString(); string dinhdang = dt.Rows[0]["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 + ""; } Busers2 user0 = AbconBUS.LayMaNguoiTaoTheoIDVanBan(idphieu, congty); if (user0 != null) { TextBox1.Text = user0.USERID; //ImageLevel0.ImageUrl = users.signatue; ImageLevel0.Width = 100; ImageLevel0.Height = 100; ImageLevel0.ImageUrl = "~/MyPhoto.ashx?USERID=" + TextBox1.Text; } }
private void HienThiDonVi() { string madonvi = (string)Session["madonvi"]; if (madonvi == "All") { DropDownLDonVi.Items.Insert(0, "All"); } else { DropDownLDonVi.DataSource = BDepartmentBUS.DanhSachBoPhan(); DropDownLDonVi.DataValueField = "ID"; DropDownLDonVi.DataTextField = "DepName"; DropDownLDonVi.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; } } }
private void HienThiBoPhan() { string congty = Session["congty"].ToString(); string user = Session["user"].ToString(); DataTable dt = dal.QryDonViTheoDieuKien(user, congty); if (dt.Rows.Count > 0) { DropDonVi.DataSource = dt; DropDonVi.DataValueField = "ID"; DropDonVi.DataTextField = "DepName"; DropDonVi.DataBind(); } else { DropDonVi.DataSource = BDepartmentBUS.DanhSachBoPhan(congty); DropDonVi.DataValueField = "ID"; DropDonVi.DataTextField = "DepName"; DropDonVi.DataBind(); } }
private void HienThiThongTin() { string maphieu = Session["maphieu"].ToString(); string macongty = Session["congty"].ToString(); string manguoidung = Session["user"].ToString(); DataTable dt = dal.TimPhieuTheoMaNguoiTao(maphieu, macongty, manguoidung); if (dt.Rows.Count > 0) { // string ngaythang = DateTime.Parse(phieu.CFMDate0.ToString("dd/MM/yyyy")); string madonvi = dt.Rows[0]["pddepid"].ToString(); string maloaiphieu = dt.Rows[0]["Abtype"].ToString(); BDepartment bophan = BDepartmentBUS.TimMaDonVi(madonvi, macongty); abill loaiphieu = abillBUS.SearchAbillByID(maloaiphieu); string tenloaiphieuVN = loaiphieu.abname; string tenloaiphieuTW = loaiphieu.abnameTW; txtTieuDe.Text = dt.Rows[0]["mytitle"].ToString(); lbLoaiPhieu.Text = tenloaiphieuVN + " " + tenloaiphieuTW; //lbNgay.Text = ; //CKEditorControl1.Text = phieu.pdmemovn; lbBoPhan.Text = bophan.DepName; lbSoPhieu.Text = dt.Rows[0]["pdno"].ToString(); string dinhdang = dt.Rows[0]["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 = dt.Rows[0]["pdmemovn"].ToString(); DropDownNguoiDich.Enabled = false; HienThiNguoiDich(); btnLuu.Enabled = false; btnLuu.Attributes.CssStyle.Add("opacity", "0.3"); } CKEditorControl1.Enabled = false; }
protected void Button1_Click(object sender, EventArgs e) { string ngonngu = Session["languege"].ToString(); string dem = (pdnaBUS.DemSoLuongVanBan() + 1).ToString(); string maphieu = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("yyyyMMdd") + dem; 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(); if (loaiphieu != "PDN2") { 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; } else if (ngonngu == "lbl_TW") { lbthongbao.Text = "该用户不属于部门 " + bd.DepName; } else if (ngonngu == "lbl_EN") { lbthongbao.Text = "The user does not belong to the department" + bd.DepName; } } else { pdna phieun = new pdna(); { phieun.pdno = maphieu; phieun.GSBH = macongty; phieun.pdno = maphieu; phieun.Abtype = loaiphieu; phieun.pddepid = bophan; phieun.mytitle = tieude; phieun.pdmemovn = noidung; phieun.CFMDate0 = DateTime.Parse(ngaythang); phieun.CFMID0 = user; phieun.USERID = user; phieun.dagui = false; phieun.bixoa = false; } db.pdnas.InsertOnSubmit(phieun); db.SubmitChanges(); Session["bp"] = bophan; Session["bophan"] = bp; Session["loaiP"] = loaiP; Session["loaiphieu"] = loaiphieu; Session["maphieu"] = maphieu; Session["noidung"] = noidung; Session["ngaytao"] = ngaythang; Session["tieude"] = tieude; Response.Redirect("FrmViewCB.aspx"); } 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; } else if (ngonngu == "lbl_TW") { lbthongbao.Text = "该用户不属于部门 " + bd.DepName; } else if (ngonngu == "lbl_EN") { lbthongbao.Text = "The user does not belong to the department" + bd.DepName; } } } else { pdna phieun = new pdna(); { phieun.pdno = maphieu; phieun.GSBH = macongty; phieun.pdno = maphieu; phieun.Abtype = loaiphieu; phieun.pddepid = bophan; phieun.mytitle = tieude; phieun.pdmemovn = noidung; phieun.CFMDate0 = DateTime.Parse(ngaythang); phieun.CFMID0 = user; phieun.USERID = user; phieun.dagui = false; phieun.bixoa = false; } db.pdnas.InsertOnSubmit(phieun); db.SubmitChanges(); Session["bp"] = bophan; Session["bophan"] = bp; Session["loaiP"] = loaiP; Session["loaiphieu"] = loaiphieu; Session["maphieu"] = maphieu; Session["noidung"] = noidung; Session["ngaytao"] = ngaythang; Session["tieude"] = tieude; Response.Redirect("FrmViewCB.aspx"); } } 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; } else if (ngonngu == "lbl_TW") { lbthongbao.Text = "该用户不属于部门 " + bd.DepName; } else if (ngonngu == "lbl_EN") { lbthongbao.Text = "The user does not belong to the department" + bd.DepName; } } else { pdna phieun = new pdna(); { phieun.pdno = maphieu; phieun.GSBH = macongty; phieun.pdno = maphieu; phieun.Abtype = loaiphieu; phieun.pddepid = bophan; phieun.mytitle = tieude; phieun.pdmemovn = noidung; phieun.CFMDate0 = DateTime.Parse(ngaythang); phieun.CFMID0 = user; phieun.USERID = user; phieun.dagui = false; phieun.bixoa = false; } db.pdnas.InsertOnSubmit(phieun); db.SubmitChanges(); Session["bp"] = bophan; Session["bophan"] = bp; Session["loaiP"] = loaiP; Session["loaiphieu"] = loaiphieu; Session["maphieu"] = maphieu; Session["noidung"] = noidung; Session["ngaytao"] = ngaythang; Session["tieude"] = tieude; Response.Redirect("FrmViewCB.aspx"); } 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.pdno = maphieu; phieun.GSBH = macongty; phieun.pdno = maphieu; phieun.Abtype = loaiphieu; phieun.pddepid = bophan; phieun.mytitle = tieude; phieun.pdmemovn = noidung; phieun.CFMDate0 = DateTime.Parse(ngaythang); phieun.CFMID0 = user; phieun.USERID = user; phieun.dagui = false; phieun.bixoa = false; phieun.YN = 6; } db.pdnas.InsertOnSubmit(phieun); db.SubmitChanges(); Session["bp"] = bophan; Session["bophan"] = bp; Session["loaiP"] = loaiP; Session["loaiphieu"] = loaiphieu; Session["maphieu"] = maphieu; Session["noidung"] = noidung; Session["ngaytao"] = ngaythang; Session["tieude"] = tieude; Response.Redirect("FrmViewCB.aspx"); } } } else { Response.Redirect("FrmViewCB.aspx"); } }
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; }