public static bool ThemChiTietMuaHang(pdna1 chitiet)
 {
     try
     {
         db.pdna1s.InsertOnSubmit(chitiet);
         db.SubmitChanges();
         return(true);
     }
     catch (Exception)
     {
         throw;
     }
 }
 public static bool XoaPhieuMuaHang(string pdno, string gsbh, string CLBH, string size)
 {
     try
     {
         pdna1 phieu = db.pdna1s.Where(p => p.GSBH == gsbh && p.pdNO == pdno && p.CLBH == CLBH && p.Size == size).SingleOrDefault();
         db.pdna1s.DeleteOnSubmit(phieu);
         db.SubmitChanges();
         return(true);
     }
     catch (Exception)
     {
         throw;
     }
 }
 public static bool SuaChiTietPhieuMuaHang(pdna1 chitiet)
 {
     try
     {
         pdna1 phieu = db.pdna1s.Where(p => p.GSBH == chitiet.GSBH && p.pdNO == chitiet.pdNO).SingleOrDefault();
         phieu.GSBH   = chitiet.GSBH;
         phieu.pdNO   = chitiet.pdNO;
         phieu.CLBH   = chitiet.CLBH;
         phieu.Qty    = chitiet.Qty;
         phieu.CLmemo = chitiet.CLmemo;
         phieu.Memo0  = chitiet.Memo0;
         db.SubmitChanges();
         return(true);
     }
     catch (Exception)
     {
         throw;
     }
 }
Ejemplo n.º 4
0
        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;
        }