unit U_TradePackClothInList; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, cxStyles, cxCustomData, cxGraphics, cxFilter, cxData, cxDataStorage, cxEdit, DB, cxDBData, cxGridCustomTableView, cxGridTableView, cxGridBandedTableView, cxGridDBBandedTableView, cxGridLevel, cxClasses, cxControls, cxGridCustomView, cxGridDBTableView, cxGrid, StdCtrls, ComCtrls, ExtCtrls, ToolWin, cxGridCustomPopupMenu, cxGridPopupMenu, ADODB, DBClient, cxDropDownEdit, cxCheckBox, RM_Common, RM_Class, RM_e_Xls, RM_Dataset, RM_System, RM_GridReport, Menus, cxCalendar, cxButtonEdit, cxTextEdit, cxPC, cxLookAndFeels, cxLookAndFeelPainters, dxSkinsCore, dxSkinsDefaultPainters, cxNavigator, dxDateRanges, dxBarBuiltInMenu, U_BaseList, dxSkinOffice2013White, // Plus, dxSkinWXI, dxScrollbarAnnotations; type TfrmTradePackClothInList = class(TfrmBaseList) ToolBar1: TToolBar; TBRafresh: TToolButton; TBFind: TToolButton; TBExport: TToolButton; TBClose: TToolButton; Panel1: TPanel; ADOQueryCmd: TADOQuery; ADOQueryMain: TADOQuery; ADOQueryTemp: TADOQuery; DataSource1: TDataSource; cxGridPopupMenu1: TcxGridPopupMenu; Label1: TLabel; Label2: TLabel; BegDate: TDateTimePicker; EndDate: TDateTimePicker; CDS_Main: TClientDataSet; TBDel: TToolButton; PopupMenu1: TPopupMenu; N1: TMenuItem; N2: TMenuItem; TBAdd: TToolButton; TBEdit: TToolButton; Label3: TLabel; Label4: TLabel; Label5: TLabel; Label8: TLabel; Label12: TLabel; C_name: TEdit; FromCoName: TEdit; BCIOID: TEdit; C_spec: TEdit; IOType: TComboBox; cxGrid1: TcxGrid; Tv1: TcxGridDBTableView; v1Column6: TcxGridDBColumn; v1Column2: TcxGridDBColumn; v1Column4: TcxGridDBColumn; v1Column14: TcxGridDBColumn; v2Column1: TcxGridDBColumn; v1Column8: TcxGridDBColumn; v2Column6: TcxGridDBColumn; v1Column3: TcxGridDBColumn; v1Column5: TcxGridDBColumn; v1Column12: TcxGridDBColumn; cxGrid1Level1: TcxGridLevel; v1Column10: TcxGridDBColumn; Label10: TLabel; BatchNo: TEdit; v1Column11: TcxGridDBColumn; v1Column13: TcxGridDBColumn; v1Column15: TcxGridDBColumn; v1Column19: TcxGridDBColumn; v1Column20: TcxGridDBColumn; Tv1Column3: TcxGridDBColumn; Tv1Column5: TcxGridDBColumn; ToolButton1: TToolButton; Tv1Column1: TcxGridDBColumn; ToolButton2: TToolButton; Tv1Column2: TcxGridDBColumn; Tv1Column4: TcxGridDBColumn; Tv1Column6: TcxGridDBColumn; Tv1Column7: TcxGridDBColumn; Tv1Column8: TcxGridDBColumn; Tv1Column9: TcxGridDBColumn; Tv1Column10: TcxGridDBColumn; Tv1Column11: TcxGridDBColumn; Tv1Column12: TcxGridDBColumn; Tv1Column13: TcxGridDBColumn; Tv1Column14: TcxGridDBColumn; Tv1Column15: TcxGridDBColumn; Tv1Column16: TcxGridDBColumn; Tv1Column17: TcxGridDBColumn; Label6: TLabel; FromBuyConNoHZ: TEdit; C_StyleNo: TEdit; Label7: TLabel; Tv1Column18: TcxGridDBColumn; Label13: TLabel; FromConNo: TEdit; Label14: TLabel; C_Color: TEdit; cxTabControl1: TcxTabControl; TvHz: TcxGridDBTableView; HzColFromConNo: TcxGridDBColumn; HzColBuyConNo: TcxGridDBColumn; HzColCName: TcxGridDBColumn; HzColCColor: TcxGridDBColumn; HzColQtyUnit: TcxGridDBColumn; HzColQty: TcxGridDBColumn; HzColPiece: TcxGridDBColumn; HzColBoxs: TcxGridDBColumn; cxGridLevelHz: TcxGridLevel; procedure FormClose(Sender: TObject; var Action: TCloseAction); procedure FormCreate(Sender: TObject); procedure TBRafreshClick(Sender: TObject); procedure ConNoMChange(Sender: TObject); procedure TBCloseClick(Sender: TObject); procedure FormShow(Sender: TObject); procedure TBExportClick(Sender: TObject); procedure TBFindClick(Sender: TObject); procedure N1Click(Sender: TObject); procedure N2Click(Sender: TObject); procedure TBDelClick(Sender: TObject); procedure TBAddClick(Sender: TObject); procedure TBEditClick(Sender: TObject); procedure BCIOIDChange(Sender: TObject); procedure C_specChange(Sender: TObject); procedure FromCoNameChange(Sender: TObject); procedure TvHzDblClick(Sender: TObject); procedure cxTabControl1Change(Sender: TObject); procedure ToolButton1Click(Sender: TObject); procedure ToolButton2Click(Sender: TObject); private canshu1, canshu2, canshu3: string; procedure InitGrid(); procedure setStatus(); procedure SetHzStatus(); { Private declarations } public FSTKName: string; { Public declarations } end; implementation uses U_DataLink, U_RTFun, U_LabelPrint, U_TradePackClothInEdit; {$R *.dfm} procedure TfrmTradePackClothInList.setStatus(); begin end; procedure TfrmTradePackClothInList.FormClose(Sender: TObject; var Action: TCloseAction); begin inherited; Action := caFree; end; procedure TfrmTradePackClothInList.FormCreate(Sender: TObject); begin inherited; EndDate.DateTime := SGetServerDate(ADOQueryTemp); BegDate.DateTime := EndDate.DateTime - 30; canshu1 := Trim(self.fParameters1); canshu2 := Trim(self.fParameters2); canshu3 := Trim(self.fParameters3); end; procedure TfrmTradePackClothInList.InitGrid(); begin try ADOQueryMain.DisableControls; with ADOQueryMain do begin Filtered := False; Close; sql.Clear; if cxTabControl1.TabIndex = 0 then begin //汇总页:按合同号/客户单号/产品名称/颜色汇总 sql.Add(' select FromConNo,FromBuyConNoHZ,C_Name,C_Color,QtyUnit '); sql.Add(' ,Qty=sum(isnull(Qty,0)),Piece=sum(isnull(Piece,0)),boxs=sum(isnull(boxs,0)) '); sql.Add(' from BS_Cloth_IO A'); sql.add(' where A.IOTime>=''' + Trim(FormatDateTime('yyyy-MM-dd', BegDate.DateTime)) + ''''); sql.Add(' and A.IOTime<''' + Trim(FormatDateTime('yyyy-MM-dd', enddate.DateTime + 1)) + ''''); sql.Add(' and isnull(STKNAME,'''')=''' + Trim(FSTKNAME) + ''''); SQL.Add(' and IOFlag=''入库'' '); SQL.Add(' group by FromConNo,FromBuyConNoHZ,C_Name,C_Color,QtyUnit '); SQL.Add(' order by FromConNo,FromBuyConNoHZ,C_Name,C_Color '); end else begin //明细页:原界面查询 sql.Add(' select A.* '); sql.Add(' ,ConQty=(select B.ConQty from BS_Contract_Sub B where B.ConSId=A.FromConSId) '); sql.Add(' from BS_Cloth_IO A'); sql.add(' where A.IOTime>=''' + Trim(FormatDateTime('yyyy-MM-dd', BegDate.DateTime)) + ''''); sql.Add(' and A.IOTime<''' + Trim(FormatDateTime('yyyy-MM-dd', enddate.DateTime + 1)) + ''''); sql.Add(' and isnull(STKNAME,'''')=''' + Trim(FSTKNAME) + ''''); SQL.Add(' and IOFlag=''入库'' '); SQL.Add(' order by IOTime desc'); end; // ShowMessage(SQL.TEXT); Open; end; SDofilter(ADOQueryMain, SGetFilters(Panel1, 1, 2)); SCreateCDS(ADOQueryMain, CDS_Main); SInitCDSData(ADOQueryMain, CDS_Main); finally ADOQueryMain.EnableControls; end; end; procedure TfrmTradePackClothInList.TBRafreshClick(Sender: TObject); begin BegDate.SetFocus; InitGrid(); end; procedure TfrmTradePackClothInList.ToolButton1Click(Sender: TObject); begin if cxTabControl1.TabIndex = 0 then WriteCxGrid(Self.Caption + '汇总', TvHz, '贸易汇总仓库') else WriteCxGrid(Self.Caption, Tv1, '贸易汇总仓库'); end; procedure TfrmTradePackClothInList.ToolButton2Click(Sender: TObject); var MBCIOID: string; begin if CDS_Main.IsEmpty then Exit; if CDS_Main.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; MBCIOID := ''; CDS_Main.DisableControls; with CDS_Main do begin First; while CDS_Main.Locate('SSel', True, []) do begin MBCIOID := MBCIOID + ',' + QuotedStr(Trim(CDS_Main.fieldbyname('BCIOID').AsString)); Edit; FieldByName('SSel').Value := False; Post; end; end; CDS_Main.EnableControls; try frmLabelPrint := TfrmLabelPrint.Create(Application); with frmLabelPrint do begin FLMType := 'TradeFinishClothInPrt1'; FFiltration1 := MBCIOID; if ShowModal = 1 then begin // Self.InitGrid(); end; end; finally frmLabelPrint.Free; end; end; procedure TfrmTradePackClothInList.ConNoMChange(Sender: TObject); begin if ADOQueryMain.Active then begin SDofilter(ADOQueryMain, SGetFilters(Panel1, 1, 2)); end; end; procedure TfrmTradePackClothInList.TBCloseClick(Sender: TObject); begin Close; end; procedure TfrmTradePackClothInList.FormShow(Sender: TObject); begin inherited; if cxTabControl1.TabIndex = 0 then begin cxGrid1.ActiveLevel := cxGridLevelHz; ReadCxGrid(Self.Caption + '汇总', TvHz, '贸易汇总仓库'); end else ReadCxGrid(Self.Caption, Tv1, '贸易汇总仓库'); setStatus(); SetHzStatus(); InitGrid(); end; procedure TfrmTradePackClothInList.TBExportClick(Sender: TObject); begin if ADOQueryMain.IsEmpty then exit; TcxGridToExcel(FSTKName + '入库列表', cxGrid1); end; procedure TfrmTradePackClothInList.TBFindClick(Sender: TObject); begin if ADOQueryMain.Active then begin SDofilter(ADOQueryMain, SGetFilters(Panel1, 1, 2)); SCreateCDS(ADOQueryMain, CDS_Main); SInitCDSData(ADOQueryMain, CDS_Main); end; end; procedure TfrmTradePackClothInList.N1Click(Sender: TObject); begin SelOKNo(CDS_Main, True); end; procedure TfrmTradePackClothInList.N2Click(Sender: TObject); begin SelOKNo(CDS_Main, False); end; procedure TfrmTradePackClothInList.TBDelClick(Sender: TObject); var MBCIOID: string; begin if CDS_Main.IsEmpty then Exit; if Application.MessageBox('确定要删除数据吗?', '提示', 32 + 4) <> IDYES then Exit; if CDS_Main.IsEmpty then Exit; if CDS_Main.Locate('SSel', True, []) = False then begin Application.MessageBox('没有选择数据!', '提示', 0); Exit; end; MBCIOID := ''; CDS_Main.DisableControls; with CDS_Main do begin First; while CDS_Main.Locate('SSel', True, []) do begin MBCIOID := MBCIOID + ',' + Trim(CDS_Main.fieldbyname('BCIOID').AsString); CDS_Main.Delete; end; end; CDS_Main.EnableControls; with ADOQueryTemp do begin Close; sql.Clear; sql.Add('exec P_Fin_Flow_Judge '); Sql.Add(' @FFIDS=' + quotedstr(MBCIOID)); Sql.Add(',@DCode=' + quotedstr(Trim(DCode))); Sql.Add(',@DName=' + quotedstr(Trim(DName))); Open; end; if ADOQueryTemp.FieldByName('intReturn').AsInteger = -1 then begin Application.MessageBox(PChar(ADOQueryTemp.fieldbyname('ShowMsg').AsString), '提示', 0); exit; end; try ADOQueryCmd.Connection.BeginTrans; with ADOQueryCmd do begin Close; Sql.Clear; sql.Add('insert into Finance_Need_Up(UType,UDataId,UOperation,UOperator,UModule,UDetails) '); sql.Add('values(''贸易成品入库'' '); sql.Add(',' + quotedstr(MBCIOID)); sql.Add(',''删除'' '); sql.Add(',' + quotedstr(DName)); sql.Add(',' + quotedstr(trim(self.Caption))); sql.Add(',' + quotedstr(MBCIOID)); sql.Add(') '); Sql.Add('exec P_BS_Cloth_In_Del '); Sql.Add(' @BCIOIDS=' + quotedstr(MBCIOID)); Sql.Add(',@DCode=' + quotedstr(Trim(DCode))); Sql.Add(',@DName=' + quotedstr(Trim(DName))); Open; end; if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString))); ADOQueryCmd.Connection.CommitTrans; // CDS_Main.Delete; except ADOQueryCmd.Connection.RollbackTrans; application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0); InitGrid(); end; end; procedure TfrmTradePackClothInList.TBAddClick(Sender: TObject); begin try frmTradePackClothInEdit := TfrmTradePackClothInEdit.Create(Application); with frmTradePackClothInEdit do begin FBCId := ''; frmTradePackClothInEdit.canshu3 := Trim(Self.canshu3); FSTKName := Self.FSTKName; if ShowModal = 1 then begin Self.InitGrid(); end; end; finally frmTradePackClothInEdit.Free; end; end; procedure TfrmTradePackClothInList.TBEditClick(Sender: TObject); begin if CDS_Main.IsEmpty then Exit; with ADOQueryTemp do begin Close; sql.Clear; sql.Add('exec P_Fin_Flow_Judge '); Sql.Add(' @FFIDS=' + quotedstr(Trim(CDS_Main.fieldbyname('BCIOID').AsString))); Sql.Add(',@DCode=' + quotedstr(Trim(DCode))); Sql.Add(',@DName=' + quotedstr(Trim(DName))); Open; end; if ADOQueryTemp.FieldByName('intReturn').AsInteger = -1 then begin Application.MessageBox(PChar(ADOQueryTemp.fieldbyname('ShowMsg').AsString), '提示', 0); exit; end; with ADOQueryTemp do begin Close; Sql.Clear; Sql.Add('exec P_BS_Cloth_In_Edit '); Sql.Add(' @BCIOIDS=' + quotedstr(Trim(CDS_Main.fieldbyname('BCIOID').AsString))); Sql.Add(',@DCode=' + quotedstr(Trim(DCode))); Sql.Add(',@DName=' + quotedstr(Trim(DName))); Open; end; if ADOQueryTemp.FieldByName('intReturn').AsInteger = -1 then begin Application.MessageBox(PChar(ADOQueryTemp.fieldbyname('ShowMsg').AsString), '提示', 0); exit; end; try frmTradePackClothInEdit := TfrmTradePackClothInEdit.Create(Application); with frmTradePackClothInEdit do begin FBCId := Trim(CDS_Main.fieldbyname('BCIOID').AsString); TBDel.Visible := False; TBAdd.Visible := False; FSTKName := Self.FSTKName; if ShowModal = 1 then begin Self.InitGrid(); end; end; finally frmTradePackClothInEdit.Free; end; end; procedure TfrmTradePackClothInList.BCIOIDChange(Sender: TObject); begin if Length(Trim(BCIOID.Text)) < 4 then begin if Trim(BCIOID.Text) <> '' then Exit; end; TBFind.Click; end; procedure TfrmTradePackClothInList.C_specChange(Sender: TObject); begin TBFind.Click; end; procedure TfrmTradePackClothInList.FromCoNameChange(Sender: TObject); begin TBFind.Click; end; //双击汇总行:把汇总条件带到明细页查询 procedure TfrmTradePackClothInList.TvHzDblClick(Sender: TObject); begin if CDS_Main.IsEmpty then Exit; try C_name.OnChange := nil; FromBuyConNoHZ.OnChange := nil; FromConNo.OnChange := nil; C_Color.OnChange := nil; C_name.Text := Trim(CDS_Main.fieldbyname('C_Name').AsString); FromBuyConNoHZ.Text := Trim(CDS_Main.fieldbyname('FromBuyConNoHZ').AsString); FromConNo.Text := Trim(CDS_Main.fieldbyname('FromConNo').AsString); C_Color.Text := Trim(CDS_Main.fieldbyname('C_Color').AsString); finally C_name.OnChange := TBFindClick; FromBuyConNoHZ.OnChange := FromCoNameChange; FromConNo.OnChange := FromCoNameChange; C_Color.OnChange := FromCoNameChange; end; if cxTabControl1.TabIndex <> 1 then begin cxTabControl1.OnChange := nil; cxTabControl1.TabIndex := 1; cxTabControl1.OnChange := cxTabControl1Change; end; cxGrid1.ActiveLevel := cxGrid1Level1; SetHzStatus(); InitGrid(); end; procedure TfrmTradePackClothInList.cxTabControl1Change(Sender: TObject); begin if cxTabControl1.TabIndex = 0 then cxGrid1.ActiveLevel := cxGridLevelHz else cxGrid1.ActiveLevel := cxGrid1Level1; SetHzStatus(); InitGrid(); end; procedure TfrmTradePackClothInList.SetHzStatus(); var mFlag: Boolean; begin mFlag := (cxTabControl1.TabIndex <> 0); //明细页=true,汇总页=false TBAdd.Enabled := mFlag; //入库 TBEdit.Enabled := mFlag; //修改 TBDel.Enabled := mFlag; //删除 ToolButton2.Enabled := mFlag; //打印 //汇总页直接隐藏没有对应列的筛选框,只留查询时间/品名/客户单号一行 Label5.Visible := mFlag; BCIOID.Visible := mFlag; //入库单号 Label12.Visible := mFlag; IOType.Visible := mFlag; //入库类型 Label8.Visible := mFlag; C_spec.Visible := mFlag; //规格 Label4.Visible := mFlag; FromCoName.Visible := mFlag; //来自单位 Label10.Visible := mFlag; BatchNo.Visible := mFlag; //批号 Label7.Visible := mFlag; C_StyleNo.Visible := mFlag; //款号 // if mFlag then // Panel1.Height := 58 // else // Panel1.Height := 32; if not mFlag then begin //明细跳回汇总:上面的过滤条件全部清空 BCIOID.OnChange := nil; IOType.OnChange := nil; C_spec.OnChange := nil; FromCoName.OnChange := nil; BatchNo.OnChange := nil; C_StyleNo.OnChange := nil; C_name.OnChange := nil; FromBuyConNoHZ.OnChange := nil; FromConNo.OnChange := nil; C_Color.OnChange := nil; BCIOID.Text := ''; IOType.ItemIndex := -1; C_spec.Text := ''; FromCoName.Text := ''; BatchNo.Text := ''; C_StyleNo.Text := ''; C_name.Text := ''; FromBuyConNoHZ.Text := ''; FromConNo.Text := ''; C_Color.Text := ''; BCIOID.OnChange := BCIOIDChange; IOType.OnChange := TBFindClick; C_spec.OnChange := C_specChange; FromCoName.OnChange := FromCoNameChange; BatchNo.OnChange := FromCoNameChange; C_StyleNo.OnChange := FromCoNameChange; C_name.OnChange := TBFindClick; FromBuyConNoHZ.OnChange := FromCoNameChange; FromConNo.OnChange := FromCoNameChange; C_Color.OnChange := FromCoNameChange; end; end; end.