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;
}
