unit DRGS;
interface
uses
Business.System, Business.Forms, Business.Model, Business.Data,ExcelHandling;
type
TDRGS = class(TForm)
panelControls: TPanel;
btnImport: TButton;
PanelDataGrid: TPanel;
DataGrid: TDataGrid;
sbStatusBar: TStatusBar;
procedure btnImportClick(Sender: TObject);
procedure BizFormCreate(Sender: TObject);
procedure BizFormDestroy(Sender: TObject);
private
{private declarations}
DataSet: TUserDataSet;
_DataSource:TDataSource;
procedure ImportWorkTime(strFileName,sheetName: string;iStartRow,iEndRow,iStartColumn: Integer);
public
{public declarations}
end;
implementation
procedure TDRGS.BizFormCreate(Sender: TObject);
var
bizField:TBizField;
begin
DataSet:=TUserDataSet.Create(self);
DataSet.Name:='DataSet';
bizField:=TUserDataField.Create(DataSet);
bizField.DataSet:= DataSet;
bizField.ID:='MoldID';
bizField.Name:='MoldID';
bizField.DisplayName:='制号';
bizField.DataType:=TDatatype.dtString;
bizField.Size:=20;
bizField:=TUserDataField.Create(DataSet);
bizField.DataSet:= DataSet;
bizField.ID:='ManufactureProgress';
bizField.Name:='ManufactureProgress';
bizField.DisplayName:='制造工序';
bizField.DataType:=TDatatype.dtString;
bizField.Size:=20;
bizField:=TUserDataField.Create(DataSet);
bizField.DataSet:= DataSet;
bizField.ID:='dDate';
bizField.Name:='dDate';
bizField.DisplayName:='日期';
bizField.DataType:=TDatatype.dtString;
bizField.Size:=20;
bizField:=TUserDataField.Create(DataSet);
bizField.DataSet:= DataSet;
bizField.ID:='WorkTime';
bizField.Name:='WorkTime';
bizField.DisplayName:='工时';
bizField.DataType:=TDatatype.dtString;
bizField.Size:=20;
bizField:=TUserDataField.Create(DataSet);
bizField.DataSet:= DataSet;
bizField.ID:='Person';
bizField.Name:='Person';
bizField.DisplayName:='人员';
bizField.DataType:=TDatatype.dtString;
bizField.Size:=20;
以下省略、 |