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;
}
}
