{*******************************************************}
{                                                       }
{                     集郵票入庫審核                    }
{                                                       }
{            中軟金馬公司版權所有。2002.12前            }
{                                                       }
{               編制：中軟金馬項目開發組                }
{                                                       }
{                                                       }
{*******************************************************}
(*
本模塊在省級庫房管理模塊、省級集郵票、地市集郵票管理部分的 入庫審核菜單調用。
*)

{
[與零枚票對照]
  表對照
    A 零枚票發貨單         -> 集郵票品發貨單
    B 零枚出庫票品         -> 集郵出庫票品
    C 袋數重量表           -> 集郵袋數重量表
    D 包號版號表（出庫單)  -> 集郵包號版號(出庫單)
  字段對照
    B
     圖代碼 -> 票品代碼
     售價   -> 銷價
     面值   -
     原價   +
     進價   +
    D
     進價   +

有關表：
  集郵票品發貨單、集郵出庫票品、集郵袋數重量表、集郵包號版號(出庫單)
數據來源：
  出庫單計劃號：集郵票品發貨單依據單號的GROUP BY
  發貨單號：  集郵票品發貨單的發貨單號
  發貨單主信息：集郵票品發貨單
  發貨單詳細信息：集郵出庫票品
  包袋：集郵袋數重量表
  包號版本號：集郵包號版號(出庫單)
功能:
算法：
  1.輸入的庫房號必須在庫房表中存在
  2.對起始版號、終止版本號數據修改時要較驗，即不能重復
  3.當修改完成保存數據時，需要作如下操作：
    A. 裝票日期、封裝袋數、出庫日期、庫管員、備注保存到集郵票品發貨單中
       修改集郵票品發貨單的在途狀態為'1'
    B. 記錄庫存數據
      零枚票品庫存
        票品代碼：集郵出庫票品.票品代碼
        庫房代碼：集郵出庫票品.庫房號
        原價:集郵出庫票品.原價
        進價:集郵出庫票品.進價
        銷價：集郵出庫票品.銷價
        庫位號：集郵出庫票品.庫位號
        票品類別：通過票品代碼判斷(?)
        IF 出庫性質 = '待銷毀出庫' THEN
          待銷毀庫存 = 待銷毀庫存 - 集郵出庫票品.數量
        ELSE IF 出庫性質 = '預付出庫' THEN
          預付庫存 = 預付庫存 - 集郵出庫票品.數量
        ELSE 庫存總枚數 = 庫存總枚數 + 集郵出庫票品.數量
        變更標志：NULL(?)
        備注：NULL
      包號版號表（庫存）
        起始版號：包號版號表（出庫單）.起始版本號
        終止版號: 包號版號表（出庫單）.終止版本號
    C. 記帳
        集郵票總帳表
        集郵票總分戶帳表  (集郵票總分戶帳明細表)
        集郵票明細分類帳
        集郵票進發存明細帳表
        集郵票明細分類帳(庫管員)
        集郵票品庫存(庫管)
        集郵票品庫存(業務部)
更新有關表：
  集郵票品發貨單、集郵出庫票品、集郵袋數重量表、集郵包號版號(出庫單)
備注：
  對操作員要較驗權限，不能瀏覽其它庫房的入庫單
}
unit JYP_RKFH;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  FORMBASE, ExtCtrls, ModiPanel, StdCtrls, Mask, DBCtrls, Grids, DBGrids,
  CurrEdit, RXDBCtrl, ToolEdit, ComCtrls, Buttons, DBTables, Db,
  RxQuery, sqlstrings, RXCtrls;

type
  TFrm_JYP_RKFH = class(TFFormBase)
    ModiPanel1: TModiPanel;
    Panel1: TPanel;
    DBGrid2: TDBGrid;
    Panel2: TPanel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit6: TDBEdit;
    DBDateEdit1: TDBDateEdit;
    Label10: TLabel;
    Qryban: TQuery;
    DS_ban: TDataSource;
    QrybanTDM: TStringField;
    QrybanBLSH: TFloatField;
    QrybanBJC: TStringField;
    USQL_RKD: TUpdateSQL;
    DS_RKD: TDataSource;
    qryRKDPP: TQuery;
    USQL_RKDPP: TUpdateSQL;
    DS_RKDPP: TDataSource;
    DBGrid4: TDBGrid;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    DBGrid3: TDBGrid;
    qryRKD: TRxQuery;
    BitBtn5: TBitBtn;
    StoredProc1: TStoredProc;
    Label12: TLabel;
    qryRKDPPRKDH: TStringField;
    qryRKDPPPPDM: TStringField;
    qryRKDPPJJ: TFloatField;
    qryRKDPPKFDM: TStringField;
    qryRKDPPKWH: TStringField;
    qryRKDPPSL: TFloatField;
    qryRKDPPBZ: TStringField;
    qryRKDPPZH: TStringField;
    qryRKDPPTJC: TStringField;
    qryRKDPPKFMC: TStringField;
    qryRKDPPPPDW: TStringField;
    Panel3: TPanel;
    XttxTitle: TRxLabel;
    DWMC: TLabel;
    BitBtn6: TBitBtn;
    BitBtn7: TBitBtn;
    DateEdit1: TDateEdit;
    Label8: TLabel;
    DBEdit1: TDBEdit;
    qryBHBH: TQuery;
    qryBHBHRKDH: TStringField;
    qryBHBHPPDM: TStringField;
    qryBHBHBLSH: TFloatField;
    qryBHBHQSBH: TStringField;
    qryBHBHZZBH: TStringField;
    qryBHBHZH: TStringField;
    qryBHBHTJC: TStringField;
    qryBHBHbz: TStringField;
    USQL_BHBH: TUpdateSQL;
    DS_BHBH: TDataSource;
    procedure ModiPanel1BtnClick(Index: TBtnVisible);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure qryBHBHAfterInsert(DataSet: TDataSet);
    procedure BitBtn5Click(Sender: TObject);
    procedure qryRKDUpdateError(DataSet: TDataSet; E: EDatabaseError;
      UpdateKind: TUpdateKind; var UpdateAction: TUpdateAction);
    procedure qryRKDPPJJGetText(Sender: TField; var Text: string;
      DisplayText: Boolean);
    procedure qryRKDPPJJSetText(Sender: TField; const Text: string);
    procedure DBGrid2DrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
    procedure BitBtn6Click(Sender: TObject);
    procedure BitBtn7Click(Sender: TObject);
    procedure qryRKDAfterScroll(DataSet: TDataSet);
  private
    { Private declarations }
    FDtState: TDataState;
    function Save: Boolean;
    procedure SetState(Value: TdataState);
    procedure InitData;
    function Check(id: string): Boolean;
  public
    { Public declarations }
  end;

function Show_JYP_RKFH: Boolean;
var
  Frm_JYP_RKFH: TFrm_JYP_RKFH;

implementation

uses
  datas, Pub,
  JYP_RKFH_Print;                                           {入庫復核打印}

{$R *.DFM}

function Show_JYP_RKFH: Boolean;
begin
  Application.CreateForm(TFrm_JYP_RKFH, Frm_JYP_RKFH);
  with Frm_JYP_RKFH do
  try
    if CheckRight(Frm_JYP_RKFH, [ModiPanel1, BitBtn5, BitBtn6]) then
      result := ShowModal = MB_OK;
  finally
    Free;
  end;
end;

procedure TFrm_JYP_RKFH.SetState(Value: TdataState);
var
  v_b_modiBHBH: boolean;                                    //是否只修改包號版號(修改已復核過的出庫單包號版號)
  procedure SetControls(Value: Boolean);
  begin
    Panel1.Enabled := Value;
    DBEdit1.ReadOnly := Value or v_b_modiBHBH;
    DBDateEdit1.ReadOnly := Value or v_b_modiBHBH;
    DBGrid4.ReadOnly := Value;
    DBGrid3.ReadOnly := Value;
    BitBtn1.Enabled := not (Value);
    BitBtn2.Enabled := not (Value);
    BitBtn5.Enabled := Value and not (qryRKD.IsEmpty or qryRKDPP.isempty);
    BitBtn6.Enabled := Value and not (qryRKD.IsEmpty or qryRKDPP.isempty);
  end;
begin
  v_b_modiBHBH := false;
  if not qryRKD.Active then
  begin
    FDtState := dtBrowse;
    ModiPanel1.ChangeMode(FDtState = dtBrowse);
    SetControls(FDtState = dtBrowse);
    exit;
  end;

  if (Value in [dtEdit, dtInsert]) and
    isChecked(io_jyp, False, qryRKD.FieldbyName('rkdh').Asstring) then
  begin
    if qryRKD.FieldbyName('JZY').AsString <> VG_UserName then
    begin
      CHQMsgBox('對不起，您只能修改自己的入庫單');
      exit;
    end
    else
      v_b_modiBHBH := true;
  end;
  FDtState := Value;
  ModiPanel1.ChangeMode(FDtState = dtBrowse);
  SetControls(FDtState = dtBrowse);
  with qryRKD do
    case FDtstate of
      dtBrowse:
        begin
          {          qryRKDPP.Datasource := DataSource2;
                    qryBHBH.Datasource := DataSource2;}
        end;
      dtinsert:
        begin
          Append;
          {          qryRKDPP.Datasource := nil;
                    qryBHBH.Datasource := nil;}
          FieldByName('KGY').Asstring := VG_USERNAME;
        end;
      dtedit:
        begin
          if not v_b_modiBHBH then
          begin
            {            qryRKDPP.Datasource := nil;
                        qryBHBH.Datasource := nil;}
            Edit;
            if FieldByName('RKRQ').AsString = '' then
              FieldByName('RKRQ').AsDateTime := GetSYSDate;
          end
          else if qryBHBH.IsEmpty then
          begin
            qryRKDPP.First;
            while not qryRKDPP.Eof do
            begin
              qryBHBH.Append;
              qryBHBH.FieldByName('RKDH').Asstring := qryRKD.FieldByName('RKDH').Asstring;
              qryBHBH.FieldByName('PPDM').Asstring := qryRKDPP.FieldByName('PPDM').Asstring;
              qryBHBH.FieldByName('ZH').Asstring := qryRKDPP.FieldByName('ZH').Asstring;
              qryBHBH.FieldByName('TJC').Asstring := qryRKDPP.FieldByName('TJC').Asstring;
              qryBHBH.Post;
              qryRKDPP.Next;
            end;
          end;
        end;
    end;
end;

function TFrm_JYP_RKFH.Save: Boolean;
begin
  result := True;
  with qryBHBH do                                           {query}
  begin
    First;
    while not Eof do
    begin                                                   //RKDH, PPDM, QSBH, ZZBH
      if (FieldByName('RKDH').Asstring = '') or (FieldByName('PPDM').Asstring = '')
        or (FieldByName('QSBH').Asstring = '') or (FieldByName('ZZBH').Asstring = '') then
      begin
        CHQMsgBox('起始版號、終止版號不能為空!');
        result := False;
        Break;
      end;
      Next;
    end;
  end;
  if not result then
    exit;

  with qryRKD do                                            {query}
  begin
    Database.StartTransaction;
    try
      qryRKD.ApplyUpdates;
      qryRKDPP.ApplyUpdates;
      qryBHBH.ApplyUpdates;
      Database.Commit;
    except
      if Database.InTransaction then