public NomenclatureElement[] Nomenclature(AuthenticationToken token, string number)
{
//Название поля Тип поля Описание поля
//Username VarChar(20) Пользователь
// Password VarChar(20) Пароль
// Код VarChar(8) Код автозапчасти
//Response
// Название поля 1С Тип поля Описание поля
// Код VarChar(8) Код автозапчасти
//Наименование VarChar(100) Сокращенное наименование автозапчасти
// НаименованиеИностранное VarChar(100) Переведенное наименование
//ПолноеНаименование VarChar(100) Полное наименование автозапчасти
// Артикул VarChar(25) Каталожный номер
//КодЕдИзм VarChar(8) Код единицы измерения
// КодПроизводителя VarChar(8) Код производителя
var user = SecurityHelper.Authorize(token, new [] { SystemRoles.Eurogarage });
using (var ctx = new CubeContext())
{
var r = ctx.vsspGetWaresList(null, null, null, null, null, null, null, null, null, null, null, null,
number, null, null, null, null, null, null,
out _, out _, out _, out _);
return(r.Select(i => new NomenclatureElement
{
Brand = i.ProducerName,
WareName = i.WareName,
WareId = i.WareId,
UnitName = i.UnitShName,
WareNum = i.WareNum
}).ToArray());
}
}
private void TransactionContext(string transCode)
{
Thread.Sleep(6000);
logger.Info("等待6秒，等到浏览器完全加载");
try {
logger.Info("开始获取浏览器对象");
CubeContext cube = autoTestHelper.TransactionContext("", transCode, out string message) as CubeContext;
logger.Info("获取浏览器对象方法的返回值" + cube.ToString());
logger.Info("----------------");
logger.Info(cube.ActivePage);
logger.Info("----------------");
logger.Info(cube.ActiveCubePage);
logger.Info("----------------");
try {
List <object> list = cube.ActiveCubePages;
logger.Info("获取到的交易的页面数" + list.Count);
for (int i = 0; i < list.Count; i++)
{
logger.Info(list[i]);
}
} catch (Exception a) {
logger.Info(a);
}
logger.Info("/////////////");
logger.Info(cube.RootPage);
logger.Info("----------------" + cube.RootPage.Container.Content.Content);
ChromiumWebBrowser chromium = cube.RootPage.Container.Content.Content as ChromiumWebBrowser;
logger.Info("获取到的浏览器对象的地址为" + chromium.Address);
logger.Info("开始执行js");
chromium.ExecuteScriptAsync("alert('11111111111111')");
} catch (Exception e) {
logger.Info("获取浏览器对象时遇到异常" + e);
}
}
public JsonResult <ps_GetRingGroupByCallerIDResult> RingGroup(string userName, string password, string say)
{
var model = new AuthenticationToken
{
UserName = userName,
Password = password
};
var user = SecurityHelper.Authorize(model, new[] { SystemRoles.OkiToki });
using (var ctx = new CubeContext())
{
var r = ctx.GetRingGroupByCallerId(user.Name);
return(Json(r));
//return r.RingGroup;
}
}
public JsonResult <ps_GetRingGroupByCallerIDResult> RingGroup(string userName, string password, string say)
{
var start = DateTime.Now;
var model = new GetRingGroupParamsModel
{
UserName = userName,
Password = password,
Say = say
};
SecurityHelper.Authorize(model, new[] { SystemRoles.OkiToki });
using (var ctx = new CubeContext())
{
var r = ctx.GetRingGroupByCallerId(say);
Log.Debug($"RingGroup for {say} - {(DateTime.Now - start).Milliseconds} ms: {JsonConvert.SerializeObject(r)}");
return(Json(r));
}
}
private Kag[] GetKagList()
{
using (var amCtx = new AutomallContext())
{
var user = amCtx.vsUsers.Include("Presentations").FirstOrDefault(i => i.Login == ((HttpListenerBasicIdentity)Thread.CurrentPrincipal.Identity).Name);
if (user == null)
{
return(null);
}
using (var cubeCtx = new CubeContext())
{
var clients =
cubeCtx.vsspGetClientsInfo(string.Join(",", user.Presentations.Select(i => i.ClientId)), null);
return(clients.Select(i => new Kag {
KagId = i.KagId, KagName = i.KagName
}).ToArray());
}
}
}
public ResponseMessageResult Nomenclature(int kagId, string number)
{
using (var ctx = new CubeContext())
{
var r = ctx.vsspGetWaresList(null, null, null, null, kagId, null, null, null, null, null, null, true,
number, null, null, null, null, null, null,
out _, out _, out _, out _);
var result = r.Select(i => new NomenclatureElement
{
Brand = i.ProducerName,
WareName = i.WareName,
WareId = i.WareId,
UnitName = i.UnitShName,
WareNum = i.WareNum,
Price = i.PriceOut ?? 0,
WareNameRom = i.WareName,
UnitCode = 5
}).ToArray();
return(XmlResponseMessage(result));
}
}
public ResponseMessageResult KagList()
{
using (var ctx = new AutomallContext())
{
var user = ctx.vsUsers.Include("Presentations").FirstOrDefault(i => i.Login == ((HttpListenerBasicIdentity)Thread.CurrentPrincipal.Identity).Name);
if (user == null)
{
return(ResponseMessage(new HttpResponseMessage(HttpStatusCode.Forbidden)));
}
using (var cubeCtx = new CubeContext())
{
var clients =
cubeCtx.vsspGetClientsInfo(string.Join(",", user.Presentations.Select(i => i.ClientId)), null);
var result = clients.Select(i => new Kag {
KagId = i.KagId, KagName = i.KagName
}).ToArray();
return(XmlResponseMessage(result));
}
}
}
private void SetCube(CubeContext cube, string name, string varName)
{
var dq = new DataCube(name, DataStatement.CUBE, varName);
if (cube != null)
{
FilterconditionContext Filtercondition = cube.filtercondition();
SortstatementContext sortStatement = cube.sortstatement();
FieldsContext fs = cube.fields();
AggtypeContext aggtype = cube.aggtype();
dq.CubeStatement = new State.Cube()
{
Aggregate = aggtype.GetText()
};
if (fs != null)
{
string[] s = fs.GetText().Split(',');
for (int i = 0; i < s.Length; i++)
{
dq.CubeStatement.AddField(new State.DataField(s[i], s[i]));
}
}
if (Filtercondition != null)
{
ConditionContext condition = Filtercondition.condition();
var search = new State.Search(condition.children[0].GetText(), condition.children[1].GetText(), condition.children[2].GetText());
dq.CubeStatement.AddCondition(search);
}
if (sortStatement != null)
{
OrderContext order = sortStatement.order();
dq.CubeStatement.AddOrder(new State.SortBy(order.ORDERBY()[0].GetText(), order.fields()[0].GetText()));
}
DataCubes.Add(dq);
}
}
