Beispiel #1
0
        public void loadpxhmtl(string active, string role, DevExpress.XtraGrid.GridControl gridControl1, GridView gridView1, TextEdit txtsct, LookUpEdit ledv, DateEdit denct, DateEdit denht,
                               DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit mahang, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit soluong, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit soluongqd, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit dongia, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit chiphi, DevExpress.XtraEditors.Repository.RepositoryItemTextEdit thanhtien, Frm_phieuxuathangmuatralai F, LookUpEdit ledt, TextEdit txtldn,
                               ToolStripButton tsbtsua, ToolStripButton tsbtxoa, ToolStripButton tsbtcat, ToolStripButton tsbtboghi, ToolStripButton tsbtghiso, ToolStripButton tsbtnap, ToolStripButton tsbtin, string ngaychungtu, string tsbt, TextEdit txtshd, TextEdit txtkhhd, TextEdit txtnhd, TextEdit txtcth, string userid, string branchid, TextEdit txtms, ComboBoxEdit cbthue, ToolStripSplitButton tsbttruoc, ToolStripSplitButton tsbtsau, DataTable khach, DataTable hang)
        {
            DataTable dt = new DataTable();

            loadstart(gridControl1, gridView1, ledv, denct, denht, mahang, soluong, soluongqd, dongia, chiphi, thanhtien, ledt, tsbtsua, tsbtxoa, tsbtcat, tsbtboghi, tsbtghiso, tsbtnap, tsbtin, ngaychungtu, dt, tsbt, userid, cbthue, khach, hang);
            if (active == "1")
            {
                DataTable da = new DataTable();
                da = gen.GetTable("select  Amount,InventoryItemCode,a.UnitPrice,a.UnitPriceCost,Quantity,QuantityConvert,InventoryItemName from INReOutwardDetail a,InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + role + "' order by SortOrder");
                for (int i = 0; i < da.Rows.Count; i++)
                {
                    DataRow dr = dt.NewRow();
                    dr[0] = da.Rows[i][1].ToString();
                    dr[1] = da.Rows[i][6].ToString();
                    dr[2] = da.Rows[i][4].ToString();
                    dr[3] = da.Rows[i][5].ToString();
                    dr[4] = da.Rows[i][2].ToString();
                    dr[6] = da.Rows[i][0].ToString();
                    dt.Rows.Add(dr);
                }
                gridControl1.DataSource = dt;
                tsbtcat.Enabled         = false;

                F.Text = "Xem phiếu xuất hàng mua trả lại";
                da     = gen.GetTable("select AccountingObjectCode,a.Contactname,JournalMemo,DocumentIncluded,RefDate,PostedDate,RefNo,StockCode,Posted,AccountingObjectType,Cancel,Tax,InvDate,InvSeries,InvNo,No,RefIn,CheckIn  from INReOutward a, AccountingObject b,Stock c where a.AccountingObjectID=b.AccountingObjectID and a.StockID=c.StockID and RefID='" + role + "'");

                ledv.EditValue   = da.Rows[0][7].ToString();
                ledt.EditValue   = da.Rows[0][0].ToString();
                txtldn.Text      = da.Rows[0][2].ToString();
                denct.EditValue  = DateTime.Parse(da.Rows[0][4].ToString());
                denht.EditValue  = DateTime.Parse(da.Rows[0][5].ToString());
                txtsct.EditValue = da.Rows[0][6].ToString();
                cbthue.EditValue = da.Rows[0][11].ToString();
                txtnhd.EditValue = DateTime.Parse(da.Rows[0][12].ToString());
                txtshd.Text      = da.Rows[0][14].ToString();
                txtms.Text       = da.Rows[0][15].ToString();
                txtkhhd.Text     = da.Rows[0][13].ToString();

                if (da.Rows[0][8].ToString() == "True")
                {
                    tsbtghiso.Visible = false;
                    tsbtboghi.Visible = true;
                    tsbtsua.Enabled   = false;
                }
                else
                {
                    tsbtboghi.Visible = false;
                    tsbtghiso.Visible = true;
                }
                if (da.Rows[0][10].ToString() == "True")
                {
                    tsbtboghi.Enabled = false;
                    tsbtghiso.Enabled = false;
                }

                txtcth.Text = gridView1.Columns["Thành tiền"].SummaryText;
                checktruocsau(tsbttruoc, tsbtsau, ledv.EditValue.ToString(), txtsct.Text, ngaychungtu);
            }
            else
            {
                try
                {
                    F.Text = "Thêm phiếu nhập hàng bán trả lại";
                    if (role == null)
                    {
                        ledv.ItemIndex = 0;
                    }
                    else
                    {
                        ledv.EditValue = role;
                    }
                    cbthue.SelectedIndex = 2;
                    denct.EditValue      = DateTime.Parse(ngaychungtu);
                    denht.EditValue      = DateTime.Parse(ngaychungtu);
                    txtnhd.EditValue     = DateTime.Parse(ngaychungtu);
                    txtcth.Text          = gridView1.Columns["Thành tiền"].SummaryText;
                }
                catch
                {
                    XtraMessageBox.Show("Vui lòng kiểm tra lại < Ngày chứng từ >.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    F.Close();
                }
            }
        }