Example #1
0
        public void loadpnhbtl(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_phieunhaphangbantralai 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, TextEdit txtthue, string userid, string branchid, TextEdit txtms, ComboBoxEdit cbthue, ButtonEdit bthd, CheckEdit ckhd, 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")
            {
                tsbtcat.Enabled = false;
                DataTable da = new DataTable();

                F.Text = "Xem phiếu nhập hàng bán 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,TotalVATAmount  from INReInward 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();
                F.gethd(da.Rows[0][16].ToString());
                txtldn.Text      = da.Rows[0][2].ToString();
                bthd.EditValue   = da.Rows[0][16].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();
                Double Tienthue = Double.Parse(da.Rows[0][18].ToString());

                if (da.Rows[0][17].ToString() == "True")
                {
                    ckhd.Checked = true;
                    try
                    {
                        txtnhd.EditValue = DateTime.Parse(da.Rows[0][12].ToString());
                    }
                    catch { txtnhd.Text = ""; }
                    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;
                }

                da = gen.GetTable("select  Amount,InventoryItemCode,a.UnitPrice,a.UnitPriceCost,Quantity,QuantityConvert from INReInwardDetail a,InventoryItem b where a.InventoryItemID=b.InventoryItemID and RefID='" + role + "' order by SortOrder");
                for (int i = 0; i < da.Rows.Count; i++)
                {
                    for (int j = 0; j < gridView1.RowCount; j++)
                    {
                        if (gridView1.GetRowCellValue(j, "Mã hàng").ToString() == da.Rows[i][1].ToString())
                        {
                            gridView1.SetRowCellValue(j, gridView1.Columns["Thành tiền"], da.Rows[i][0].ToString());
                            gridView1.SetRowCellValue(j, gridView1.Columns["Số lượng"], da.Rows[i][4].ToString());
                            gridView1.SetRowCellValue(j, gridView1.Columns["Số lượng quy đổi"], da.Rows[i][5].ToString());
                            gridView1.SetRowCellValue(j, gridView1.Columns["Đơn giá"], da.Rows[i][2].ToString());
                            gridView1.SetRowCellValue(j, gridView1.Columns["Đơn giá phí"], da.Rows[i][3].ToString());
                        }
                    }
                }

                txtcth.Text  = gridView1.Columns["Thành tiền"].SummaryText;
                txtthue.Text = String.Format("{0:n0}", Tienthue);
                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;
                    }
                    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();
                }
            }
        }