begin
if dbeCustomerCode.Text = '' then
begin
Application.MessageBox('请选择客户!', '提示', MB_OK + mb_IconInformation);
Exit;
end;
SqlStr := 'Select tOrderSumDetail.SysID, tOrderSumDetail.StyleCode,tOrderSumDetail.ColorCode, '
+ ' tOrderSumDetail.Price,tOrderSumDetail.Qty,tOrderSumDetail.AssistantQty '
+ ' From tOrderSum'
+ ' INNER Join tOrderSumDetail On tOrderSum.ItemID = tOrderSumDetail.ItemID';
WhereStr := ' Where 1=1 And tOrderSum.ItemState = 1 And tOrderSum.BillDate >=''' + DateToStr(dtpStartDateS.Date)
+ ''' And tOrderSum.BillDate <= ''' + DateToStr(dtpEndDateS.Date) + '''';
if dbeCustomerCode.Text <> '' then
WhereStr := WhereStr + ' And tOrderSum.CustomerCode = ''' + Trim(dbeCustomerCode.Text) + '''';
if Trim(edtStyleCode.Text) <> '' then
WhereStr := WhereStr + ' And tOrderSumDetail.StyleCode Like ''%' + Trim(edtStyleCode.Text) + '%''';
if Trim(edtColor.Text) <> '' then
WhereStr := WhereStr + ' And tOrderSumDetail.ColorCode Like ''%' + Trim(edtColor.Text) + '%''';
SqlStr := SqlStr + WhereStr;
MOpenSQL(SqlStr, qryOrderSearch);
end;
if dbeCustomerCode.Text = '' then
begin
Application.MessageBox('请选择客户!', '提示', MB_OK + mb_IconInformation);
Exit;
end;
SqlStr := 'Select tOrderSumDetail.SysID, tOrderSumDetail.StyleCode,tOrderSumDetail.ColorCode, '
+ ' tOrderSumDetail.Price,tOrderSumDetail.Qty,tOrderSumDetail.AssistantQty '
+ ' From tOrderSum'
+ ' INNER Join tOrderSumDetail On tOrderSum.ItemID = tOrderSumDetail.ItemID';
WhereStr := ' Where 1=1 And tOrderSum.ItemState = 1 And tOrderSum.BillDate >=''' + DateToStr(dtpStartDateS.Date)
+ ''' And tOrderSum.BillDate <= ''' + DateToStr(dtpEndDateS.Date) + '''';
if dbeCustomerCode.Text <> '' then
WhereStr := WhereStr + ' And tOrderSum.CustomerCode = ''' + Trim(dbeCustomerCode.Text) + '''';
if Trim(edtStyleCode.Text) <> '' then
WhereStr := WhereStr + ' And tOrderSumDetail.StyleCode Like ''%' + Trim(edtStyleCode.Text) + '%''';
if Trim(edtColor.Text) <> '' then
WhereStr := WhereStr + ' And tOrderSumDetail.ColorCode Like ''%' + Trim(edtColor.Text) + '%''';
SqlStr := SqlStr + WhereStr;
MOpenSQL(SqlStr, qryOrderSearch);
end;
解决方案 »
- 诚招PHP,Delphi工程师(地点南昌)
- BDE的TQUERY控件打开DBF表时的问题?
- 影响caption更新的消息是什么?
- 关于TDBComboBox的问题:如何防止对Items进行Clear操作时,文字输入光标复位的问题?
- 大量delphi商业源码,编程资料,免费下载,欢迎拍砖!
- 帮个忙,感激不尽!
- 散散分吧,解决了几个头疼的问题,程序今天终于还是通了。
- 555,没分了!好心人,请问点击DBNavigator1控制dbgrid中的记录指针流动,但用DBImage显示各个记录中的图片如何做?
- 怎样结束应用程序的线程?
- COMBOBOX的宽度不够怎么办?
- 求助 delphi
- Delphi 类与数组
var
ini:TIniFile;
begin
ini := TIniFile.Create('c:\sql.ini');
ini.WriteString('SQL','Text','sql语句');
end;
ASqlStr :string;
AStringList :TStrings;
begin
ASqlStr :='select * from test';
AStringList :=TStringList.Create;
try
AStringList.Add(ASqlStr);
AStringList.SaveToFile('D:\a.txt');
finally
AStringList.Free;
end;