public void Save()
{
if (Glob.IsDebugMode)
return;
if (id == null)
SqlMapperExtensions.Insert(CnnMySQL, this, TranMySQL);
else
SqlMapperExtensions.Update(CnnMySQL, this, TranMySQL);
WHTotal WHTotal = WHTotal.LoadMySQL(CnnMySQL, ItemNo, Warehouse);
if (WHTotal == null)
{
WHTotal = new WHTotal();
Item Item = Item.Load(ItemNo);
WHTotal.ItemNo = ItemNo;
if (Item != null)
{
WHTotal.ItemName = Item.ItemName;
WHTotal.ItemType = Item.ItemType;
}
else
{
WHTotal.ItemName = ItemName;
WHTotal.ItemType = ItemType;
}
WHTotal.Warehouse = Warehouse;
}
WHTotal.CnnMySQL = CnnMySQL;
WHTotal.Save();
}
public static WHTotal LoadExchange(string ItemNo)
{
Logger.For(typeof(WHTotal)).Info(string.Format("开始. 编码 : {0}", ItemNo));
ADODB.Connection Cnn = ServerHelper.ConnectExchange(SZInvPath);
ADODB.Record Rst = new ADODB.Record();
WHTotal WHTotal = new WHTotal();
try
{
Rst.Open(string.Format("{0}{1}.eml", SZInvPath, ItemNo), Cnn, ADODB.ConnectModeEnum.adModeReadWrite, ADODB.RecordCreateOptionsEnum.adOpenIfExists, ADODB.RecordOpenOptionsEnum.adDelayFetchFields, "namwah", "ParaW0rld");
WHTotal.InitFromExchange(Rst);
Logger.For(typeof(WHTotal)).Info(string.Format("结束. 编码 : {0}", ItemNo));
}
catch (Exception ex)
{
Logger.For(typeof(WHTotal)).Error(string.Format("编码 {0} : 原因 : {1}.", ItemNo, ex.Message));
return null;
}
return WHTotal;
}