public void HienThiDanhSachMuaHang() { dalPDN dal = new dalPDN(); string macongty = Session["congty"].ToString(); string idphieu = Session["maphieu"].ToString(); DataTable dt = dal.QryHangTheoMaHang(idphieu, macongty); if (dt.Rows.Count > 0) { if (dt.Rows.Count < 6) { DataRow dr = dt.NewRow(); DataRow dr1 = dt.NewRow(); DataRow dr2 = dt.NewRow(); DataRow dr3 = dt.NewRow(); DataRow dr4 = dt.NewRow(); DataRow dr5 = dt.NewRow(); DataRow dr6 = dt.NewRow(); dt.Rows.Add(dr); dt.Rows.Add(dr1); dt.Rows.Add(dr2); dt.Rows.Add(dr3); dt.Rows.Add(dr4); dt.Rows.Add(dr5); dt.Rows.Add(dr6); GridView1.DataSource = dt; GridView1.DataBind(); } else { GridView1.DataSource = dt; GridView1.DataBind(); } } }
public void HienThiDanhSachMuaHang() { string macongty = Session["congty"].ToString(); string idphieu = Session["maphieu"].ToString(); dalPDN dal = new dalPDN(); DataTable dt = dal.QryHangTheoMaHang(idphieu, macongty); DataRow drw = dt.NewRow(); DataRow drw1 = dt.NewRow(); DataRow drw2 = dt.NewRow(); DataRow drw3 = dt.NewRow(); DataRow drw4 = dt.NewRow(); DataRow drw5 = dt.NewRow(); if (dt.Rows.Count != 0 && dt.Rows.Count < 6) { dt.Rows.Add(drw); dt.Rows.Add(drw1); dt.Rows.Add(drw2); dt.Rows.Add(drw3); dt.Rows.Add(drw4); dt.Rows.Add(drw5); GridView1.DataSource = dt; GridView1.DataBind(); } else { GridView1.DataSource = dt; GridView1.DataBind(); } }
protected void Button1_Click1(object sender, EventArgs e) { dalPDN dal = new dalPDN(); string maphieu = Session["maphieu"].ToString(); string macongty = Session["congty"].ToString(); string themhang = (string)Session["themhang"]; string mahangd = (string)Session["mahangd"]; string sizeD = (string)Session["sizeD"]; string donvitinhD = (string)Session["donvitinhD"]; string SoLuongD = (string)Session["SoLuongD"]; string tenhang1 = txtAutoComplete.Text; string tenhang2 = (string)Session["tenhang"]; string ghichu = txtGhiChu.Text; string tenhang = tenhang2 + tenhang1; if (themhang != null) { dal.CapNhatPhieuMuaHangDich(macongty, mahangd, maphieu, sizeD, tenhang, ghichu); // HienThiPhieuMuaHang(); HienThiDanhSach(); btncomplete.Enabled = true; btncomplete.Attributes.CssStyle.Add("opacity", "100"); } txtAutoComplete.Text = ""; txtGhiChu.Text = ""; Session.Remove("themhang"); Session.Remove("mahangd"); Session.Remove("sizeD"); Session.Remove("donvitinhD"); Session.Remove("tenhang"); Session.Remove("SoLuongD"); }
public void HienThiDanhSachHang() { dalPDN dal = new dalPDN(); string maphieu = Session["maphieu"].ToString(); string macongty = Session["congty"].ToString(); string ktmaphieu = (string)Session["ktmaphieu"]; if (ktmaphieu == null) { DataTable dt = dal.QryHangTheoMaHang(maphieu, macongty); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); } } else { DataTable dt = dal.QryHangTheoMaHang(ktmaphieu, macongty); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); } } }
private void HienThiDanhSach() { dalPDN dal = new dalPDN(); string macongty = Session["congty"].ToString(); string manguoidung = Session["user"].ToString(); string ngonngu = Session["languege"].ToString(); DateTime pTuNgay = DateTime.Parse(txtFromDate.Text.Trim()); DateTime pDenNgay = DateTime.Parse(txtToDate.Text.Trim()); if (ngonngu == "lbl_VN") { DataTable dt = dal.QryPhieuTrongKhoTheoNguoiTao(macongty, manguoidung, pTuNgay, pDenNgay); if (dt.Rows.Count != 0) { divgrid1.Visible = true; divgrid2.Visible = false; GridView1.DataSource = dt; GridView1.DataBind(); } else { divgrid1.Visible = false; divgrid2.Visible = false; } } else if (ngonngu == "lbl_TW") { DataTable dt = dal.QryPhieuTrongKhoTheoNguoiTaoTW(macongty, manguoidung, pTuNgay, pDenNgay); if (dt.Rows.Count != 0) { divgrid2.Visible = true; divgrid1.Visible = false; GridView2.DataSource = dt; GridView2.DataBind(); } else { divgrid1.Visible = false; divgrid2.Visible = false; } } else if (ngonngu == "lbl_EN") { DataTable dt = dal.QryPhieuTrongKhoTheoNguoiTao(macongty, manguoidung, pTuNgay, pDenNgay); if (dt.Rows.Count != 0) { divgrid1.Visible = true; divgrid2.Visible = false; GridView1.DataSource = dt; GridView1.DataBind(); } else { divgrid2.Visible = false; divgrid1.Visible = false; } } }
public void HienThiDanhSach() { string macongty = Session["congty"].ToString(); string idphieu = Session["maphieu"].ToString(); dalPDN dal = new dalPDN(); DataTable dt = dal.QryHangTheoMaHang(idphieu, macongty); GridView1.DataSource = dt; GridView1.DataBind(); }
protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e) { dalPDN dal = new dalPDN(); Label lblMaPhieu = (Label)GridView2.Rows[e.RowIndex].FindControl("lblSoPhieu"); string maCongTy = Session["congty"].ToString(); DataTable dt = dal.LayTrangThaiTheoBangPDNA(maCongTy, lblMaPhieu.Text.Trim()); if (dt.Rows.Count > 0) { LblTrangThai1.Text = dt.Rows[0]["YnName"].ToString(); } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { Label lblMaCty1 = (Label)GridView1.Rows[e.RowIndex].FindControl("lblGSBH"); Label lbMaPhieu = (Label)GridView1.Rows[e.RowIndex].FindControl("lblPDNO"); Label lbMaHang = (Label)GridView1.Rows[e.RowIndex].FindControl("lblCLBH"); Label lbSize = (Label)GridView1.Rows[e.RowIndex].FindControl("lblSize"); dalPDN dal = new dalPDN(); dal.XoaHang(lblMaCty1.Text, lbMaHang.Text, lbMaPhieu.Text, lbSize.Text); HienThiDanhSach(); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { dalPDN dal = new dalPDN(); string UserID = Session["user"].ToString(); string GSBH = Session["congty"].ToString(); Label lblMaPhieu = (Label)GridView1.Rows[e.RowIndex].FindControl("lblpdno"); DataTable dt = dal.LayTrangThaiCuaPhieuTheoNguoiDuyet(GSBH, lblMaPhieu.Text.Trim(), UserID); if (dt.Rows.Count != 0) { lblTrangThai1.Text = dt.Rows[0]["YnName"].ToString(); } }
private void HienThiDanhSachPhieuChuaDich() { string macongty = Session["congty"].ToString(); string manguoidung = Session["user"].ToString(); dalPDN dal = new dalPDN(); DataTable dt = dal.QryPhieuChoDichTheoNguoiDich(macongty, manguoidung); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); } }
protected void btnLuu_Click(object sender, EventArgs e) { string maphieu = Session["maphieu"].ToString(); string macongty = Session["congty"].ToString(); string ngonngu = Session["languege"].ToString(); string manguoidung = Session["user"].ToString(); DateTime date = DateTime.Now; // string ngaydich = DateTime.Parse(date.ToShortDateString()).ToString("dd/MM/yyyy"); pdna phieu = pnaDAO.LayVanBanChuaDichTheoNguoiDich(maphieu, macongty, manguoidung); pdna phieudich = new pdna(); phieudich.pdno = maphieu; phieudich.CFMDate2 = date; phieudich.GSBH = macongty; phieudich.NoiDungDich = CKEditorControl1.Text; phieudich.trangthaidich = true; phieudich.IdnguoiDich = manguoidung; //db.CapNhatPhieuDich(phieudich.pdno, phieudich.GSBH, phieudich.NoiDungDich, phieudich.CFMDate2,txtTieuDe.Text, phieudich.IdnguoiDich, phieudich.trangthaidich); dalPDN dal = new dalPDN(); dal.CapNhatPhieuDich(manguoidung, macongty, maphieu, txtTieuDe.Text, CKEditorControl1.Text, date); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.ExecuteQuery <pdna>("select * from pdna where pdno='" + phieudich.pdno + "'and GSBH='" + macongty + "' and IdnguoiDich='" + manguoidung + "'")); var list = db.ExecuteQuery <pdna>("select * from pdna where pdno='" + phieudich.pdno + "'and GSBH='" + macongty + "' and IdnguoiDich='" + manguoidung + "'"); foreach (pdna phieu1 in list) //pdna phieu1 = pnaDAO.LayVanBanDaDichTheoNguoiDich(maphieu, macongty, manguoidung); { if (phieu1.trangthaidich == true) { if (ngonngu == "lbl_VN") { lbThongBao.Text = "Lưu thành công, văn bản đã dịch sẽ gửi đến người nhờ dịch"; } else if (ngonngu == "lbl_TW") { lbThongBao.Text = "存档成功,资料已经翻译完成请确认"; } else if (ngonngu == "lbl_EN") { lbThongBao.Text = "Save Success."; } btnLuu.Enabled = false; Response.Redirect("frmChiTietDichND.aspx"); } } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { dalPDN dal = new dalPDN(); string maphieu = Session["maphieu"].ToString(); string congty = Session["congty"].ToString(); Label lblMaCty = (Label)GridView1.Rows[e.RowIndex].FindControl("lblGSBH"); Label lblMaPhieu = (Label)GridView1.Rows[e.RowIndex].FindControl("lblPDNO"); Label lblMaHang = (Label)GridView1.Rows[e.RowIndex].FindControl("lblCLBH"); Label lblSize = (Label)GridView1.Rows[e.RowIndex].FindControl("lblSize"); dal.XoaHang(lblMaCty.Text.Trim(), lblMaHang.Text.Trim(), lblMaPhieu.Text.Trim(), lblSize.Text.Trim()); HienThiDanhSachHang(); }
private void HienThiDanhSach() { dalPDN dal = new dalPDN(); string macongty = Session["congty"].ToString(); string manguoidung = Session["user"].ToString(); DateTime fromdate = DateTime.Parse(txtFromDate.Text.Trim()); DateTime toDate = DateTime.Parse(txtToDate.Text.Trim()); DataTable dt = dal.QryPhieuTrongKhoTheoNguoiDich(macongty, manguoidung, fromdate, toDate); if (dt.Rows.Count > 0) { GridView2.DataSource = dt; GridView2.DataBind(); } }
protected void btncomplete_Click(object sender, EventArgs e) { DateTime date = DateTime.Now; //string ngaydich = DateTime.Parse(date.ToShortDateString()).ToString("dd/MM/yyyy"); string maphieu = lblsophieu.Text; string macongty = Session["congty"].ToString(); string ngonngu = Session["languege"].ToString(); string manguoidung = Session["user"].ToString(); string mucdichdudung = txtDichMucDich.Text; //db.CapNhatPhieuMuaHangDich(maphieu, macongty,txtTieuDe.Text, DateTime.Parse(ngaydich), manguoidung,mucdichdudung, trangthaidich); dalPDN dal = new dalPDN(); dal.CapNhatPhieuMHDich(manguoidung, macongty, maphieu, mucdichdudung, txtTieuDe.Text, date); Response.Redirect("danhsachphieuchuadichND.aspx"); }
protected void btnPrintPMH_Click(object sender, EventArgs e) { if (dropNhaCC.SelectedValue != "0") { dalPDN dal = new dalPDN(); string ZSBH = dropNhaCC.SelectedValue.ToString(); string maphieu = Session["maphieu"].ToString(); string macongty = Session["congty"].ToString(); DataTable dt = dal.TimMaDonDatHangTheoNhaCungUngVaSoPhieuNoSize(macongty, maphieu, ZSBH); if (dt.Rows.Count != 0) { string CGNO = dt.Rows[0]["CGNO"].ToString(); //Response.Write("<script>window.open('WF_ViewReport.aspx?Type=PhieuDatMuaHang' ,'_blank')</script>"); // Response.Write("<script>window.open('ReportPhieuMuaHang.aspx?Type=PhieuDatMuaHangNoSize&maphieu=" + maphieu + "&CGNO=" + CGNO + "&macongty=" + macongty + "&ZSBH=" + ZSBH + "')"); // Response.Redirect("ReportPhieuMuaHang.aspx?Type=PhieuDatMuaHangNoSize&maphieu=" + maphieu + "&CGNO=" + CGNO + "&macongty=" + macongty + "&ZSBH=" + ZSBH); if (dropTypePrint.SelectedValue == "1") { Response.Redirect("WF_ReportPDN.aspx?Type=PhieuDatMuaHangNoSize&maphieu=" + maphieu + "&CGNO=" + CGNO + "&macongty=" + macongty + "&ZSBH=" + ZSBH); } else { Response.Redirect("WF_ReportPDN.aspx?Type=PhieuDatMuaHangNoSizeNoTitle&maphieu=" + maphieu + "&CGNO=" + CGNO + "&macongty=" + macongty + "&ZSBH=" + ZSBH); //Response.Redirect("ReportPhieuMuaHang.aspx?Type=PhieuDatMuaHangNoSizeNoTitle&maphieu=" + maphieu + "&CGNO=" + CGNO + "&macongty=" + macongty + "&ZSBH=" + ZSBH); } } else { DataTable dtSize = dal.TimMaDonDatHangTheoNhaCungUngVaSoPhieuSize(macongty, maphieu, ZSBH); if (dtSize.Rows.Count != 0) { string CGNO = dtSize.Rows[0]["CGNO"].ToString(); if (dropTypePrint.SelectedValue == "1") { Response.Redirect("WF_ReportPDN.aspx?Type=PhieuDatMuaHangSize&maphieu=" + maphieu + "&CGNO=" + CGNO + "&macongty=" + macongty + "&ZSBH=" + ZSBH); } else { Response.Redirect("WF_ReportPDN.aspx?Type=PhieuDatMuaHangSizeNoTitle&maphieu=" + maphieu + "&CGNO=" + CGNO + "&macongty=" + macongty + "&ZSBH=" + ZSBH); } } } } }
protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e) { dalPDN dal = new dalPDN(); Label lblMaPhieu = (Label)GridView2.Rows[e.RowIndex].FindControl("lblpdno"); string UserID = Session["UserID"].ToString(); string GSBH = Session["congty"].ToString(); DataTable dt = dal.LayTrangThaiDuyetTheoBangTrangThai(GSBH, lblMaPhieu.Text.Trim()); if (dt.Rows.Count != 0) { lblTrangThai.Text = dt.Rows[0]["YnName"].ToString(); } else { DataTable dtt = dal.LayTrangThaiTheoBangPDNA(GSBH, lblMaPhieu.Text.Trim()); if (dtt.Rows.Count != 0) { lblTrangThai.Text = dtt.Rows[0]["YnName"].ToString(); } } }
private void HienThiDanhSach() { dalPDN dal = new dalPDN(); string macongty = Session["congty"].ToString(); string manguoidung = Session["user"].ToString(); string ngonngu = Session["languege"].ToString(); DateTime fromDate = DateTime.Parse(txtFromDate.Text.Trim()); DateTime ToDate = DateTime.Parse(txtToDate.Text.Trim()); if (ngonngu == "lbl_VN") { DataTable dt = dal.QryPhieuTrongKhoTheoNguoiTao(macongty, manguoidung, fromDate, ToDate); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); } } else if (ngonngu == "lbl_TW") { DataTable dt = dal.QryPhieuTrongKhoTheoNguoiTaoTW(macongty, manguoidung, fromDate, ToDate); if (dt.Rows.Count > 0) { GridView2.DataSource = dt; GridView2.DataBind(); } } else if (ngonngu == "lbl_EN") { DataTable dt = dal.QryPhieuTrongKhoTheoNguoiTaoTW(macongty, manguoidung, fromDate, ToDate); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); } } }
protected void btnLuuTam_Click(object sender, EventArgs e) { string ngonngu = Session["languege"].ToString(); string loaiphieup = DropLoaiPhieu.SelectedValue.ToString(); if (loaiphieup != "PDN2") { DateTime date = DateTime.Today; dalPDN dal = new dalPDN(); DataTable dt = dal.DemSoLuongPhieu(); string aa = dt.Rows[0]["pdno"].ToString().Trim(); string maphieu = ""; if (dt.Rows.Count != 0 && aa != "") { string dem = (int.Parse(dt.Rows[0]["pdno"].ToString()) + 1).ToString(); maphieu = dem; } else { maphieu = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("yyyyMM") + "00" + 1; } string bophan = DropDonVi.SelectedItem.Value.ToString(); string congty = Session["congty"].ToString(); string tieude = txtTieuDe.Text; string noidung = CKEditorControl1.Text; string bp = DropDonVi.SelectedItem.Text; string loaiP = DropLoaiPhieu.SelectedItem.Text; int level = 0; int ABC = 1; string user = Session["user"].ToString(); string ngaythang = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("yyyy/MM/dd"); 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(); Session["loaiP"] = loaiP; Session["loaiphieu"] = loaiphieu; Session["maphieu"] = maphieu; Session["bp"] = bophan; Session["bophan"] = bp; Session["noidung"] = noidung; Session["ngaytao"] = ngaythang; Session["tieude"] = tieude; Busers2 us = UserBUS.TimMaNhanVienTheoBoPhan(user, bophan, congty); if (us == null) { 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 { if (loaiphieu != "PDN2") { dal.ThemPhieuDeNghi(congty, maphieu, bophan, tieude, noidung, date, user, DropLoaiPhieu.SelectedValue, user, false, 5, date, level, ABC); } Response.Redirect("DanhsachphieumoikhoitaoNV.aspx"); } } else { Response.Redirect("DanhsachphieumoikhoitaoNV.aspx"); Session.Remove("ktmaphieu"); Session.Remove("CGNO"); Session.Remove("ZSBH"); Session.Remove("themhang"); } }
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"); }
protected void btnPrintPMH_Click(object sender, EventArgs e) { if (dropNhaCC.SelectedValue != "0") { dalPDN dal = new dalPDN(); lblThongbaoReport.Text = ""; string ZSBH = dropNhaCC.SelectedValue.ToString(); string maphieu = Session["maphieu"].ToString(); string macongty = Session["congty"].ToString(); string manguoidung = Session["user"].ToString(); string DDBH = txtDDBH.Text.Trim(); DataTable dtDem = dal.DemMaDatMuaHang(); string abc = dtDem.Rows[0]["CGNO"].ToString(); Int64 NCGNO = Int64.Parse(abc) + 1; string CGNO = NCGNO.ToString(); DateTime date = DateTime.Today; DataTable dtt = dal.TimCGNOTrongBangPDNAS(macongty, maphieu, ZSBH); if (dtt.Rows.Count > 0) { string CG = dtt.Rows[0]["CGNO"].ToString(); if (CG == null) { dal.CapNhatCGNOTrongBangPDNAS(macongty, maphieu, CGNO, ZSBH); dal.ThemCGNOTrongBangCGZL(macongty, CGNO, ZSBH, manguoidung); DataTable dt = dal.TimMaDonDatHangTheoNhaCungUngVaSoPhieuNoSize(macongty, maphieu, ZSBH); if (dt.Rows.Count != 0) { if (dropTypePrint.SelectedValue == "1") { Response.Redirect("WF_ReportPDN.aspx?Type=PhieuDatMuaHangNoSize&maphieu=" + maphieu + "&CGNO=" + CGNO + "&macongty=" + macongty + "&ZSBH=" + ZSBH); } else { Response.Redirect("WF_ReportPDN.aspx?Type=PhieuDatMuaHangNoSizeNoTitle&maphieu=" + maphieu + "&CGNO=" + CGNO + "&macongty=" + macongty + "&ZSBH=" + ZSBH); //Response.Redirect("ReportPhieuMuaHang.aspx?Type=PhieuDatMuaHangNoSizeNoTitle&maphieu=" + maphieu + "&CGNO=" + CGNO + "&macongty=" + macongty + "&ZSBH=" + ZSBH); } } else { DataTable dtSize = dal.TimMaDonDatHangTheoNhaCungUngVaSoPhieuSize(macongty, maphieu, ZSBH); if (dtSize.Rows.Count != 0) { if (DDBH != "") { DataTable kiemtr = dal.KiemTraDDBHTrongBangDDZL(DDBH); if (kiemtr.Rows.Count > 0) { foreach (DataRow dr in dtSize.Rows) { dal.CapNhatDDBHTrongBangPDNAS(macongty, maphieu, DDBH, ZSBH); } //DataTable dtp = dal.TimKiemCLBHTrongBangPDNAS(maphieu, macongty, ZSBH, CGNO); //if (dtp.Rows.Count > 0) //{ // foreach (DataRow dr in dtp.Rows) // { // string CLBH = dr["CLBH"].ToString(); // decimal Qty = decimal.Parse(dr["Qty"].ToString()); // dal.ThemCGNOTrongBangCGZLS(macongty, CGNO, CLBH, manguoidung, Qty); // } //} if (dropTypePrint.SelectedValue == "1") { Response.Redirect("WF_ReportPDN.aspx?Type=PhieuDatMuaHangSize&maphieu=" + maphieu + "&CGNO=" + CGNO + "&macongty=" + macongty + "&ZSBH=" + ZSBH); } else { Response.Redirect("WF_ReportPDN.aspx?Type=PhieuDatMuaHangSizeNoTitle&maphieu=" + maphieu + "&CGNO=" + CGNO + "&macongty=" + macongty + "&ZSBH=" + ZSBH); } } else { lblThongbaoReport.Text = "DDBH Incorrect,please try again!"; } } } } }// da co CGNO else { DataTable dt = dal.TimMaDonDatHangTheoNhaCungUngVaSoPhieuNoSize(macongty, maphieu, ZSBH); if (dt.Rows.Count != 0) { if (dropTypePrint.SelectedValue == "1") { Response.Redirect("WF_ReportPDN.aspx?Type=PhieuDatMuaHangNoSize&maphieu=" + maphieu + "&CGNO=" + CG + "&macongty=" + macongty + "&ZSBH=" + ZSBH); } else { Response.Redirect("WF_ReportPDN.aspx?Type=PhieuDatMuaHangNoSizeNoTitle&maphieu=" + maphieu + "&CGNO=" + CG + "&macongty=" + macongty + "&ZSBH=" + ZSBH); //Response.Redirect("ReportPhieuMuaHang.aspx?Type=PhieuDatMuaHangNoSizeNoTitle&maphieu=" + maphieu + "&CGNO=" + CGNO + "&macongty=" + macongty + "&ZSBH=" + ZSBH); } } else { DataTable dtSize = dal.TimMaDonDatHangTheoNhaCungUngVaSoPhieuSize(macongty, maphieu, ZSBH); if (dtSize.Rows.Count != 0) { if (DDBH != "") { DataTable kiemtr = dal.KiemTraDDBHTrongBangDDZL(DDBH); if (kiemtr.Rows.Count > 0) { foreach (DataRow dr in dtSize.Rows) { dal.CapNhatDDBHTrongBangPDNAS(macongty, maphieu, DDBH, ZSBH); } //DataTable dtp = dal.TimKiemCLBHTrongBangPDNAS(maphieu, macongty, ZSBH, CGNO); //if (dtp.Rows.Count > 0) //{ // foreach (DataRow dr in dtp.Rows) // { // string CLBH = dr["CLBH"].ToString(); // decimal Qty = decimal.Parse(dr["Qty"].ToString()); // dal.ThemCGNOTrongBangCGZLS(macongty, CGNO, CLBH, manguoidung, Qty); // } //} if (dropTypePrint.SelectedValue == "1") { Response.Redirect("WF_ReportPDN.aspx?Type=PhieuDatMuaHangSize&maphieu=" + maphieu + "&CGNO=" + CG + "&macongty=" + macongty + "&ZSBH=" + ZSBH); } else { Response.Redirect("WF_ReportPDN.aspx?Type=PhieuDatMuaHangSizeNoTitle&maphieu=" + maphieu + "&CGNO=" + CG + "&macongty=" + macongty + "&ZSBH=" + ZSBH); } } else { lblThongbaoReport.Text = "DDBH Incorrect,please try again!"; } } } } } } } }
protected void btnLuuTam_Click(object sender, EventArgs e) { DateTime date = DateTime.Today; dalPDN dal = new dalPDN(); DataTable dt = dal.DemSoLuongPhieu(); string aa = dt.Rows[0]["pdno"].ToString().Trim(); string maphieu = ""; 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 congty = Session["congty"].ToString(); string tieude = txtTieuDe.Text; string noidung = CKEditorControl1.Text; string noidungdich = CKEditorControl2.Text; string bp = DropDonVi.SelectedItem.Text; string loaiP = DropLoaiPhieu.SelectedItem.Text; 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 us = UserBUS.TimMaNhanVienTheoBoPhan(user, bophan, congty); if (us == null) { lbthongbao.Text = "Người dùng này không nằm trong bộ phận " + bp; } else { pdna phieun = new pdna(); { phieun.GSBH = congty; phieun.pdno = maphieu; phieun.pddepid = bophan; phieun.mytitle = tieude; phieun.pdmemovn = noidung; phieun.NoiDungDich = noidungdich; phieun.CFMDate0 = DateTime.Parse(ngaythang); phieun.USERID = user; phieun.Abtype = DropLoaiPhieu.SelectedValue; phieun.bixoa = false; phieun.trangthaidich = true; phieun.IdnguoiDich = user; phieun.CFMID0 = user; phieun.YN = 5; phieun.CFMDate1 = DateTime.Parse(ngaythang); phieun.USERDATE = DateTime.Parse(ngaythang); } pdnaBUS.InsertPDNA(phieun); Response.Redirect("frmDanhsachphieumoikhoitaoND.aspx"); } }
protected void Button1_Click1(object sender, EventArgs e) { string user = Session["user"].ToString(); string tenhang = txtAutoComplete.Text.Trim(); string donvitinh = txtdonvitinh.Text.ToUpper(); string soluong = txtSoLuong.Text.Trim(); string ghichu = txtGhiChu.Text.Trim(); string mahang = txtMaHang.Text.Trim(); string Size = ""; string congty = Session["congty"].ToString(); string maphieu = Session["maphieu"].ToString(); string themhang = (string)Session["themhang"]; string mahangcu = (string)Session["mahangcu"]; string sizecu = (string)Session["sizecu"]; DateTime date = DateTime.Today; if (txtSize.Text.Trim() == "") { Size = "ZZZZZZ"; } else { try { decimal sl = decimal.Parse(txtSize.Text.Trim()); Size = sl.ToString(); } catch { Size = "ZZZZZZ"; } } dalPDN dal = new dalPDN(); DataTable dtTim = dal.TimMaHangTrongPhieu(congty, mahang, maphieu); if (themhang == null) { if (dtTim.Rows.Count > 0) { dal.SuaHang1(congty, mahang, maphieu, Size, decimal.Parse(soluong), tenhang, ghichu); } else { dal.ThemHang1(congty, mahang, maphieu, Size, decimal.Parse(soluong), tenhang, ghichu); } HienThiDanhSach(); } else { if (mahangcu != null && mahangcu == mahang) { if (sizecu == Size) { dal.SuaHang1(congty, mahang, maphieu, Size, decimal.Parse(soluong), tenhang, ghichu); } else { dal.XoaHang(congty, mahangcu, maphieu, sizecu); dal.ThemHang1(congty, mahang, maphieu, Size, decimal.Parse(soluong), tenhang, ghichu); } HienThiDanhSach(); Session.Remove("themhang"); Session.Remove("mahangcu"); Session.Remove("sizecu"); } else { dal.XoaHang(congty, mahangcu, maphieu, sizecu); if (dtTim.Rows.Count > 0) { dal.SuaHang1(congty, mahang, maphieu, Size, decimal.Parse(soluong), tenhang, ghichu); } else { dal.ThemHang1(congty, mahang, maphieu, Size, decimal.Parse(soluong), tenhang, ghichu); } HienThiDanhSach(); Session.Remove("themhang"); Session.Remove("mahangcu"); Session.Remove("sizecu"); } } txtAutoComplete.Enabled = true; txtMaHang.Enabled = true; txtSize.Enabled = true; txtAutoComplete.Text = ""; txtdonvitinh.Text = ""; txtGhiChu.Text = ""; txtMaHang.Text = ""; txtSize.Text = ""; txtSoLuong.Text = ""; }
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_Click1(object sender, EventArgs e) { dalPDN dal = new dalPDN(); DataTable dt = dal.DemMaDatMuaHang(); }
protected void Button1_Click(object sender, EventArgs e) { string loaiphieu = DropLoaiPhieu.SelectedValue.ToString(); if (loaiphieu != "PDN2") { DateTime date = DateTime.Today; dalPDN dal = new dalPDN(); DataTable dt = dal.DemSoLuongPhieu(); string aa = dt.Rows[0]["pdno"].ToString().Trim(); string maphieu = ""; 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 congty = Session["congty"].ToString(); string user = Session["user"].ToString(); string ngaythang = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("yyyy/MM/dd"); string ngaythang1 = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("Ngày " + "dd" + "Tháng " + "MM" + "Năm" + "yyyy"); //string idphieu = Session["maphieu"].ToString(); Busers2 us = UserBUS.TimMaNhanVienTheoBoPhan(user, bophan, congty); if (us == null) { lbthongbao.Text = "Người dùng này không nằm trong bộ phận " + bp; } else { pdna phieun = new pdna(); { phieun.pdno = maphieu; phieun.GSBH = congty; phieun.pdno = maphieu; phieun.Abtype = loaiphieu; phieun.pddepid = bophan; phieun.mytitle = tieude; phieun.pdmemovn = noidung; phieun.CFMDate0 = DateTime.Today; phieun.CFMID0 = user; phieun.YN = 5; phieun.USERID = user; phieun.dagui = false; phieun.bixoa = false; phieun.LevelDoing = 0; phieun.ABC = 1; } pdnaBUS.InsertPDNA(phieun); Session["loaiP"] = loaiP; Session["loaiphieu"] = loaiphieu; Session["maphieu"] = maphieu; Session["bp"] = bophan; Session["bophan"] = bp; Session["noidung"] = noidung; Session["ngaytao"] = ngaythang; Session["tieude"] = tieude; Response.Redirect("FrmView.aspx"); } SuppliesDAO.SearchAjax(txtdonvitinh.Text); } else { Response.Redirect("FrmView.aspx"); } Session.Remove("ktmaphieu"); Session.Remove("CGNO"); Session.Remove("ZSBH"); Session.Remove("themhang"); }
protected void Button1_Click1(object sender, EventArgs e) { dalPDN dal = new dalPDN(); DateTime date = DateTime.Today; string ngonngu = Session["languege"].ToString(); string ktmaphieu = (string)Session["ktmaphieu"]; string themhang = (string)Session["themhang"]; string mahangcu = (string)Session["mahangcu"]; string sizecu = (string)Session["sizecu"]; string bophan = DropDonVi.SelectedItem.Value.ToString(); string congty = Session["congty"].ToString(); string tieude = txtTieuDe.Text; string noidung = CKEditorControl1.Text; string bp = DropDonVi.SelectedItem.Text; string loaiP = DropLoaiPhieu.SelectedItem.Text; string mucdich = txtMucDich.Text; string user = Session["user"].ToString(); string ngaythang = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("yyyy/MM/dd"); 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 us = UserBUS.TimMaNhanVienTheoBoPhan(user, bophan, congty); if (us == null) { if (ngonngu == "lbl_VN") { lbthongbao.Text = "Người dùng này không thuộc bộ phận " + bp; tablePMH.Visible = true; btnLuuTam.Enabled = false; btnTiepTu.Enabled = false; } else if (ngonngu == "lbl_TW") { lbthongbao.Text = "该用户不属于部门 " + bp; tablePMH.Visible = true; btnLuuTam.Enabled = false; btnTiepTu.Enabled = false; } else if (ngonngu == "lbl_EN") { lbthongbao.Text = "The user does not belong to the department" + bp; tablePMH.Visible = true; btnLuuTam.Enabled = false; btnTiepTu.Enabled = false; } } else { if (ktmaphieu == null) { DataTable dt = dal.DemSoLuongPhieu(); string maphieu = ""; string a = dt.Rows[0]["pdno"].ToString().Trim(); if (dt.Rows.Count != 0 && a != "") { string dem = (int.Parse(a) + 1).ToString(); maphieu = dem; } else { maphieu = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("yyyyMM") + "00" + 1; } pdna phieun = new pdna(); { phieun.GSBH = congty; phieun.pdno = maphieu; phieun.pddepid = bophan; phieun.mytitle = tieude; phieun.pdmemovn = noidung; phieun.CFMDate0 = DateTime.Today; phieun.USERID = user; phieun.Abtype = DropLoaiPhieu.SelectedValue.ToString(); phieun.bixoa = false; phieun.CFMID0 = user; phieun.YN = 5; phieun.LevelDoing = 0; phieun.USERDATE = DateTime.Today; phieun.UseIntent = mucdich; phieun.ABC = 1; } pdnaBUS.InsertPDNA(phieun); Session["ktmaphieu"] = maphieu; Session["bp"] = bophan; Session["bophan"] = bp; Session["loaiP"] = loaiP; Session["loaiphieu"] = loaiphieu; Session["maphieu"] = maphieu; Session["noidung"] = noidung; Session["ngaytao"] = ngaythang; Session["tieude"] = tieude; } else { dal.CapNhatPhieuDeNghi(congty, ktmaphieu, bophan, tieude, noidung, date, user, loaiphieu, user, mucdich, false, 5, date); Session["ktmaphieu"] = ktmaphieu; Session["bp"] = bophan; Session["bophan"] = bp; Session["loaiP"] = loaiP; Session["loaiphieu"] = loaiphieu; Session["maphieu"] = ktmaphieu; Session["noidung"] = noidung; Session["ngaytao"] = ngaythang; Session["tieude"] = tieude; } string tenhang = txtAutoComplete.Text.Trim(); string donvitinh = txtdonvitinh.Text.ToUpper(); string soluong = txtSoLuong.Text.Trim(); string ghichu = txtGhiChu.Text.Trim(); string Size = ""; string mahang = ""; if (txtSize.Text.Trim() == "") { Size = "ZZZZZZ"; } else { try { decimal sl = decimal.Parse(txtSize.Text.Trim()); Size = sl.ToString(); } catch { Size = "ZZZZZZ"; } } if (txtMaHang.Text.Trim() == "") { string a = (string)Session["demmahang"]; if (a == null && demMH == 1) { mahang = "z" + demMH; demMH++; demmahang = demMH.ToString(); Session["demmahang"] = demmahang; } else { int so = int.Parse(a); mahang = "z" + so; so++; demmahang = so.ToString(); Session["demmahang"] = demmahang; } } else { mahang = txtMaHang.Text; } string maphieu1 = Session["maphieu"].ToString(); DataTable dtTim = dal.TimMaHangTrongPhieu(congty, mahang, maphieu1); if (themhang == null) { if (ktmaphieu == null) { if (dtTim.Rows.Count > 0) { dal.SuaHang1(congty, mahang, maphieu1, Size, decimal.Parse(soluong), tenhang, ghichu); } else { dal.ThemHang1(congty, mahang, maphieu1, Size, decimal.Parse(soluong), tenhang, ghichu); } HienThiDanhSachHang(); } else { if (dtTim.Rows.Count > 0) { dal.SuaHang1(congty, mahang, ktmaphieu, Size, decimal.Parse(soluong), tenhang, ghichu); } else { dal.ThemHang1(congty, mahang, ktmaphieu, Size, decimal.Parse(soluong), tenhang, ghichu); //dal.ThemCGNOTrongBangCGZLS(congty, CGNO, mahang, user, decimal.Parse(soluong)); } HienThiDanhSachHang(); } } else { if (ktmaphieu == null) { if (mahangcu != null && mahangcu == mahang) { if (sizecu == Size) { dal.SuaHang1(congty, mahang, ktmaphieu, Size, decimal.Parse(soluong), tenhang, ghichu); } else { dal.XoaHang(congty, mahangcu, ktmaphieu, sizecu); dal.ThemHang1(congty, mahang, ktmaphieu, Size, decimal.Parse(soluong), tenhang, ghichu); } } else { dal.XoaHang(congty, mahangcu, maphieu1, sizecu); // dal.XoaCGNOTrongBangCGZLS(congty, CGNO, mahangcu); if (dtTim.Rows.Count > 0) { dal.SuaHang1(congty, mahang, maphieu1, Size, decimal.Parse(soluong), tenhang, ghichu); // dal.CapNhatCGNOTrongBangCGZLS(congty, CGNO, mahang, user, decimal.Parse(soluong), date, Yn); } else { dal.ThemHang1(congty, mahang, maphieu1, Size, decimal.Parse(soluong), tenhang, ghichu); // dal.ThemCGNOTrongBangCGZLS(congty, CGNO, mahang, user, decimal.Parse(soluong)); } HienThiDanhSachHang(); } } else { if (mahangcu != null && mahangcu == mahang) { if (sizecu == Size) { dal.SuaHang1(congty, mahang, ktmaphieu, Size, decimal.Parse(soluong), tenhang, ghichu); } else { dal.XoaHang(congty, mahangcu, ktmaphieu, sizecu); dal.ThemHang1(congty, mahang, ktmaphieu, Size, decimal.Parse(soluong), tenhang, ghichu); } } else { dal.XoaHang(congty, mahangcu, ktmaphieu, sizecu); if (dtTim.Rows.Count > 0) { dal.SuaHang1(congty, mahang, ktmaphieu, Size, decimal.Parse(soluong), tenhang, ghichu); } else { dal.ThemHang1(congty, mahang, ktmaphieu, Size, decimal.Parse(soluong), tenhang, ghichu); } HienThiDanhSachHang(); } HienThiDanhSachHang(); Session.Remove("themhang"); Session.Remove("mahangcu"); Session.Remove("sizecu"); } } txtAutoComplete.Text = ""; txtMaHang.Text = ""; txtSize.Text = ""; txtdonvitinh.Text = ""; txtAutoComplete.Enabled = true; txtdonvitinh.Enabled = true; txtSize.Enabled = true; btnLuuTam.Enabled = true; btnTiepTu.Enabled = true; } }