U8 更新现存量

////更新现存量
//1、相同存在在CurrentStock 中使用的是同一个ItemId
//2、写入时注意批次号
//3、如果启用货位管理，需要在MainBatch表中更新相应货位的存货
			querystr="select itemid from currentstock with(nolock) where cinvcode='"+业务数据记录.getitem(i, "存货编号")+"'";
			data.setSqlselect(querystr);
			rows = data.retrieve();
			if(rows<=0)
			{
				///
				long itemid=0;
				querystr="select max(itemid) from currentstock";
				data.setSqlselect(querystr);
				rows = data.retrieve();
				if(rows<=0)
				{
					itemid = 1;
				}else
				{
					String s_item="";
					if("".equals(data.getitem(0,0)))
					{
						s_item ="0";
					}else
					{
						s_item=data.getitem(0,0);
					}
					itemid = Long.valueOf(s_item)+1;
				}
				////取最大值插入即可
				DbHelper helperstore = new DbHelper("currentstock");
				helperstore.addSqls(new SqlObject("cWhCode",仓库,"字符串"));
				helperstore.addSqls(new SqlObject("cInvCode",业务数据记录.getitem(i, "存货编号"),"字符串"));
				helperstore.addSqls(new SqlObject("ItemId",String.valueOf(itemid),"字符串"));
				helperstore.addSqls(new SqlObject("cBatch",业务数据记录.getitem(i, "LOT"),"字符串"));
				helperstore.addSqls(new SqlObject("iSoType","0","字符串"));
				helperstore.addSqls(new SqlObject("iQuantity",业务数据记录.getitem(i, "数量"),"字符串"));
				helperstore.addSqls(new SqlObject("fOutQuantity","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("fOutNum","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("fInQuantity","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("fInNum","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("bStopFlag","0","字符串"));
				helperstore.addSqls(new SqlObject("fTransInQuantity","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("fTransInNum","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("fTransOutQuantity","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("fTransOutNum","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("fPlanQuantity","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("fPlanNum","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("fDisableQuantity","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("fDisableNum","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("fAvaQuantity","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("fAvaNum","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("BGSPSTOP","0","字符串"));
				helperstore.addSqls(new SqlObject("fStopQuantity","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("fStopNum","0.000000","字符串"));
				//helperstore.addSqls(new SqlObject("iExpiratDateCalcu","0","字符串"));
				helperstore.addSqls(new SqlObject("ipeqty","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("ipenum","0.000000","字符串"));
				helperstore.addSqls(new SqlObject("isodid","","字符串"));
				helperstore.addSqls(new SqlObject("cmassunit","","NULL"));
				helperstore.addSqls(new SqlObject("iexpiratdatecalcu","","NULL"));
				
				sqlstr = helperstore.getInsertSqltext();
				SqlHelper.ExecuteNonQuery(ufsqltrans, CommandType.Text,sqlstr);
			}else
			{
				///检查是否存在同一仓库，存货，批次的情况
					
				long itemid = Long.valueOf(data.getitem(0,0));
				querystr="select autoid from currentstock where cInvCode='"+业务数据记录.getitem(i, "存货编号")+"' and cWhCode='"+仓库+"' and cbatch='"+业务数据记录.getitem(i, "LOT")+"'";
				data.setSqlselect(querystr);
				rows = data.retrieve(); 
				if(rows<=0)
				{
					DbHelper helperstore = new DbHelper("currentstock");
					helperstore.addSqls(new SqlObject("cWhCode",仓库,"字符串"));
					helperstore.addSqls(new SqlObject("cInvCode",业务数据记录.getitem(i, "存货编号"),"字符串"));
					helperstore.addSqls(new SqlObject("ItemId",String.valueOf(itemid),"字符串"));
					helperstore.addSqls(new SqlObject("cBatch",业务数据记录.getitem(i, "LOT"),"字符串"));
					helperstore.addSqls(new SqlObject("iSoType","0","字符串"));
					helperstore.addSqls(new SqlObject("iQuantity",业务数据记录.getitem(i, "数量"),"字符串"));
					helperstore.addSqls(new SqlObject("fOutQuantity","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("fOutNum","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("fInQuantity","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("fInNum","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("bStopFlag","0","字符串"));
					helperstore.addSqls(new SqlObject("fTransInQuantity","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("fTransInNum","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("fTransOutQuantity","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("fTransOutNum","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("fPlanQuantity","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("fPlanNum","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("fDisableQuantity","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("fDisableNum","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("fAvaQuantity","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("fAvaNum","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("BGSPSTOP","0","字符串"));
					helperstore.addSqls(new SqlObject("cMassUnit","0","字符串"));
					helperstore.addSqls(new SqlObject("fStopQuantity","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("fStopNum","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("iExpiratDateCalcu","0","字符串"));
					helperstore.addSqls(new SqlObject("ipeqty","0.000000","字符串"));
					helperstore.addSqls(new SqlObject("ipenum","0.000000","字符串"));
					sqlstr = helperstore.getInsertSqltext();
					SqlHelper.ExecuteNonQuery(ufsqltrans, CommandType.Text,sqlstr);
				}else
				{
					String ls_sql = "update currentstock set iQuantity =isnull(iQuantity,0)+"+业务数据记录.getitem(i, "数量")+" where autoid="+data.getitem(0,0);
					SqlHelper.ExecuteNonQuery(ufsqltrans, CommandType.Text,ls_sql);
				}
			}
			

　　

////更新现存量querystr="select itemid from currentstock with(nolock) where cinvcode='"+业务数据记录.getitem(i, "存货编号")+"'";data.setSqlselect(querystr);rows = data.retrieve();if(rows<=0){///long itemid=0;querystr="select max(itemid) from currentstock";data.setSqlselect(querystr);rows = data.retrieve();if(rows<=0){itemid = 1;}else{String s_item="";if("".equals(data.getitem(0,0))){s_item ="0";}else{s_item=data.getitem(0,0);}itemid = Long.valueOf(s_item)+1;}////取最大值插入即可DbHelper helperstore = new DbHelper("currentstock");helperstore.addSqls(new SqlObject("cWhCode",仓库,"字符串"));helperstore.addSqls(new SqlObject("cInvCode",业务数据记录.getitem(i, "存货编号"),"字符串"));helperstore.addSqls(new SqlObject("ItemId",String.valueOf(itemid),"字符串"));helperstore.addSqls(new SqlObject("cBatch",业务数据记录.getitem(i, "LOT"),"字符串"));helperstore.addSqls(new SqlObject("iSoType","0","字符串"));helperstore.addSqls(new SqlObject("iQuantity",业务数据记录.getitem(i, "数量"),"字符串"));helperstore.addSqls(new SqlObject("fOutQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fOutNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("fInQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fInNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("bStopFlag","0","字符串"));helperstore.addSqls(new SqlObject("fTransInQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fTransInNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("fTransOutQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fTransOutNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("fPlanQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fPlanNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("fDisableQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fDisableNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("fAvaQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fAvaNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("BGSPSTOP","0","字符串"));helperstore.addSqls(new SqlObject("fStopQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fStopNum","0.000000","字符串"));//helperstore.addSqls(new SqlObject("iExpiratDateCalcu","0","字符串"));helperstore.addSqls(new SqlObject("ipeqty","0.000000","字符串"));helperstore.addSqls(new SqlObject("ipenum","0.000000","字符串"));helperstore.addSqls(new SqlObject("isodid","","字符串"));helperstore.addSqls(new SqlObject("cmassunit","","NULL"));helperstore.addSqls(new SqlObject("iexpiratdatecalcu","","NULL"));sqlstr = helperstore.getInsertSqltext();SqlHelper.ExecuteNonQuery(ufsqltrans, CommandType.Text,sqlstr);}else{///检查是否存在同一仓库，存货，批次的情况long itemid = Long.valueOf(data.getitem(0,0));querystr="select autoid from currentstock where cInvCode='"+业务数据记录.getitem(i, "存货编号")+"' and cWhCode='"+仓库+"' and cbatch='"+业务数据记录.getitem(i, "LOT")+"'";data.setSqlselect(querystr);rows = data.retrieve(); if(rows<=0){DbHelper helperstore = new DbHelper("currentstock");helperstore.addSqls(new SqlObject("cWhCode",仓库,"字符串"));helperstore.addSqls(new SqlObject("cInvCode",业务数据记录.getitem(i, "存货编号"),"字符串"));helperstore.addSqls(new SqlObject("ItemId",String.valueOf(itemid),"字符串"));helperstore.addSqls(new SqlObject("cBatch",业务数据记录.getitem(i, "LOT"),"字符串"));helperstore.addSqls(new SqlObject("iSoType","0","字符串"));helperstore.addSqls(new SqlObject("iQuantity",业务数据记录.getitem(i, "数量"),"字符串"));helperstore.addSqls(new SqlObject("fOutQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fOutNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("fInQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fInNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("bStopFlag","0","字符串"));helperstore.addSqls(new SqlObject("fTransInQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fTransInNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("fTransOutQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fTransOutNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("fPlanQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fPlanNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("fDisableQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fDisableNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("fAvaQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fAvaNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("BGSPSTOP","0","字符串"));helperstore.addSqls(new SqlObject("cMassUnit","0","字符串"));helperstore.addSqls(new SqlObject("fStopQuantity","0.000000","字符串"));helperstore.addSqls(new SqlObject("fStopNum","0.000000","字符串"));helperstore.addSqls(new SqlObject("iExpiratDateCalcu","0","字符串"));helperstore.addSqls(new SqlObject("ipeqty","0.000000","字符串"));helperstore.addSqls(new SqlObject("ipenum","0.000000","字符串"));sqlstr = helperstore.getInsertSqltext();SqlHelper.ExecuteNonQuery(ufsqltrans, CommandType.Text,sqlstr);}else{String ls_sql = "update currentstock set iQuantity =isnull(iQuantity,0)+"+业务数据记录.getitem(i, "数量")+" where autoid="+data.getitem(0,0);SqlHelper.ExecuteNonQuery(ufsqltrans, CommandType.Text,ls_sql);}}