int retn,li_count,li_index,li_row
int alam
alam=0
retn=messagebox("注意","本操作将删除所有历史记录,确实要删除选Y,~r~n否则选N,~r~n",information!,yesnocancel!,1)
choose case retn
case 1
//dw_12.deleterow(0)
//if dw_12.Update() = 1 then
// commit;
//li_count=dw_1.rowcount()
// for li_row= li_count to 2 step -1
// dw_1.deleterow(li_row)
// next
// commit;
dw_1.RowsMove(1, dw_1.rowcount() ,primary!, dw_1,1,Delete!)
if dw_1.update(true,false) = 1 then
commit;
else
messagebox("","删除记录失败!")
alam=1
end if
//ls_sql = SqlCa.SynTaxFromSql(ls_sql,'style(type=grid)',ls_err)
//导入数据到临时数据窗口,以便进行数据拷贝
IF GetFileOpenName("选择要导入的文件",ls_path,ls_file, "txt","文本格式(*.txt),*.txt,电子表格(Excel),*.xls,DBF 3(dabase Ⅲ),*.dbf") = 1 THEN
ls_type = 'xls'
dw_1.CREATE(ls_sql,ls_err)
CHOOSE CASE ls_type
CASE 'txt'
ls_targerfile = ls_path
CASE 'xls','dbf'
OLEObject ExcelServer
ExcelServer = CREATE OLEObject
IF ExcelServer.ConnectToNewObject( "excel.application" ) < 0 THEN
messagebox("","连接excel失败,检查你的系统是否安装了office,必须安装EXCLE才可以使用该导入功能!")
ELSE
lb_delete = TRUE//需要删除临时文件
ExcelServer.Workbooks.Open(ls_path)
ls_targerfile=Left(ls_path,Len(ls_path) - 4) + "_temp.txt"
excelserver.activeworkbook.saveas(ls_targerfile,3)
excelserver.displayalerts=FALSE
ExcelServer.quit()
ExcelServer.DisconnectObject()
DESTROY ExcelServer
END IF
case else
return
end choose
end if
dw_1.importfile(ls_targerfile,2)
IF dw_1.RowCount() = 0 THEN
messagebox("", '待导入数据没有任何记录!')
ls_sql = SqlCa.SynTaxFromSql(ls_sql,'style(type=grid)',ls_err)
IF Len(ls_err) > 0 THEN
IF lb_delete THEN
FileDelete(ls_targerfile)
END IF
messagebox("", '在读取数据时出现问题。发现了一些不应该有的!~n' + ls_err)
END IF
else
dw_1.settransobject(sqlca);
dw_1.update();
commit;
END IF
if sqlca.sqlcode=-1 then
messagebox("sql error",sqlca.sqlerrtext)
end for
//总表电量,最大值,最小值,次数最多值,合计
dec_total1=dw_view.object.Primary.Current.total1
lo_xlsub.cells[ll_count+2,2]=dec_total1
dec_total2=dw_view.object.Primary.Current.total2
lo_xlsub.cells[ll_count+2,3]=dec_total2
dec_total3=dw_view.object.Primary.Current.total3
lo_xlsub.cells[ll_count+2,6]=dec_total3