void RenderMenuItem(IsoLayerModel data, GameObject parent, Layer belongLayer)
{
for (int i = 0; i < data.FactoryModel.Count; i++)
{
GameObject item = new GameObject("item");
ImportItemManager.AddRightClickEvent(item);
// Add image component.
Image imgItem = item.AddComponent <Image> ();
string url = data.FactoryModel [i].filePath;
Vector2 offset = data.FactoryModel [i].offset;
Sprite result = resources.Find(x => x.path == url).Sprite;
result = Ultils.ChangeOffset(result, offset);
imgItem.sprite = result;
AddRatioFitter(item, imgItem);
SetItemParent(parent, item);
IsoObjectFactory factory = item.AddComponent <IsoObjectFactory> ();
factory.FilePath = url;
factory.offset = offset;
belongLayer.isoFactories.Add(factory);
UnityEngine.UI.Button btnItem = item.AddComponent <UnityEngine.UI.Button> ();
btnItem.onClick.AddListener(() => {
ImportItemManager.loadedImage = btnItem.image.sprite;
IsoObjectFactory.instance = factory;
belongLayer.NewObject();
});
}
}
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 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 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
}
// Use this for initialization
void Awake()
{
instance = this;
Global.importItemManager = this;
}
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
}
