110,571
社区成员
发帖
与我相关
我的任务
分享
catch(Exception e1)
{
string loadError = e1.ToString();
this.writeLog(loadError);
}
catch(Exception e1)
{
//把错误源和错误发生时的堆栈信息都记录到日志
string loadError = e1.Message+"\r\n"+e1.StackTrace;
this.writeLog(loadError);
}
//脚本里面的,原来开发的人写的
CREATE TABLE [#SyncErrorLog] (
[id] [int] NULL ,
[wNo] [varchar] (10) NULL ,
[pCode] [varchar] (10) NULL ,
[sLoc] [varchar] (10) NULL ,
[sSku] [varchar] (10) NULL ,
[OnHandQty] [int] NULL ,
[UnitFactor] [int] NULL ,
[PickLocation] [varchar] (10) NULL ,
[filter] [varchar] (19) NULL,
[ImportCertNumber] [varchar] (50) NULL,
[CountryOfOrigin] [varchar](3) NULL,
[ErrorDesc] [varchar](100) NULL
) ON [PRIMARY]
--自建的一个表,发生异常时插入错误信息的,因为是循环,所以用了table.
--返回DataSet的原因,应该底层(我看不到了)里面操作数据库的方法
insert into #SyncErrorLog
values(@id,@wNo,@pCode,@sLoc,@sSku,@OnHandQty,@UnitFactor,@PickLocation,@filter,@ImportCertNumber,@CountryOfOrigin,@PRODUCT_ERROR)
xr.WriteEndElement();
errorDS = InventorySynchronizeProcess.InsertSynchronizedData(sb.ToString());
result = true;
ds = dataCommand.ExecuteDataset();
public InventorySynchronizeCtrl()
{
}
//存储过程在这里
<?xml version="1.0" encoding="utf-8" ?>
<DataAccessConfiguration>
<Commands>
<DataCommand Name="OrderManagement.InsertSynchronizedData" HelperAlias="SqlHelper" CommandType="StoredProcedure" CommandTimeout="30">
<CommandText>uspInsertSynchronizedData</CommandText>
<Parameters>
<Parameter Alias="XmlDoc" ParameterName="@sXmlDoc" DbType="String" Direction="Input" />
</Parameters>
<ConnectionString Value="Server=*.*.*.*;UID=sa;PWD=sa;Database=*****;"/>
</DataCommand>
</Commands>
</DataAccessConfiguration>
loadFileCtrl = new InventorySynchronizeCtrl();
succeed = loadFileCtrl.LoadFileByStoreProcedure(fileName,LOGFILE);
//继续
public static DataSet InsertSynchronizedData(string xml)
{
DataSet ds = null;
try
{
using(ConfiguredDataCommand dataCommand = ConfiguredItems.GetDataCommand(CommandPrefix.OrderManagement , CommandName.InsertSynchronizedData))
{
dataCommand.SetParameterValue(CommandParam.XmlDoc , xml);
ds = dataCommand.ExecuteDataset();
}
}
catch (AppException)
{
throw ;
}
catch (Exception ex)
{
throw new SysException(ex.Message);
}
return ds;
}