public virtual StoreDomain CreateStoreDomain() { StoreEntity entity = new StoreEntity(); entity.StoreId = Guid.NewGuid().ToString(); return new StoreDomain(entity); }
public virtual void UpdateStoreEntity(StoreEntity entity, DataAccessBroker broker) { DataAccess.Update(entity, broker); }
public virtual void InsertStoreEntity(StoreEntity entity, DataAccessBroker broker) { DataAccess.Insert(entity, broker); }
public virtual StoreEntity GetStoreByBPStoreSEQ(string bpStoreSEQ) { StoreEntity entity = new StoreEntity(); entity.BpStoreSeq = bpStoreSEQ; Suzsoft.Smart.EntityCore.EntityCollection<StoreEntity> list = new Suzsoft.Smart.EntityCore.EntityCollection<StoreEntity>(); list = DataAccess.Select<StoreEntity>(entity); if (list.Count > 0) return list[0]; else return null; }
public virtual bool MatchStore(StoreEntity entityNew, StoreEntity entityImport, string userId) { int total_success_import = 0; using (DataAccessBroker broker = DataAccessFactory.Instance()) { broker.BeginTransaction(); try { DateTime timeNow = DateTime.Now; entityNew.IsMatched = "Y"; entityNew.MatchDate = timeNow; entityImport.IsMatched = "Y"; entityImport.MatchDate = timeNow; MatchhistoryEntity entity = new MatchhistoryEntity(); entity.MatchedId = Guid.NewGuid().ToString(); entity.StoreIdNew = entityNew.DmsStoreId; entity.DmsIdNew = entityNew.DmsId; entity.StoreIdImport = entityImport.DmsStoreId; entity.DmsIdImport = entityImport.DmsId; entity.IsDeleted = "N"; entity.MatchDate = timeNow; entity.MatchUser = userId; DataAccess.Update(entityNew, broker); DataAccess.Update(entityImport, broker); DataAccess.Insert(entity, broker); broker.Commit(); return true; } catch { broker.RollBack(); return false; } } }
//曾量上传 //1 已经存在的Store更新信息 //2 不存在的Store, 新增 public virtual int StoreUpdateOrInsert(DataTable dtStore, string userId) { int total_success_import = 0; using (DataAccessBroker broker = DataAccessFactory.Instance()) { //broker.BeginTransaction(); try { StoreEntity entity; bool isInsert; foreach (DataRow row in dtStore.Rows) { isInsert = false; try { //如果使用Transaction, 则在执行第二次GetStoreEntityById时 查询超时 //entity = GetStoreEntityById(row[8].ToString().Trim(), row[6].ToString().Trim()); if (row[7].ToString().Trim() != "") { entity = GetStoreByStoreSEQ(row[7].ToString().Trim()); if (entity == null) { isInsert = true; entity = new StoreEntity(); entity.StoreId = Guid.NewGuid().ToString(); } } else if (row[8].ToString().Trim() != "") { entity = GetStoreByBPStoreSEQ(row[8].ToString().Trim()); if (entity == null) { isInsert = true; entity = new StoreEntity(); entity.StoreId = Guid.NewGuid().ToString(); } } else { continue; } #region StoreEntity entity.Division = row[0].ToString().Trim(); entity.Market = row[1].ToString().Trim(); entity.RdId = row[2].ToString().Trim(); entity.SoldToCode = row[3].ToString().Trim(); entity.ShipToCode = row[4].ToString().Trim(); entity.HubName = row[5].ToString().Trim(); entity.DmsId = row[6].ToString().Trim(); entity.StoreSeq = row[7].ToString().Trim(); entity.BpStoreSeq = row[8].ToString().Trim(); entity.DmsStoreId = row[9].ToString().Trim(); entity.StoreName = row[10].ToString().Trim(); entity.StoreCity = row[11].ToString().Trim(); entity.ChannelTypeCode = row[12].ToString().Trim(); entity.StoreTypeCode = row[13].ToString().Trim(); entity.StoreState = row[14].ToString().Trim(); entity.AdrpFlag = row[15].ToString().Trim(); entity.Province = row[16].ToString().Trim(); entity.City = row[17].ToString().Trim(); entity.Village = row[18].ToString().Trim(); entity.Town = row[19].ToString().Trim(); entity.Street = row[20].ToString().Trim(); entity.Doorplate = row[21].ToString().Trim(); entity.Room = row[22].ToString().Trim(); //entity.StoreType = BPSC.Common.StoreType.Import.ToString(); entity.IsDeleted = "N"; #endregion if (isInsert) { entity.CreateDate = DateTime.Now; entity.CreateUser = userId; //entity.IsMatched = "N"; InsertStoreEntity(entity, broker); } else { entity.ModifyDate = DateTime.Now; entity.ModifyUser = userId; UpdateStoreEntity(entity, broker); } total_success_import += 1; } catch(Exception ex) { } } //broker.Commit(); } catch { //broker.RollBack(); } return total_success_import; } }
public virtual StoreEntity GetStoreEntityByIdStoreSeq(string storeSEQ) { //1. 查询Store表中的StoreSEQ //2. 如没查到,则查询BP_Store_SEQ StoreEntity entity = new StoreEntity(); entity.StoreSeq = storeSEQ; StoreEntity sEntity = DataAccess.SelectSingle<StoreEntity>(entity); if (sEntity == null) { entity = new StoreEntity(); entity.BpStoreSeq = storeSEQ; sEntity = DataAccess.SelectSingle<StoreEntity>(entity); } return sEntity; }
//public virtual List<ChkFunctionParamEntity> GetChkFunctionParasByFunctionId(string functionId) //{ // return SelectByCondition<ChkFunctionParamEntity>(adidas.DataCollection.Common.Utils.QueryCondition.Create().Equals(ChkFunctionParamTable.C_FUNCTION_ID, functionId).Order(ChkFunctionParamTable.C_SORT_ORDER)); //} //public virtual void InsertChkFUnctionParas(List<ChkFunctionParamEntity> functionParas, DataAccessBroker broker) //{ // DataAccess.Insert(functionParas, broker); //} //public virtual void DeleteChkFunctionParasByCondition(ChkFunctionParamEntity param, DataAccessBroker broker) //{ // DataAccess.DeleteEntity(param, broker); //} public virtual StoreEntity GetStoreEntityById(string storeID, string dmsID) { StoreEntity entity = new StoreEntity(); entity.DmsStoreId = storeID; entity.DmsId = dmsID; Suzsoft.Smart.EntityCore.EntityCollection<StoreEntity> list = new Suzsoft.Smart.EntityCore.EntityCollection<StoreEntity>(); list = DataAccess.Select<StoreEntity>(entity); if (list.Count > 0) return list[0]; else return null; }
private StoreEntity GetEntity() { //获取Store信息,用于更新 StoreEntity objEntity; //if (!string.IsNullOrEmpty(StoreId) && !string.IsNullOrEmpty(DMSID)) if (!string.IsNullOrEmpty(StoreId)) { objEntity = MainService.StoreBLLService.GetStoreEntityById(StoreId); } else { objEntity = new StoreEntity(); objEntity.StoreId = Guid.NewGuid().ToString(); } objEntity.StoreSeq = txtSTORE_SEQ.Text.Trim(); objEntity.BpStoreSeq = txtBPSTORESEQ.Text.Trim(); objEntity.DmsStoreId = txtStoreID.Text.Trim(); objEntity.DmsId = txtDMSID.Text.Trim(); objEntity.StoreName = txtStoreName.Text; objEntity.Division = txtDIVISION.Text; objEntity.Market = txtMARKET.Text; objEntity.RdId = txtRD_ID.Text; objEntity.SoldToCode = txtSOLD_TO_CODE.Text; objEntity.ShipToCode = txtSHIP_TO_CODE.Text; objEntity.HubName = txtHUB_NAME.Text; objEntity.StoreCity = txtSTORE_CITY.Text; objEntity.ChannelTypeCode = txtCHANNEL_TYPE_CODE.Text; objEntity.StoreTypeCode = txtSTORE_TYPE_CODE.Text; objEntity.StoreState = txtSTORE_STATE.Text; objEntity.AdrpFlag = txtADRP_FLAG.Text; objEntity.Province = txtPROVINCE.Text; objEntity.City = txtCITY.Text; objEntity.Village = txtVILLAGE.Text; objEntity.Town = txtTOWN.Text; objEntity.Street = txtSTREET.Text; objEntity.Doorplate = txtDOORPLATE.Text; objEntity.Room = txtROOM.Text; return objEntity; }
/// <summary> /// Set entity data /// </summary> private void SetEntity(StoreEntity objEntity) { txtSTORE_SEQ.Text = objEntity.StoreSeq; txtBPSTORESEQ.Text = objEntity.BpStoreSeq; if (objEntity.StoreSeq.Trim() != "") { txtBPSTORESEQ.Enabled = false; } txtStoreID.Text = objEntity.DmsStoreId; txtDMSID.Text = objEntity.DmsId; txtStoreName.Text = objEntity.StoreName; txtDIVISION.Text = objEntity.Division; txtMARKET.Text = objEntity.Market; txtRD_ID.Text = objEntity.RdId; txtSOLD_TO_CODE.Text = objEntity.SoldToCode; txtSHIP_TO_CODE.Text = objEntity.ShipToCode; txtHUB_NAME.Text = objEntity.HubName; txtSTORE_CITY.Text = objEntity.StoreCity; txtCHANNEL_TYPE_CODE.Text = objEntity.ChannelTypeCode; txtSTORE_TYPE_CODE.Text = objEntity.StoreTypeCode; txtSTORE_STATE.Text = objEntity.StoreState; txtADRP_FLAG.Text = objEntity.AdrpFlag; txtPROVINCE.Text = objEntity.Province; txtCITY.Text = objEntity.City; txtVILLAGE.Text = objEntity.Village; txtTOWN.Text = objEntity.Town; txtSTREET.Text = objEntity.Street; txtDOORPLATE.Text = objEntity.Doorplate; txtROOM.Text = objEntity.Room; //ddlStoreType.SelectedValue = objEntity.StoreType; //ddlIsMatched.SelectedValue = objEntity.IsMatched; }
public StoreDomain(StoreEntity entity) : base(entity) { masterEntity = entity; }