Пример #1
0
        private void EditPXK(enuEdit enuNew_Edit)
        {
            if (bdsPXK.Position < 0 && enuNew_Edit == enuEdit.Edit)
            {
                return;
            }

            //Copy hang hien tai
            if (bdsPXK.Position >= 0)
            {
                Common.CopyDataRow(((DataRowView)bdsPXK.Current).Row, ref drCurrentPXK);
            }
            else
            {
                drCurrentPXK = dtPXK.NewRow();
            }

            frmGopPXK_Edit frmEdit = new frmGopPXK_Edit();

            frmEdit.strMa_Ct = this.strMa_Ct;
            frmEdit.Load(enuNew_Edit, drCurrentPXK);

            //Accept
            if (frmEdit.isAccept)
            {
                if (enuNew_Edit == enuEdit.New)
                {
                    if (bdsPXK.Position >= 0)
                    {
                        dtPXK.ImportRow(drCurrentPXK);
                    }
                    else
                    {
                        dtPXK.Rows.Add(drCurrentPXK);
                    }

                    bdsPXK.Position = bdsPXK.Find("Ma_PX", drCurrentPXK["Ma_PX"]);
                }
                else
                {
                    Common.CopyDataRow(drCurrentPXK, ((DataRowView)bdsPXK.Current).Row);
                }

                dtPXK.AcceptChanges();

                Hashtable ht = new Hashtable();
                ht.Add("NGAY_CT1", dteNgay_Ct1.Text);
                ht.Add("NGAY_CT2", dteNgay_Ct2.Text);
                ht.Add("MA_DVCS", Element.sysMa_DvCs);

                dtPXKDetail             = SQLExec.ExecuteReturnDt("sp_GetPhieuXuatKhoDetail", ht, CommandType.StoredProcedure);
                bdsPXKDetail.DataSource = dtPXKDetail;
                dgvPXDetail.DataSource  = bdsPXKDetail;
            }
            else
            {
                dtPXK.RejectChanges();
            }
        }
Пример #2
0
        void btnPXK_Click(object sender, EventArgs e)
        {
            DataRow[] drArrPrint = dtViewPh.Select("CHON = true");

            if (drArrPrint.Length == 0)
            {
                return;
            }


            DataRow drEditPXK = DataTool.SQLGetDataTable("OM_PXK", null, "0=1", "Ma_PX").NewRow();

            drEditPXK["NGAY_CT"] = Library.DateToStr(DateTime.Now);
            drEditPXK["MA_PX"]   = "PX001";
            drEditPXK["Active"]  = true;
            drCurrent            = ((DataRowView)bdsViewPh.Current).Row;


            string strReport_File_First = string.Empty;

            DataTable dt = new DataTable();

            DataColumn drSTT     = new DataColumn("Stt", typeof(string));
            DataColumn drMa_PX   = new DataColumn("Ma_PX", typeof(string));
            DataColumn drSo_Ct   = new DataColumn("So_Ct", typeof(string));
            DataColumn drMa_Dt   = new DataColumn("Ma_Dt", typeof(string));
            DataColumn drTen_Dt  = new DataColumn("Ten_Dt", typeof(string));
            DataColumn drTTien   = new DataColumn("TTien", typeof(double));
            DataColumn drMa_DvCs = new DataColumn("Ma_DvCs", typeof(string));

            dt.Columns.Add(drSTT);
            dt.Columns.Add(drMa_PX);
            dt.Columns.Add(drSo_Ct);
            dt.Columns.Add(drMa_Dt);
            dt.Columns.Add(drTen_Dt);
            dt.Columns.Add(drTTien);
            dt.Columns.Add(drMa_DvCs);
            if (drArrPrint.Length > 0)
            {
                for (int i = 0; i < drArrPrint.Length; i++)
                {
                    drCurrent = drArrPrint[i];

                    DataRow drtemp = dt.NewRow();
                    drtemp["Stt"]     = drCurrent["Stt"];
                    drtemp["So_Ct"]   = drCurrent["So_Ct"];
                    drtemp["Ma_Dt"]   = drCurrent["Ma_Dt"];
                    drtemp["Ten_Dt"]  = DataTool.SQLGetNameByCode("LIDOITUONG", "MA_DT", "Ten_Dt", drCurrent["Ma_Dt"].ToString());
                    drtemp["TTien"]   = drCurrent["TTien"];
                    drtemp["Ma_Dvcs"] = Element.sysMa_DvCs;


                    dt.Rows.Add(drtemp);
                }
            }

            frmGopPXK_Edit frm = new frmGopPXK_Edit();

            frm.dtStt       = this.dtSttList;
            frm.dtDetail    = dt;
            frm.strMa_Ct    = strMa_Ct_List;
            frm.strStt_List = this.strStt_List;
            frm.Load(enuEdit.New, drEditPXK);
            if (frm.isAccept)
            {
                this.FillDataNew();
            }
        }