public void AddImportItem(string itemId, string groupId, string operatorUserId, string operatorUserName , string fromItemIid, string fromItemTitle, string fromItemPrice, string fromSellerNick, string fromShopTitle, string userId) { ImportItem itemEntity = new ImportItem(); itemEntity.Id = itemId; itemEntity.OperatorUserId = operatorUserId; itemEntity.OperatorUserName = operatorUserName; itemEntity.ItsImportGroupId = groupId; itemEntity.ImportFormItemIid = fromItemIid; itemEntity.ImportFormItemTitle = fromItemTitle; itemEntity.ImportFormItemPrice = fromItemPrice; itemEntity.ImportFormSellerNick = fromSellerNick; itemEntity.ImportFormShopTitle = fromShopTitle; itemEntity.ImportState = ImportorEnumerations.ImportState.Waitting; itemEntity.ImportResult = ImportorEnumerations.ImportItemResult.Pending; itemEntity.ListDateTime = DateTime.Now; itemEntity.StartDateTime = null; itemEntity.FinishDateTime = null; itemEntity.CreateDate = DateTime.Now; itemEntity.CreateUserId = userId; itemEntity.LastUpdateDate = DateTime.Now; itemEntity.LastUpdateUserId = userId; ImportItemManager itemManager = new ImportItemManager(); string sqlCreateItem = itemManager.GetCreateSql(itemEntity); using (DbOperator dbOperator = new DbOperator(ConnString)) { try { dbOperator.BeginTran(); dbOperator.ExecSql(sqlCreateItem); dbOperator.CommintTran(); } catch (Exception ex) { dbOperator.RollbackTran(); throw new FacadeException("添加导入项发生异常 - ", ex); } } }
public void StartImportItem(string itemId, int version, string userId) { ImportItem itemEntity = new ImportItem(); itemEntity.Id = itemId; itemEntity.ImportState = ImportorEnumerations.ImportState.Importing; itemEntity.StartDateTime = DateTime.Now; itemEntity.LastUpdateDate = DateTime.Now; itemEntity.LastUpdateUserId = userId; itemEntity.CurrentVersion = version; ImportItemManager manager = new ImportItemManager(); string sqlUpdateItem = manager.GetUpdateSql(itemEntity, "ImportState", "StartDateTime"); #region 执行SQL以修改对象 using (DbOperator dbOperator = new DbOperator(ConnString)) { try { dbOperator.BeginTran(); dbOperator.ExecSql(sqlUpdateItem); dbOperator.CommintTran(); } catch (Exception ex) { dbOperator.RollbackTran(); throw new FacadeException("启动导入宝贝发生异常 - ", ex); } } #endregion }
public void FinishImportItem(string groupId, int groupVersion, string itemId, int itemVersion , ImportorEnumerations.ImportItemResult result , string toItemIid, string toItemTitle, string toItemPrice, string toSellerNick, string toShopTitle , int successCount, int failCount, string message, string userId) { ImportGroup groupEntity = new ImportGroup(); groupEntity.Id = groupId; groupEntity.SuccessCount = successCount; groupEntity.FailCount = failCount; groupEntity.LastUpdateDate = DateTime.Now; groupEntity.LastUpdateUserId = userId; groupEntity.CurrentVersion = groupVersion; ImportGroupManager managerGroup = new ImportGroupManager(); string sqlUpdateGroup = managerGroup.GetUpdateSql(groupEntity, "SuccessCount", "FailCount"); ImportItem itemEntity = new ImportItem(); itemEntity.Id = itemId; itemEntity.ImportState = ImportorEnumerations.ImportState.Finished; itemEntity.ImportResult = result; itemEntity.FinishDateTime = DateTime.Now; itemEntity.ImportToItemIid = toItemIid; itemEntity.ImportToItemTitle = toItemTitle; itemEntity.ImportToItemPrice = toItemPrice; itemEntity.ImportToSellerNick = toSellerNick; itemEntity.ImportToShopTitle = toShopTitle; itemEntity.ResultMessage = message; itemEntity.LastUpdateDate = DateTime.Now; itemEntity.LastUpdateUserId = userId; itemEntity.CurrentVersion = itemVersion; ImportItemManager managerItem = new ImportItemManager(); string sqlUpdateItem = managerItem.GetUpdateSql(itemEntity , "ImportState" , "ImportResult" , "FinishDateTime" , "ImportToItemIid" , "ImportToItemTitle" , "ImportToItemPrice" , "ImportToSellerNick" , "ImportToShopTitle" , "ResultMessage"); #region 执行SQL以修改对象 using (DbOperator dbOperator = new DbOperator(ConnString)) { try { dbOperator.BeginTran(); dbOperator.ExecSql(sqlUpdateGroup); dbOperator.ExecSql(sqlUpdateItem); dbOperator.CommintTran(); } catch (Exception ex) { dbOperator.RollbackTran(); throw new FacadeException("结束导入宝贝发生异常 - ", ex); } } #endregion }