private static List <MenuItem> _GetMenuItemList()
{
string menuPath = Path.Combine(Directory.GetCurrentDirectory(), "Configuration/Menu.config");
m_MenuItemList = SerializationUtility.LoadFromXml <List <MenuItem> >(menuPath);
if (m_MenuItemList == null)
{
m_MenuItemList = new List <MenuItem>();
}
return(m_MenuItemList);
}
public KeystoneAuthDataV41 GetAuthData(DefaultDataContract msg)
{
string filePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "MockDataForKeystoneAuth.xml");
if (!File.Exists(filePath))
{
throw new FileNotFoundException(filePath);
}
KeystoneAuthDataV41 serviceResult = SerializationUtility.LoadFromXml <KeystoneAuthDataV41>(filePath);
return(serviceResult);
}
/// <summary>
/// 更新商品发送状态
/// </summary>
/// <param name="sysNo"></param>
/// <returns></returns>
public static bool UpdateProductStatus(int sysNo)
{
var successSysNos = SerializationUtility.LoadFromXml <List <SuccessLog> >(s_SendSuccessProductDataFile);
if (successSysNos.FirstOrDefault(t => t.ProductSysNo == sysNo) == null)
{
successSysNos.Add(new SuccessLog()
{
ProductSysNo = sysNo, CreateTime = DateTime.Now
});
SerializationUtility.SaveToXml(s_SendSuccessProductDataFile, successSysNos);
}
return(true);
//DataCommand cmd = DataCommandManager.GetDataCommand("UpdateProductStatus");
//cmd.SetParameterValue("@SysNo", sysNo);
//return cmd.ExecuteNonQuery() > 0;
}
/// <summary>
/// 查询商品信息
/// </summary>
/// <returns></returns>
public static List <ProductInfo> QueryProduct()
{
var successSysNos = SerializationUtility.LoadFromXml <List <SuccessLog> >(s_SendSuccessProductDataFile);
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryProduct");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd))
{
if (successSysNos.Count > 0)
{
var sysNos = string.Format("({0})", string.Join(",", successSysNos.Select(t => t.ProductSysNo.ToString()).ToArray()));
sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, string.Format(@"p.SysNo NOT IN " + sysNos));
}
//增加报关成功条件
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pcei.EntryStatusEx", DbType.Int32, "@EntryStatusEx", QueryConditionOperatorType.Equal, 3);
//增加备案成功条件
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pcei.EntryStatus", DbType.Int32, "@EntryStatus", QueryConditionOperatorType.Equal, 4);
//添加过滤直邮商品
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pe.ProductTradeType", DbType.Int32, "@ProductTradeType", QueryConditionOperatorType.Equal, 1);
cmd.CommandText = sqlBuilder.BuildQuerySql();
}
return(cmd.ExecuteEntityList <ProductInfo>());
}
DataFeedTemplate BulidTemplate(int c3SysNo, string c3Name)
{
string configPath = Path.Combine(
AppDomain.CurrentDomain.SetupInformation.ApplicationBase
, AppSettingHelper.Get("DataFeedFilesConfigPath")
);
m_dataFeed = SerializationUtility.LoadFromXml <DataFeedFileMapping>(configPath).Mappings[0];
DataFeedTemplate template = new DataFeedTemplate();
template.C3Name = c3Name;
template.C3SysNo = c3SysNo;
template.C3RowIndex = int.Parse(m_dataFeed.C3RowIndex);
//填充列分组信息
template.HeaderGroups = new List <HeaderGroup>();
foreach (var item in m_dataFeed.HeaderGroups)
{
template.HeaderGroups.Add(item);
}
template.BasicColumns = BuildBasicColumns(c3SysNo);
var list = ExternalDomainBroker.GetCategoryPropertyByCategorySysNo(c3SysNo);
if (list != null)
{
template.Properties = new List <DataFeedColumn>();
var activeList = list.Where(p => p.Property.Status == PropertyStatus.Active);
if (activeList.Count() > 0)
{
var propertySysNoList = activeList.Select(p => p.Property.SysNo.Value).ToList();
var propertyValues = ExternalDomainBroker.GetPropertyValueInfoByPropertySysNoList(propertySysNoList);
foreach (var item in activeList)
{
DataFeedColumn column = new DataFeedColumn();
column.Number = item.Property.SysNo.Value;
// item.PropertyType == "D"? 没有这个属性？
if (item.PropertyType == PropertyType.Grouping)
{
column.Name = string.Format("{0}_列表", item.Property.PropertyName.Content);
}
else
{
column.Name = item.Property.PropertyName.Content;
}
column.Type = DataType.LIST;
column.Width = column.Name.Length;
if (item.IsMustInput == CategoryPropertyStatus.Yes)
{
column.IsMustInput = true;
}
else
{
column.IsMustInput = false;
}
if (item.IsInAdvSearch == CategoryPropertyStatus.Yes)
{
column.IsInAdvSearch = true;
}
column.List = new List <string>();
var propertyList = propertyValues.FirstOrDefault(p => p.Key == item.Property.SysNo.Value).Value;
if (propertyList != null)
{
foreach (var value in propertyList.Where(p => p.PropertyInfo.Status == PropertyStatus.Active))
{
column.List.Add(value.ValueDescription.Content);
}
}
template.Properties.Add(column);
//分组属性需要多加一列
// item.PropertyType == "D"? 没有这个属性？
if (item.PropertyType == PropertyType.Grouping)
{
column = new DataFeedColumn();
column.Name = string.Format("{0}_自定义", item.Property.PropertyName.Content);
column.Width = column.Name.Length;
column.Type = DataType.TEXT_LENGTH;
template.Properties.Add(column);
}
//HACK:Bob.H.Li 如果Item.Type==G，那么添加一列“是否分组属性”
if (item.PropertyType == PropertyType.Grouping)
{
column = new DataFeedColumn();
column.Number = template.Properties.Count;
column.Name = DataFeedConstString.EXCEL_ADDSELECTGROUPSTRING;
column.Width = column.Name.Length;
column.Type = DataType.LIST;
column.List = new List <string>()
{
GroupPropertyType.OnlyGroupText,
GroupPropertyType.OnlyGroupPicture,
GroupPropertyType.GroupAggregationText,
GroupPropertyType.GroupAggregationPicture
};
template.Properties.Add(column);
}
}
}
}
return(template);
}