public void RunStockCheck(string id) { LinkSelect linkS = new LinkSelect(); linkS.TableNames.Add("stockMaterialSettlementDetail"); linkS.TableNames.Add("stockMaterialSettlement"); linkS.LinkConds.Add("stockMaterialSettlementDetail.smsId=stockMaterialSettlement.id"); linkS.TableNames.Add("indent"); linkS.LinkConds.Add("stockMaterialSettlementDetail.iId=indent.id"); linkS.TableNames.Add("material"); linkS.LinkConds.Add("indent.mId=material.id"); linkS.TableNames.Add("materialName"); linkS.LinkConds.Add("material.mnId=materialName.id"); linkS.TableNames.Add("materialModel"); linkS.LinkConds.Add("material.mmId=materialModel.id"); linkS.TableNames.Add("materialKind"); linkS.LinkConds.Add("materialName.mkId=materialKind.id"); linkS.Viewfields.Add("materialKind.sort"); linkS.Viewfields.Add("materialName.[name]"); linkS.Viewfields.Add("materialModel.model"); linkS.Viewfields.Add("stockMaterialSettlementDetail.[sum] as money"); linkS.Viewfields.Add("stockMaterialSettlementDetail.count as suttle"); linkS.Viewfields.Add("indent.unitPrice"); linkS.Conds.Add("stockMaterialSettlement.id=" + id); DataSet ds = linkS.LeftLinkOpen(); //SqlHelper helper = new SqlHelper(); //String sql = "Select voitureInfo.[no] as sort,stockContract.[name],stockNote.iId as 合同明细编号,materialName.[name] as 材料名称,materialModel.model,stockNote.grossWeight as 车辆毛重,stockNote.tare as 车辆皮重,stockNote.suttle,site1.site as 起运地,site2.site as 止运地,stockNote.inputdate as 日期时间,stockNote.remark as 备注,stockNote.barCode as 条形码,unitPrice,unitPrice * stockNote.suttle as money From stockMaterialNoteCorresponding Left Outer Join stockNote ON stockMaterialNoteCorresponding.snId=stockNote.id Left Outer Join stockMaterialSettlementDetail ON stockMaterialNoteCorresponding.smsdId=stockMaterialSettlementDetail.id Left Outer Join stockMaterialSettlement ON stockMaterialSettlementDetail.smsId=stockMaterialSettlement.id Left Outer Join stockContract ON stockMaterialSettlement.scId=stockContract.id Left Outer Join voitureInfo ON stockNote.viId=voitureInfo.id Left Outer Join transportUnit ON voitureInfo.tuId=transportUnit.id Left Outer Join site site1 ON stockNote.sId1=site1.id Left Outer Join site site2 ON stockNote.sId2=site2.id Left Outer Join transportGoodsInformationCorresponding ON stockNote.tgicId=transportGoodsInformationCorresponding.id Left Outer Join transportContract ON transportGoodsInformationCorresponding.tcId=transportContract.id Left Outer Join indent ON stockNote.iId=indent.id Left Outer Join material ON indent.mId=material.id Left Outer Join materialName ON material.mnId=materialName.id Left Outer Join materialModel ON material.mmId=materialModel.id where 1=1 "; //System.Collections.ArrayList oArrayList = new System.Collections.ArrayList(); //oArrayList.Add(sql); //DataSet ds = helper.QueryForDateSet(oArrayList); StockCheck oStockCheck = new StockCheck(); oStockCheck.Source = ds; CReportTools tools = new CReportTools(); DataTable dt = ds.Tables[0]; Decimal money = 0; for (int i = 0; i < dt.Rows.Count; i++) { money += Convert.ToDecimal(dt.Rows[i]["money"]); } oStockCheck.SumMoney = tools.ToUpper(money); oStockCheck.AccountNum = id.ToString(); oStockCheck.ContractNum = "100086"; oStockCheck.CoName = "中百科技有限公司"; oStockCheck.Num = "1111"; oStockCheck.InvoiceNo = "0001"; oStockCheck.Supplier = "中百"; oStockCheck.Telephone = "138888888"; oStockCheck.Auditor = "刘淼"; oStockCheck.Examine = "bbb"; oStockCheck.Approve = "ccc"; oStockCheck.AuditorYmd = "2008年5月21号"; oStockCheck.ExamineYmd = "2008年5月22号"; oStockCheck.ApproveYmd = "2008年5月23号"; oStockCheck.ShowReport(); }
public void RunTransportCheck(string id) { //材料种类 sort //材料名称 materialName //规格 model //起运地 startSite //止运地 endSite //运输数量 quantity //运输距离 distance //单价 unitPrice //金额(元) money SqlHelper helper = new SqlHelper(); String sql = "select tsmd.id, coalesce(pn.name,mn.name) as materialName,coalesce(pm.model,mm.model) as model,coalesce(pk.sort,mk.sort) as sort "; sql += ",site1.site as startSite,site2.site as endSite,distance,price as unitPrice,tsmId,case mark when 1 then '已终止' else '执行中' end mark,tsmd.count as quantity,tsmd.sum as money,tsm.remark as formula"; sql += " from transportGoodsInformationCorresponding tgi inner join transportSettlementMethod tsm on tsmid=tsm.id"; sql += " inner join transportSettlementDetail tsmd on tsmd.tgicId=tgi.id "; sql += " left join material m on m.id=mid"; sql += " left join materialName mn on m.mnid=mn.id left join materialModel mm on m.mmid=mm.id "; sql += " left join materialKind mk on mn.mkid=mk.id"; sql += " left join product p on p.id=pid left join productName pn on p.pnid=pn.id "; sql += " left join productModel pm on p.pmid=pm.id "; sql += " left join productKind pk on pn.pkid=pk.id"; sql += " left join site site1 on tgi.sid1=site1.id"; sql += " left join site site2 on tgi.sid1=site2.id"; sql += " where tsmd.tsid=" + id; System.Collections.ArrayList oArrayList = new System.Collections.ArrayList(); oArrayList.Add(sql); DataSet ds = helper.QueryForDateSet(oArrayList); TransportCheck oYearStockPlan = new TransportCheck(); oYearStockPlan.Source = ds; CReportTools tools = new CReportTools(); DataTable dt = ds.Tables[0]; Decimal money = 0; for (int i = 0; i < dt.Rows.Count; i++) { money += Convert.ToDecimal(dt.Rows[i]["money"]); } oYearStockPlan.SumMoney = tools.ToUpper(money); oYearStockPlan.AccountNum = "3444"; oYearStockPlan.ContractNum = "100086"; oYearStockPlan.CoName = "中百"; oYearStockPlan.Num = "1111"; oYearStockPlan.InvoiceNo = "0001"; oYearStockPlan.Supplier = "中百"; oYearStockPlan.Telephone = "138888888"; oYearStockPlan.Auditor = "刘淼"; oYearStockPlan.Examine = "bbb"; oYearStockPlan.Approve = "ccc"; oYearStockPlan.AuditorYmd = "2008年5月21号"; oYearStockPlan.ExamineYmd = "2008年5月22号"; oYearStockPlan.ApproveYmd = "2008年5月23号"; oYearStockPlan.ShowReport(); }