void Start()
{
// STEP 1
// Gradient is set directly on the object
var mountainTerrain = new RidgedMultifractal();
RenderAndSetImage(mountainTerrain);
// Stop rendering if we're only getting as far as this tutorial
// step. It saves me from doing multiple files.
if (_tutorialStep <= 1) return;
// STEP 2
var baseFlatTerrain = new Billow();
baseFlatTerrain.Frequency = 2.0;
RenderAndSetImage(baseFlatTerrain);
if (_tutorialStep <= 2) return;
// STEP 3
var flatTerrain = new ScaleBias(0.125, -0.75, baseFlatTerrain);
RenderAndSetImage(flatTerrain);
if (_tutorialStep <= 3) return;
// STEP 4
var terrainType = new Perlin();
terrainType.Frequency = 0.5;
terrainType.Persistence = 0.25;
var finalTerrain = new Select(flatTerrain, mountainTerrain, terrainType);
finalTerrain.SetBounds(0, 1000);
finalTerrain.FallOff = 0.125;
RenderAndSetImage(finalTerrain);
}
public void Exec_AggregateMax()
{
const double expected = 100.00;
// overload #1
double result = new
Select(Aggregate.Max("UnitPrice"))
.From(Product.Schema)
.ExecuteScalar<double>();
Assert.AreEqual(expected, result);
// overload #2
result = new
Select(Aggregate.Max(Product.UnitPriceColumn))
.From(Product.Schema)
.ExecuteScalar<double>();
Assert.AreEqual(expected, result);
// overload #3
result = new
Select(Aggregate.Max("UnitPrice", "MostExpensive"))
.From(Product.Schema)
.ExecuteScalar<double>();
Assert.AreEqual(expected, result);
// overload #4
result = new
Select(Aggregate.Max(Product.UnitPriceColumn, "MostExpensive"))
.From(Product.Schema)
.ExecuteScalar<double>();
Assert.AreEqual(expected, result);
}
//databind to total orders by eta and company id
protected void bind_chart(Int32 companyid)
{
try
{
int _countopen = 0;
//total open orders for this company or total open orders for company = -1
if (companyid > -1)
{
_countopen = new Select(OrderTable.OrderIDColumn).From<OrderTable>().Where(OrderTable.CompanyIDColumn).IsEqualTo(companyid).
And(OrderTable.JobClosedColumn).IsEqualTo(false).GetRecordCount();
}
else
{
_countopen = new Select(OrderTable.OrderIDColumn).From<OrderTable>().Where(OrderTable.JobClosedColumn).IsEqualTo(false).GetRecordCount();
}
//bind to gauge
this.dxgaugeSumopen.Value = _countopen.ToString();
}
catch (Exception ex)
{
this.dxlblerr1.Text = ex.Message.ToString();
this.dxlblerr1.Visible = true;
}
}
protected void FillElement(IWebElement element, object value)
{
if (value == null)
{
return;
}
if (IsInput(element))
{
String inputType = element.GetAttribute("type");
if (inputType == null || inputType == TextInputType || inputType == PasswordInputType)
{
element.SendKeys(value.ToString());
}
else if (inputType == CheckboxType)
{
CheckBox checkBox = new CheckBox(element);
checkBox.Set(bool.Parse(value.ToString()));
}
else if (inputType == RadioType)
{
Radio radio = new Radio(element);
radio.SelectByValue(value.ToString());
}
}
else if (IsSelect(element))
{
Select select = new Select(element);
select.SelectByValue(value.ToString());
}
else if (IsTextArea(element))
{
element.SendKeys(value.ToString());
}
}
public SelectionElement(string myAlias, Select.EdgeList myEdgeList, bool myIsGroupedOrAggregated, IDChainDefinition myRelatedIDChainDefinition, IAttributeDefinition myElement = null)
: this(myAlias, myRelatedIDChainDefinition)
{
EdgeList = myEdgeList;
IsGroupedOrAggregated = myIsGroupedOrAggregated;
Element = myElement;
}
public Delete(string table, Select select, bool allowMultiple)
{
Table.Name = table;
AllowMultiple = allowMultiple;
Select = select;
Filter = FilterType.Select;
}
// Use this for initialization
void Start()
{
IModule mountainTerrain = new RidgedMulti();
IModule baseFlatTerrain = new Billow();
((Billow)baseFlatTerrain).Frequency = 2.0;
IModule flatTerrain = new ScaleBias(baseFlatTerrain, 0.125, -0.75);
IModule terrainType = new Perlin();
((Perlin)terrainType).Frequency = 0.5;
((Perlin)terrainType).Persistence = 0.25;
IModule terrainSelector = new Select(flatTerrain, mountainTerrain, terrainType);
((Select)terrainSelector).SetBounds(0.0, 1000.0);
((Select)terrainSelector).SetEdgeFallOff(0.125);
IModule finalTerrain = new Turbulence(terrainSelector);
((Turbulence)finalTerrain).Frequency = 4.0;
((Turbulence)finalTerrain).Power = 0.125;
NoiseMapBuilderPlane heightMapBuilder = new NoiseMapBuilderPlane(256, 256);
heightMapBuilder.SetBounds(6.0, 10.0, 1.0, 5.0);
heightMapBuilder.Build(finalTerrain);
RendererImage render = new RendererImage();
render.SourceNoiseMap = heightMapBuilder.Map;
render.ClearGradient ();
render.AddGradientPoint(-1.0000, new Color32(32, 160, 0, 255));
render.AddGradientPoint(-0.2500, new Color32(224, 224, 0, 255));
render.AddGradientPoint(0.2500, new Color32(128, 128, 128, 255));
render.AddGradientPoint(1.0000, new Color32(255, 255, 255, 255));
render.IsLightEnabled = true;
render.LightContrast = 3.0;
render.LightBrightness = 2.0;
render.Render();
tex = render.GetTexture();
}
public void Exec_AggregateAvg()
{
const double expected = 55.5922077922078; //55.5922;
// overload #1
double result = new
Select(Aggregate.Avg("UnitPrice"))
.From(Product.Schema)
.ExecuteScalar<double>();
//Assert.AreEqual(expected, result);
Assert.AreEqual(Math.Round(expected, 8), Math.Round(result, 8)); // [[55.5922]]!=[[55.5922077922078]]
// overload #2
result = new
Select(Aggregate.Avg(Product.UnitPriceColumn))
.From(Product.Schema)
.ExecuteScalar<double>();
//Assert.AreEqual(expected, result);
Assert.AreEqual(Math.Round(expected, 8), Math.Round(result, 8));
// overload #3
result = new
Select(Aggregate.Avg("UnitPrice", "AverageUnitPrice"))
.From(Product.Schema)
.ExecuteScalar<double>();
//Assert.AreEqual(expected, result);
Assert.AreEqual(Math.Round(expected, 8), Math.Round(result, 8));
// overload #4
result = new
Select(Aggregate.Avg(Product.UnitPriceColumn, "AverageUnitPrice"))
.From(Product.Schema)
.ExecuteScalar<double>();
//Assert.AreEqual(expected, result);
Assert.AreEqual(Math.Round(expected, 8), Math.Round(result, 8));
}
// Use this for initialization
void Start()
{
posicionAPuntador = new Vector3 (transform.position.x,transform.position.y+5,0);
seleccionador = new Select ();
seleccionador = GameObject.FindGameObjectWithTag("Select").GetComponent<Select>();
escogido = false;
}
private bool BarcodeExist()
{
try
{
int count = 1;
switch (SysPara.AutoGenerateBarcode)
{
case 0:
case 1:
count = new Select().From(TTestInfo.Schema).Where(TTestInfo.Columns.Barcode).IsEqualTo(txtBarcode.Text.Trim()).
And(TTestInfo.Columns.PatientId).IsNotEqualTo(vPatient_ID).GetRecordCount();
break;
case 2:
count = new Select().From(TTestInfo.Schema).Where(TTestInfo.Columns.TestTypeId).IsEqualTo(vTestType_ID).
And(TTestInfo.Columns.Barcode).IsEqualTo(txtBarcode.Text.Trim()).GetRecordCount();
break;
}
if (count > 0) return true;
else return false;
}
catch (Exception ex)
{
return true;
}
}
public void Acc_Exec_AggregateAvg()
{
const double expected = 28.8664;
// overload #1
double result = new
Select(Aggregate.Avg("UnitPrice"))
.From(Product.Schema)
.ExecuteScalar<double>();
Assert.AreEqual(expected, result);
// overload #2
result = new
Select(Aggregate.Avg(Product.UnitPriceColumn))
.From(Product.Schema)
.ExecuteScalar<double>();
Assert.AreEqual(expected, result);
// overload #3
result = new
Select(Aggregate.Avg("UnitPrice", "AverageUnitPrice"))
.From(Product.Schema)
.ExecuteScalar<double>();
Assert.AreEqual(expected, result);
// overload #4
result = new
Select(Aggregate.Avg(Product.UnitPriceColumn, "AverageUnitPrice"))
.From(Product.Schema)
.ExecuteScalar<double>();
Assert.AreEqual(expected, result);
}
public SelectTests()
{
context = new TestingContext();
select = new Select<Role>(context.Set<Role>());
context.Set<Role>().Add(ObjectFactory.CreateRole());
context.DropData();
}
public SelectTests()
{
context = new TestingContext();
select = new Select<Role>(context.Set<Role>());
context.DropData();
SetUpData();
}
public static MvcHtmlString UxSelectWithDataSource(this HtmlHelper htmlHelper, DataSource dataSource, string selectedValue = null, SelectAppearanceType appearance = null, bool liveSearch = false, bool showTick = false, bool showArrow = false, bool autoWidth = true, string width = null, bool disabled = false, string header = null, string container = null, string clientId = null)
{
var select = new Select(selectedValue, dataSource, appearance, liveSearch, showTick, showArrow, autoWidth, width, disabled, header, container, clientId);
MvcHtmlString start = htmlHelper.Partial("ControlTemplates/" + select.ViewTemplate + "Start", select);
MvcHtmlString end = htmlHelper.Partial("ControlTemplates/" + select.ViewTemplate + "End", select);
return MvcHtmlString.Create(start.ToHtmlString() + end.ToHtmlString());
}
public void can_render_options_from_enumerable_of_simple_objects()
{
var optionNodes = new Select("foo.Bar").Options(new[] { 1, 2 }).ToString()
.ShouldHaveHtmlNode("foo_Bar")
.ShouldHaveChildNodesCount(2);
optionNodes[0].ShouldBeUnSelectedOption("1", "1");
optionNodes[1].ShouldBeUnSelectedOption("2", "2");
}
public void Exec_Simple()
{
//string dbPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), @"MyApplication\Northwind.db3");
//DataService.Providers["Northwind"].DefaultConnectionString =
// String.Format(@"Data Source={0};Version=3;New=False;Connection Timeout=3", dbPath);
int records = new Select("productID").From("Products").GetRecordCount();
Assert.IsTrue(records == 77);
}
public SelectTests()
{
context = new TestingContext();
select = new Select<TestModel>(context.Set<TestModel>());
context.Set<TestModel>().RemoveRange(context.Set<TestModel>());
context.Set<TestModel>().Add(ObjectFactory.CreateTestModel());
context.SaveChanges();
}
/// <summary>
/// hàm thực hiện việc xác nhận thông tin
/// </summary>
/// <param name="objPhieuNhap"></param>
/// <returns></returns>
public ActionResult HuyXacNhanPhieuTraLaiKho(TPhieuNhapxuatthuoc objPhieuNhap)
{
HisDuocProperties objHisDuocProperties = PropertyLib._HisDuocProperties;
string errorMessage = "";
try
{
using (var Scope = new TransactionScope())
{
using (var dbScope = new SharedDbConnectionScope())
{
SqlQuery sqlQuery = new Select().From(TPhieuNhapxuatthuocChitiet.Schema)
.Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu);
TPhieuNhapxuatthuocChitietCollection objPhieuNhapCtCollection =
sqlQuery.ExecuteAsCollection<TPhieuNhapxuatthuocChitietCollection>();
foreach (TPhieuNhapxuatthuocChitiet objPhieuNhapCt in objPhieuNhapCtCollection)
{
//Kiểm tra ở kho nhập xem thuốc đã sử dụng chưa
ActionResult _Kiemtrathuochuyxacnhan = Kiemtrathuochuyxacnhan(objPhieuNhap, objPhieuNhapCt);
if (_Kiemtrathuochuyxacnhan != ActionResult.Success) return _Kiemtrathuochuyxacnhan;
int id_thuockho = -1;
StoredProcedure sp = SPs.ThuocNhapkhoOutput(objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap, objPhieuNhapCt.GiaBan,
objPhieuNhapCt.SoLuong, Utility.DecimaltoDbnull(objPhieuNhapCt.Vat),
objPhieuNhapCt.IdThuoc, objPhieuNhap.IdKhonhap, objPhieuNhapCt.MaNhacungcap,
objPhieuNhapCt.SoLo, objPhieuNhapCt.SoDky, objPhieuNhapCt.SoQdinhthau, -1, id_thuockho,
objPhieuNhap.NgayXacnhan, objPhieuNhapCt.GiaBhyt, objPhieuNhapCt.GiaPhuthuDungtuyen, objPhieuNhapCt.GiaPhuthuTraituyen, objPhieuNhapCt.KieuThuocvattu);
sp.Execute();
sp = SPs.ThuocXuatkho(objPhieuNhap.IdKhoxuat, objPhieuNhapCt.IdThuoc,
objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap,objPhieuNhapCt.GiaBan,
Utility.DecimaltoDbnull(objPhieuNhapCt.Vat),
Utility.Int32Dbnull(objPhieuNhapCt.SoLuong), objPhieuNhapCt.IdThuockho, objPhieuNhapCt.MaNhacungcap, objPhieuNhapCt.SoLo, objHisDuocProperties.XoaDulieuKhiThuocDaHet ? 1 : 0, errorMessage);
sp.Execute();
errorMessage = Utility.sDbnull(sp.OutputValues[0]);
}
//Xóa toàn bộ chi tiết trong TBiendongThuoc
new Delete().From(TBiendongThuoc.Schema)
.Where(TBiendongThuoc.IdPhieuColumn).IsEqualTo(objPhieuNhap.IdPhieu).Execute();
new Update(TPhieuNhapxuatthuoc.Schema)
.Set(TPhieuNhapxuatthuoc.Columns.IdNhanvien).EqualTo(null)
.Set(TPhieuNhapxuatthuoc.Columns.NguoiXacnhan).EqualTo(null)
.Set(TPhieuNhapxuatthuoc.Columns.NgayXacnhan).EqualTo(null)
.Set(TPhieuNhapxuatthuoc.Columns.TrangThai).EqualTo(0)
.Where(TPhieuNhapxuatthuoc.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu).Execute();
}
Scope.Complete();
return ActionResult.Success;
}
}
catch (Exception exception)
{
log.Error("Loi ban ra tu sp :{0}", errorMessage);
log.Error("Loi trong qua trinh xac nhan don thuoc :{0}", exception);
return ActionResult.Error;
}
}
static void Main(string[] args)
{
Select select = new Select();
Authentication auth = new Authentication();
auth.version = "1.1"; // Specify which Select API Version (1.0 or 1.1)
PropertyFile rb = PropertyFile.getBundle("Environment");
select.Url = rb.get("soap_url");
auth.login = rb.get("soap_login");
auth.password = rb.get("soap_password");
// ProdTest
//select.Url = "https://soap.prodtest.sj.vindicia.com/v1.0/soap.pl";
//select.Url = "https://soap.prodtest.sj.vindicia.com/soap.pl";
//auth.login = "******";
//auth.password = "";
// Staging:
//select.Url = https://soap.staging.sj.vindicia.com/soap.pl
//auth.login = xxx_soap
//auth.password = "";
// Production:
//select.Url = https://soap.vindicia.com/soap.pl
//auth.login = xxx_soap
//auth.password = "";
Console.WriteLine("soapVersion=" + SEL001BillSelect.getSelectVersion(auth));
Console.WriteLine();
Console.WriteLine("Using version=" + auth.version);
Console.WriteLine("soapURL=" + select.Url);
Console.WriteLine("soapLogin="******"FAILED" + DateTime.Now.DayOfYear + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second;
string soapId = bill.run(select, auth, startMerchantTransactionId);
Console.WriteLine("billTransactions soapId=" + soapId + "\n");
}
if (bFetch)
{
SEL002FetchSelect.run(select, auth);
Console.WriteLine("fetchBillingResults completed.\n");
}
Console.ReadLine();
}
public ModuleBase GetTaigaNoise()
{
if (TaigaNoise == null)
{
TaigaNoise = new Select(0, 1, 1, StandartNoise,
new ScaleBias(0.5, 0, new Perlin(1, 2, 0.25, 4, DataBaseHandler.DataBase.Seed, QualityMode.High)),
new BiomeTranslator(Biomes, BiomeTypes.Taiga, Bounds.left, Bounds.top, Bounds.width, Bounds.height));
}
return TaigaNoise;
}
public void basic_select_renders_with_no_options()
{
var element = new Select("foo.Bar").ToString()
.ShouldHaveHtmlNode("foo_Bar")
.ShouldHaveAttributesCount(2)
.ShouldBeNamed(HtmlTag.Select);
element.ShouldHaveAttribute(HtmlAttribute.Name).WithValue("foo.Bar");
element.ShouldHaveNoChildNodes();
}
public void Exec_AggregateExpression()
{
double result = new
Select(Aggregate.Sum("UnitPrice*Quantity", "ProductSales"))
.From(OrderDetail.Schema)
.ExecuteScalar<double>();
result = Math.Round(result, 2);
Assert.IsTrue(result == 1354458.59);
}
public void Exec_SimpleWhereAnd()
{
ProductCollection products =
DB.Select().From("Products")
.Where("categoryID").IsEqualTo(5)
.And("productid").IsGreaterThan(50)
.ExecuteAsCollection<ProductCollection>();
int records = new Select().From("Products").Where("categoryID").IsEqualTo(5).And("productid").IsGreaterThan(50).GetRecordCount();
Assert.IsTrue(records == 4);
}
public void select_with_options_for_enum_renders_enum_values_as_options()
{
var html = new Select("foo.Bar").Options<FakeEnum>().Selected(FakeEnum.Two).ToString();
var element = html.ShouldHaveHtmlNode("foo_Bar");
var optionNodes = element.ShouldHaveChildNodesCount(4);
optionNodes[0].ShouldBeUnSelectedOption((int)FakeEnum.Zero, FakeEnum.Zero);
optionNodes[1].ShouldBeUnSelectedOption((int)FakeEnum.One, FakeEnum.One);
optionNodes[2].ShouldBeSelectedOption((int)FakeEnum.Two, FakeEnum.Two);
optionNodes[3].ShouldBeUnSelectedOption((int)FakeEnum.Three, FakeEnum.Three);
}
/*
** 2001 September 15
**
** The author disclaims copyright to this source code. In place of
** a legal notice, here is a blessing:
**
** May you do good and not evil.
** May you find forgiveness for yourself and forgive others.
** May you share freely, never taking more than you give.
**
*************************************************************************
** This file contains C code routines that are called by the parser
** to handle SELECT statements in SQLite.
*************************************************************************
** Included in SQLite3 port to C#-SQLite; 2008 Noah B Hart
** C#-SQLite is an independent reimplementation of the SQLite software library
**
** SQLITE_SOURCE_ID: 2011-06-23 19:49:22 4374b7e83ea0a3fbc3691f9c0c936272862f32f2
**
*************************************************************************
*/
//#include "sqliteInt.h"
/*
** Delete all the content of a Select structure but do not deallocate
** the select structure itself.
*/
static void clearSelect( sqlite3 db, Select p )
{
sqlite3ExprListDelete( db, ref p.pEList );
sqlite3SrcListDelete( db, ref p.pSrc );
sqlite3ExprDelete( db, ref p.pWhere );
sqlite3ExprListDelete( db, ref p.pGroupBy );
sqlite3ExprDelete( db, ref p.pHaving );
sqlite3ExprListDelete( db, ref p.pOrderBy );
sqlite3SelectDelete( db, ref p.pPrior );
sqlite3ExprDelete( db, ref p.pLimit );
sqlite3ExprDelete( db, ref p.pOffset );
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
// if (e.ColumnIndex == 4)
// {
// textBox_id.Text = dataGridView2.Rows[e.RowIndex].Cells[0].Value.ToString();
Select s = new Select();
s.Show();
// }
}
/// <summary>
/// simple binding to country table using DAL
/// </summary>
protected void bind_data_grid()
{
string[] _cols2 = { "PackageTypeTable.PackageTypeID", "PackageTypeTable.PackageType" };
string[] _order = { "PackageTypeTable.PackageType" };
DataTable _dt = new Select(_cols2).From(DAL.Logistics.Tables.PackageTypeTable)
.Where(DAL.Logistics.PackageTypeTable.PackageTypeColumn).IsNotNull().OrderAsc(_order).ExecuteDataSet().Tables[0];
this.dxgridSearch.DataSource = _dt;
this.dxgridSearch.KeyFieldName = "PackageTypeID";
this.dxgridSearch.DataBind();
}
public void Acc_Collection_LoadTypedObject()
{
List<PID> result = new
Select("productid", "productname", "unitprice")
.From(Product.Schema)
.OrderAsc("productid")
.ExecuteTypedList<PID>();
Assert.AreEqual(77, result.Count);
Assert.AreEqual("Chai", result[0].ProductName);
Assert.AreEqual(1, result[0].ProductID);
Assert.AreEqual(18, result[0].UnitPrice);
}
/// <summary>
/// simple binding to country table using DAL
/// </summary>
protected void bind_data_grid()
{
string[] _cols2 = { "Departments.DepartmentID", "Departments.Department" };
string[] _order = { "Departments.Department" };
DataTable _dt = new Select(_cols2).From(DAL.Logistics.Tables.Department)
.Where(DAL.Logistics.Department.DepartmentXColumn).IsNotNull().OrderAsc(_order).ExecuteDataSet().Tables[0];
this.dxgridSearch.DataSource = _dt;
this.dxgridSearch.KeyFieldName = "DepartmentID";
this.dxgridSearch.DataBind();
}
/// <summary>
/// Fetches all test.
/// </summary>
/// <param name="repeatTime">The repeat time.</param>
/// <returns>The fetch all test.</returns>
/// <remarks>http://wintersun.cnblogs.com/</remarks>
public long FetchAllTest(int repeatTime)
{
return Utility.PerformanceWatch(
() =>
{
for (int i = 0; i < repeatTime; i++)
{
var product = new Select().From<Product>();
var customer = new Select().From<Customer>();
var category = new Select().From<Category>();
}
});
}
Read16(
Select(u => u == 0xA5A55AA5,
Instr(Mnemonic.diswdt, InstrClass.Linear | InstrClass.Privileged),
public static List <TestInfo> GetItems() => Select.ToList();
public static List <AreaInfo> GetItems()
{
return(Select.ToList());
}
/// <summary>
/// This method is intended to respond to client side Qi queries.
/// Use of this method from .Net should be avoided in favor of
/// one of the methods that take a delegate of type
/// WhereDelegate<LoginCounterColumns>.
/// </summary>
/// <param name="where"></param>
/// <param name="database"></param>
public static LoginCounterCollection Where(QiQuery where, Database database = null)
{
var results = new LoginCounterCollection(database, Select <LoginCounterColumns> .From <LoginCounter>().Where(where, database));
return(results);
}
/// <summary> /// 数据项是否存在 /// </summary> /// <param name="entity"></param> /// <returns></returns> public static Task <bool> Exists(Config entity) => Select.WhereDynamic(entity).AnyAsync();
Instr(Mnemonic.scxt, reg16, mem16), // 4 - reg, mem
Read16(
Select(u => (u & 0x4F0000FC) == 0x4F000000,
Instr(Mnemonic.extp, R8w, pageNo),
public void WriteSelect(string text) => Select.Append(text);
protected void Page_Load(object sender, EventArgs e)
{
//---------------------------------------------------------
// 1、新增记录
//---------------------------------------------------------
var branch = new Branch();
branch.DeptCode = SPs.P_Branch_GetMaxBranchDeptCode(2, 1).ExecuteScalar() + "";
branch.Name = "客服部";
branch.Comment = "客户售后服务维护部门";
branch.ParentId = 1;
branch.Sort = 7;
branch.Depth = 2;
//AddDate这个属性不用赋值，ORM框架生成更新语句时会自动过滤该字段，更新时将会使用数据库中设置的默认值
//branch.AddDate = DateTime.Now;
//保存数据入库
branch.Save();
WriteLine("记录添加成功,新增Id为：" + branch.Id);
//----------------------------------------------------------
// 2、修改记录
//----------------------------------------------------------
var branchModel = Branch.SingleOrDefault(x => x.Id == branch.Id);
//也可以这样用
//var branchModel = new Branch(x => x.Id == branch.Id);
//打印读取出来的数据
WriteLine(branchModel.ToString());
//修改名称为“售后服务部”
branchModel.Name = "售后服务部";
//保存
branchModel.Save();
//重新从数据库中读取出来并打印到输出窗口
WriteLine((new Branch(x => x.Id == branch.Id)).ToString());
//----------------------------------------------------------
// 3、判断刚刚修改的记录是否存在
//----------------------------------------------------------
if (Branch.Exists(x => x.Id == branch.Id))
{
WriteLine("Id为" + branch.Id + "的记录存在！");
}
else
{
WriteLine("Id为" + branch.Id + "的记录不存在！");
}
//---------------------------------------------------------
// 4、删除记录
//---------------------------------------------------------
//删除当前记录
Branch.Delete(x => x.Id == branch.Id);
//也可以这样操作：
//branchModel.Delete();
WriteLine("删除Id为" + branch.Id + "的记录成功！");
//--------------------------------------------------------
// 5、判断刚刚删除的记录是否存在
//--------------------------------------------------------
if (Branch.Exists(x => x.Id == branch.Id))
{
WriteLine("Id为" + branch.Id + "的记录存在！");
}
else
{
WriteLine("Id为" + branch.Id + "的记录不存在！");
}
//--------------------------------------------------------
// 6、使用类实体附带的函数查询
//--------------------------------------------------------
//查找出所有记录 -- 使用All()
var list = Branch.All();
foreach (var item in list)
{
//打印记录到输出窗口
WriteLine(item.ToString());
}
//查询指定条件的记录 -- 使用Find()
IList <Branch> il = Branch.Find(x => x.Id > 2);
foreach (var item in il)
{
WriteLine(item.ToString());
}
//获取第二页记录（每页3条记录）
il = Branch.GetPaged("Id Asc", 2, 3);
foreach (var item in il)
{
WriteLine(item.ToString());
}
//使用Id倒序排序，获取第三页记录（每页3条记录）
il = Branch.GetPaged("Id Desc", 3, 3);
foreach (var item in il)
{
WriteLine(item.ToString());
}
//--------------------------------------------------
// 7、使用Select类查询
//--------------------------------------------------
//创建Select对象
//var select = new Select();
//显示指定的列
var select = new Select(new string[] { BranchTable.Id, BranchTable.Name, BranchTable.DeptCode });
//指定查询表
select.From <Branch>();
//运行完上面这条语句后，SQL已经生成出来了，在Debug状态将鼠标指向select就可以看到，往下继续执行时，每添加一个属性都会添加在生成的SQL语句中
//添加查询条件 -- Id大于2且编号头两位为01的部门
select.Where(BranchTable.Id).IsGreaterThanOrEqualTo(2).And(BranchTable.DeptCode).StartsWith("01");
//查询时括号添加列子
//select.OpenExpression().Where("").IsEqualTo(0).Or("").IsEqualTo(11).CloseExpression().And("").IsEqualTo(3);
//设置去重复 -- SubSonic没有去重复选项，需要自己手动修改DLL源码
select.Distinct(true);
//或
//select.IsDistinct = true;
//设置查询数量
select.Top("5");
//添加排序 -- 倒序
select.OrderDesc(BranchTable.Sort);
//或
//List<string> orderByList = new List<string>();
//orderByList.Add(BranchTable.Sort + " Desc");
//orderByList.Add(BranchTable.Id + " Desc");
//select.OrderBys = orderByList;
//设置分页，获取第一页记录(每页10条记录）
select.Paged(1, 10);
//执行查询 -- 返回DataTable
var dt = select.ExecuteDataTable();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
WriteLine(dt.Rows[i][BranchTable.Id] + " " + dt.Rows[i][BranchTable.Name]);
}
}
//执行查询 -- 返回List
var bl = select.ToList <Branch>();
foreach (var item in bl)
{
WriteLine(item.ToString());
}
//查询总记录数
var recordCount = select.GetRecordCount();
WriteLine("记录数量：" + recordCount.ToString());
//-------------------------------------------------------------
// 8、HotelDBDB查询类的使用方式
//-------------------------------------------------------------
//使用数据库名称+DB作为名称的类，可以直接调用聚合函数
var db = new SubSonicTestDB();
//平均值
WriteLine("平均值：" + db.Avg <Branch>(x => x.Id).Where <Branch>(x => x.Id < 10).ExecuteScalar() + "");
//计算数量
WriteLine("计算数量：" + db.Count <Branch>(x => x.Id).ExecuteScalar() + "");
//计算合计数量
WriteLine("计算合计数量：" + db.Sum <Branch>(x => x.Id).ExecuteScalar() + "");
//最大值
WriteLine("最大值：" + db.Max <Branch>(x => x.Id).ExecuteScalar() + "");
//最小值
WriteLine("最小值：" + db.Min <Branch>(x => x.Id).ExecuteScalar() + "");
//---------------------------------------------------------------
// 9、存储过程调用方法
//---------------------------------------------------------------
//使用SPs.存储过程名称(参数1，参数2，参数3）就可以调用存储过程
var obj = SPs.P_Branch_GetMaxBranchDeptCode(1, 0).ExecuteScalar();
WriteLine(obj + "");
//---------------------------------------------------------------
// 10、直接执行QueryCommand的方式
//---------------------------------------------------------------
//获取数据源 -- 主要用于绑定连接的服务器，如果有多台服务器多个数据库时，可使用不同的数据源来进行绑定查找
var provider = SubSonic.DataProviders.ProviderFactory.GetProvider();
//定义事务，给后面的事务调用
var batch = new BatchQuery(provider);
var sql = string.Format("select * from {0}", BranchTable.TableName);
//例一：获取影响记录数
QueryCommand qcCommand = new QueryCommand(sql, provider);
WriteLine(qcCommand.Provider.ExecuteQuery(qcCommand) + "");
//例二：获取DataTable
var q = new SubSonic.Query.QueryCommand(sql, provider);
var table = q.Provider.ExecuteDataSet(q).Tables[0];
if (dt != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
WriteLine(table.Rows[i][BranchTable.Id] + " " + table.Rows[i][BranchTable.Name]);
}
}
//例三：使用事务执行
batch.QueueForTransaction(qcCommand);
batch.ExecuteTransaction();
//例四：直接使用数据源执行
provider.ExecuteQuery(qcCommand);
//----------------------------------------------------------------
// 11、Linq查询
//----------------------------------------------------------------
//Linq查询方式
var query = new Query <Branch>(db.provider);
var posts = from p in query
where p.DeptCode.StartsWith("0101")
select p;
foreach (var item in posts)
{
WriteLine(item.ToString());
}
query = db.GetQuery <Branch>();
posts = from p in query
where p.Id > 3 && p.Id < 6
select p;
foreach (var item in posts)
{
WriteLine(item.ToString());
}
//获取查询结果2
List <Branch> li2 = query.ToList <Branch>();
foreach (var item in li2)
{
WriteLine(item.ToString());
}
//---------------------------------------------------------------------
// 12、Linq多表关联查询
//---------------------------------------------------------------------
//方法一
var query5 = from p in Position.All()
join b in Branch.All() on p.Branch_Id equals b.Id
where b.DeptCode == "0101"
select p;
foreach (var item in query5)
{
WriteLine(item.ToString());
}
//方法二
var qry = (from p in db.Position
join b in db.Branch on p.Branch_Id equals b.Id
where b.DeptCode == "0101"
select new ListView
{
PositionName = p.Name,
BranchName = p.Branch_Name,
DeptCode = b.DeptCode
});
foreach (var item in qry)
{
WriteLine(item.ToString());
}
//-------------------------------------------------------------------------
// 13、使用事务
//-------------------------------------------------------------------------
//例一
//从部门表中查询出编号为0102的Id、名称与说明三列
var query1 = new SubSonic.Query.Select(provider, BranchTable.Id, BranchTable.Name, BranchTable.Comment).From(
BranchTable.TableName).Where <Branch>(x => x.DeptCode == "0102");
//加入事务
batch.QueueForTransaction(query1);
//查询部门编号为0102且职位名称后面两个字为主管的所有职位
var query2 = new SubSonic.Query.Select(provider).From <Position>().Where <Position>(x => x.Branch_DeptCode == "0102").And(
PositionTable.Name).EndsWith("主管");
//加入事务
batch.QueueForTransaction(query2);
//运行事务,不返回任何信息
batch.ExecuteTransaction();
//例二
batch = new BatchQuery();
batch.Queue(query1);
batch.Queue(query2);
//执行事务，并返回数据
using (IDataReader rdr = batch.ExecuteReader())
{
if (rdr.Read())
{
//query1 results
for (int i = 0; i < rdr.FieldCount; i++)
{
WriteLine(rdr[i] + "");
}
}
rdr.NextResult();
if (rdr.Read())
{
//query2 results
for (int i = 0; i < rdr.FieldCount; i++)
{
WriteLine(rdr[i] + "");
}
}
}
//例三
batch = new BatchQuery(provider);
var query3 = from p in db.Branch
where p.Id > 1 && p.Id < 10
select p;
batch.Queue(query3);
var query4 = from p in db.Position
where p.Branch_DeptCode == "0103"
select p;
batch.Queue(query4);
//执行事务，并返回数据
using (var rdr = batch.ExecuteReader())
{
if (rdr.Read())
{
//query3 results
for (int i = 0; i < rdr.FieldCount; i++)
{
WriteLine(rdr[i] + "");
}
}
rdr.NextResult();
if (rdr.Read())
{
//query4 results
for (int i = 0; i < rdr.FieldCount; i++)
{
WriteLine(rdr[i] + "");
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpContext.Current.Response.Cache.SetAllowResponseInBrowserHistory(false);
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Current.Response.Cache.SetNoStore();
Response.Cache.SetExpires(DateTime.Now);
Response.Cache.SetValidUntilExpires(true);
Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache);
Response.Cache.SetNoStore();
if (Request.Cookies[FormsAuthentication.FormsCookieName] != null)
{
HttpCookie authCookie = Request.Cookies[FormsAuthentication.FormsCookieName];
FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value);
if (ticket.Expiration <= DateTime.Now)
{
Response.Redirect("~/PL/Membership/Login.aspx");
}//end if
else
{
Session sessionObject = new Session();
FormsAuthenticationTicket newTicket = new FormsAuthenticationTicket(ticket.Version, ticket.Name, DateTime.Now, DateTime.Now.AddMinutes(sessionObject.getSessionTimeLimit()), ticket.IsPersistent, ticket.UserData);
string encryptedTicket = FormsAuthentication.Encrypt(newTicket);
HttpCookie cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
cookie.Expires = newTicket.Expiration;
Response.Cookies.Add(cookie);
}//end else
if (ticket.UserData != "Super Admin")
{
Response.Redirect("~/PL/Membership/Login.aspx");
}//end if
}//end if
else
{
Response.Redirect("~/PL/Membership/Login.aspx");
}//end else
string totalNumberOfUsers;
string errorMessage;
Select selectObject = new Select();
totalNumberOfUsers = Select.Select_Total_Number_Of_Users();
errorMessage = selectObject.getErrorMessage();
if(errorMessage != null)
{
lblError.Text = errorMessage;
lblError.Visible = true;
ErrorMessage message = new ErrorMessage();
MsgBox(message.SQLServerErrorMessage);
}
else
{
lblTotal.Text = totalNumberOfUsers.ToString();
string testUsers;
string errorMessage2;
Select selectObject2 = new Select();
testUsers = Select.Select_Test_Users();
errorMessage2 = selectObject2.getErrorMessage();
if (errorMessage2 != null)
{
lblError.Text = errorMessage2;
lblError.Visible = true;
ErrorMessage message = new ErrorMessage();
MsgBox(message.SQLServerErrorMessage);
}
else
{
lblTestUsers.Text = testUsers.ToString();
int adminCompUsers;
string errorMessage3;
Select selectObject3 = new Select();
adminCompUsers = Select.Select_Admin_Comp_Users();
errorMessage3 = selectObject3.getErrorMessage();
if (errorMessage3 != null)
{
lblError.Text = errorMessage3;
lblError.Visible = true;
ErrorMessage message = new ErrorMessage();
MsgBox(message.SQLServerErrorMessage);
}
else
{
lblAdminCompUsers.Text = adminCompUsers.ToString();
int _testUsers = Convert.ToInt32(testUsers);
int _totalNumberOfUsers = Convert.ToInt32(totalNumberOfUsers);
int _adminCompUsers = Convert.ToInt32(adminCompUsers);
string clients = "0";
int _clients = Convert.ToInt32(clients);
_clients = _totalNumberOfUsers - _adminCompUsers - _testUsers - 14;
lblClients.Text = _clients.ToString();
}//end else
}//end else
}//end else
}//end event
/// <summary>
/// This method is intended to respond to client side Qi queries.
/// Use of this method from .Net should be avoided in favor of
/// one of the methods that take a delegate of type
/// WhereDelegate<UserRoleColumns>.
/// </summary>
/// <param name="where"></param>
/// <param name="database"></param>
public static UserRoleCollection Where(QiQuery where, Database database = null)
{
var results = new UserRoleCollection(database, Select <UserRoleColumns> .From <UserRole>().Where(where, database));
return(results);
}
public virtual Task <TDto> GetAsync <TDto>(Expression <Func <TEntity, bool> > exp)
{
return(Select.Where(exp).ToOneAsync <TDto>());
}
public virtual Task <TDto> GetAsync <TDto>(TKey id)
{
return(Select.WhereDynamic(id).ToOneAsync <TDto>());
}
private void CatalogIndexMessageEvent()
{
if (Client.GetHabbo().FlatType == "private")
{
PrivateRooms mRoom = AleedaEnvironment.GetCache().GetPrivateRooms().getRoom(Client.GetHabbo().RoomId);
if (mRoom == null)
{
return;
}
#region Bots
if (AleedaEnvironment.GetCache().GetRoomBots().RoomBotCounts(Client.GetHabbo().RoomId) != 0)
{
AleedaEnvironment.GetCache().GetRoomBots().LoadAnyBotChats(Client.GetHabbo().Username, Client.GetHabbo().RoomId);
}
#endregion
Response.Initialize(45);
GetWallItems().SerializeWallDisplay(GetResponse(), Client.GetHabbo().RoomId);
SendResponse();
Response.Initialize(32);
GetFloorItems().Serialize(GetResponse(), Client.GetHabbo().RoomId);
SendResponse();
Response.Initialize(471); // "GW"
Serialize.RoomEntryInfo(Client, AleedaEnvironment.GetHabboHotel().GetHabbos().GetHabbo((UInt32)mRoom.OwnerID).Username, Response);
SendResponse();
Response.Initialize(28); // "@\"
Serialize.SerializeUsers(true, Client.GetHabbo().RoomId, Response);
SendRoom();
Response.Initialize(34); // "@b"
Serialize.SerializeStatus(true, Client.GetHabbo().RoomId, Response);
SendRoom();
}
else if (Client.GetHabbo().FlatType == "public")
{
Response.Initialize(471); // "GW"
Serialize.RoomEntryInfo(Client, "", Response);
SendResponse();
Response.Initialize(30); // "@^"
Response.Append(Select.GetPublicRoomItems(Client.GetHabbo().FlatModel));
SendResponse();
try
{
Response.Initialize(28); // "@\"
Serialize.SerializeUsers(false, Client.GetHabbo().pRoomId, GetResponse());
SendRoom();
Response.Initialize(34); // "@b"
Serialize.SerializeStatus(false, Client.GetHabbo().RoomId, GetResponse());
SendRoom();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
}
Read16(
Select(u => u == 0x97976897,
Instr(Mnemonic.pwrdn, InstrClass.Linear | InstrClass.Privileged),
Read16(
Select(u => u == 0x87877887,
Instr(Mnemonic.idle, InstrClass.Linear | InstrClass.Privileged),
public void SelectByText(string text, int timeout)
{
Select select = this.Driver.GetElement <Select>(this.dropDownLocator);
select.SelectByText(text, timeout);
}
/// <summary> /// 根据前缀查询配置项列表 /// </summary> /// <param name="prefix"></param> /// <returns></returns> public static Task <List <Config> > QueryByPrefix(string prefix) => Select.Where(a => a.Id.StartsWith(prefix)).ToListAsync();
public string SelectedOption()
{
Select select = this.Driver.GetElement <Select>(this.dropDownLocator);
return(select.SelectElement().SelectedOption.Text);
}
/// <summary> /// 验证键值是否存在 /// </summary> /// <param name="key"></param> /// <returns></returns> public static Task <bool> Exists(string key) => Select.AnyAsync(a => a.Id == key);
public void CompleteSummaryTab()
{
Wait.For(this.GetWindow <DealNotebookWindow>(), window =>
{
Click.On(window.SummaryTab.Header);
Enter.TextInto(window.SummaryTab.ProposedCmt, "10");
Click.On(window.SummaryTab.AddButton);
Wait.For(this.GetWindow <QuestionWindow>(), dialog =>
{
Click.On(dialog.YesButton);
}, WaitToFinish.YES);
Wait.For(this.GetWindow <CommonSelectWindow>(), dialog =>
{
Enter.TextInto(dialog.IdentifyBy, "borror2014");
Click.On(dialog.SearchButton);
}, WaitToFinish.YES);
Wait.For(this.GetWindow <CommonListByShortNameWindow>(), dialog =>
{
Select.By(dialog.ShortNameList, 0);
Click.On(dialog.OkButton);
}, WaitToFinish.YES);
Wait.For(this.GetWindow <DealBorrowerDetailsWindow>(), dialog =>
{
Click.On(dialog.OkButton);
}, WaitToFinish.YES);
Click.On(window.SummaryTab.DealClassificationButton);
Wait.For(this.GetWindow <CommonSelectCodeWindow>(), dialog =>
{
//Select.By(dialog.ClassificationTree, 1);
Enter.TextInto(dialog.SearchByCodeTextBox, "CPF");
Click.On(dialog.OkButton);
}, WaitToFinish.YES);
Click.On(window.SummaryTab.AdminAgentButton);
Wait.For(this.GetWindow <QuestionWindow>(), dialog =>
{
Click.On(dialog.YesButton);
});
Wait.For(this.GetWindow <DealAdminAgentWindow>(), childDialog =>
{
Click.On(childDialog.CustomerButton);
Wait.For(this.GetWindow <CommonSelectWindow>(), dialogTwo =>
{
Enter.TextInto(dialogTwo.IdentifyBy, "BANK 1");
Click.On(dialogTwo.SearchButton);
}, WaitToFinish.YES);
Wait.For(this.GetWindow <CommonListByShortNameWindow>(), dialogTwo =>
{
Select.By(dialogTwo.ShortNameList, 0);
Click.On(dialogTwo.OkButton);
}, WaitToFinish.YES);
Click.On(childDialog.OkButton);
}, WaitToFinish.YES);
});
}
/// <summary>
/// This method is intended to respond to client side Qi queries.
/// Use of this method from .Net should be avoided in favor of
/// one of the methods that take a delegate of type
/// WhereDelegate<MainObjectColumns>.
/// </summary>
/// <param name="where"></param>
/// <param name="database"></param>
public static MainObjectCollection Where(QiQuery where, Database database = null)
{
var results = new MainObjectCollection(database, Select <MainObjectColumns> .From <MainObject>().Where(where, database));
return(results);
}
internal static IEnumerable <dynamic> Select <TSource>(this IEnumerable <TSource> source, Filter filter)
{
var select = new Select <TSource>().Apply(filter);
return(source.Select(select));
}
public void SelectByIndex(int index, int timeout)
{
Select select = this.Driver.GetElement <Select>(this.dropDownLocator, 300);
select.SelectByIndex(index, timeout);
}
/*
** Generate an expression tree to implement the WHERE, ORDER BY,
** and LIMIT/OFFSET portion of DELETE and UPDATE statements.
**
** DELETE FROM table_wxyz WHERE a<5 ORDER BY a LIMIT 1;
** \__________________________/
** pLimitWhere (pInClause)
*/
Expr sqlite3LimitWhere(
Parse pParse, /* The parser context */
SrcList pSrc, /* the FROM clause -- which tables to scan */
Expr pWhere, /* The WHERE clause. May be null */
ExprList pOrderBy, /* The ORDER BY clause. May be null */
Expr pLimit, /* The LIMIT clause. May be null */
Expr pOffset, /* The OFFSET clause. May be null */
char zStmtType /* Either DELETE or UPDATE. For error messages. */
)
{
Expr pWhereRowid = null; /* WHERE rowid .. */
Expr pInClause = null; /* WHERE rowid IN ( select ) */
Expr pSelectRowid = null; /* SELECT rowid ... */
ExprList pEList = null; /* Expression list contaning only pSelectRowid */
SrcList pSelectSrc = null; /* SELECT rowid FROM x ... (dup of pSrc) */
Select pSelect = null; /* Complete SELECT tree */
/* Check that there isn't an ORDER BY without a LIMIT clause.
*/
if (pOrderBy != null && (pLimit == null))
{
sqlite3ErrorMsg(pParse, "ORDER BY without LIMIT on %s", zStmtType);
pParse.parseError = 1;
goto limit_where_cleanup_2;
}
/* We only need to generate a select expression if there
** is a limit/offset term to enforce.
*/
if (pLimit == null)
{
/* if pLimit is null, pOffset will always be null as well. */
Debug.Assert(pOffset == null);
return(pWhere);
}
/* Generate a select expression tree to enforce the limit/offset
** term for the DELETE or UPDATE statement. For example:
** DELETE FROM table_a WHERE col1=1 ORDER BY col2 LIMIT 1 OFFSET 1
** becomes:
** DELETE FROM table_a WHERE rowid IN (
** SELECT rowid FROM table_a WHERE col1=1 ORDER BY col2 LIMIT 1 OFFSET 1
** );
*/
pSelectRowid = sqlite3PExpr(pParse, TK_ROW, null, null, null);
if (pSelectRowid == null)
{
goto limit_where_cleanup_2;
}
pEList = sqlite3ExprListAppend(pParse, null, pSelectRowid);
if (pEList == null)
{
goto limit_where_cleanup_2;
}
/* duplicate the FROM clause as it is needed by both the DELETE/UPDATE tree
** and the SELECT subtree. */
pSelectSrc = sqlite3SrcListDup(pParse.db, pSrc, 0);
if (pSelectSrc == null)
{
sqlite3ExprListDelete(pParse.db, pEList);
goto limit_where_cleanup_2;
}
/* generate the SELECT expression tree. */
pSelect = sqlite3SelectNew(pParse, pEList, pSelectSrc, pWhere, null, null,
pOrderBy, 0, pLimit, pOffset);
if (pSelect == null)
{
return(null);
}
/* now generate the new WHERE rowid IN clause for the DELETE/UDPATE */
pWhereRowid = sqlite3PExpr(pParse, TK_ROW, null, null, null);
if (pWhereRowid == null)
{
goto limit_where_cleanup_1;
}
pInClause = sqlite3PExpr(pParse, TK_IN, pWhereRowid, null, null);
if (pInClause == null)
{
goto limit_where_cleanup_1;
}
pInClause->x.pSelect = pSelect;
pInClause->flags |= EP_xIsSelect;
sqlite3ExprSetHeight(pParse, pInClause);
return(pInClause);
/* something went wrong. clean up anything allocated. */
limit_where_cleanup_1:
sqlite3SelectDelete(pParse.db, pSelect);
return(null);
limit_where_cleanup_2:
sqlite3ExprDelete(pParse.db, ref pWhere);
sqlite3ExprListDelete(pParse.db, pOrderBy);
sqlite3ExprDelete(pParse.db, ref pLimit);
sqlite3ExprDelete(pParse.db, ref pOffset);
return(null);
}
public void CreatePrimary()
{
Wait.For(this.GetWindow <DealNotebookWindow>(), window =>
{
Click.On(window.DistributionMenuItem);
Click.On(window.PrimariesMenuItem);
});
Close.This(this.GetWindow <DealNotebookWindow>());
Close.This(this.GetWindow <FacilityWindow>());
Close.This(this.GetWindow <FacilityNavigatorWindow>());
Wait.For(this.GetWindow <PrimaryListWindow>(), window =>
{
Click.On(window.AddButton);
Wait.For(this.GetWindow <PrimaryCreateWindow>(), dialog =>
{
Click.On(dialog.LenderButton);
Wait.For(this.GetWindow <CommonSelectWindow>(), childDialog =>
{
Enter.TextInto(childDialog.IdentifyBy, "BANK 1");
Click.On(childDialog.SearchButton);
}, WaitToFinish.YES);
Wait.For(this.GetWindow <CommonListByShortNameWindow>(), childDialog =>
{
Select.By(childDialog.ShortNameList, 0);
Click.On(childDialog.OkButton);
}, WaitToFinish.YES);
Click.On(dialog.BroughtInByButton);
Wait.For(this.GetWindow <CommonSelectWindow>(), childDialog =>
{
Enter.TextInto(childDialog.IdentifyBy, "BANK 1");
Click.On(childDialog.SearchButton);
}, WaitToFinish.YES);
Wait.For(this.GetWindow <CommonListByShortNameWindow>(), childDialog =>
{
Select.By(childDialog.ShortNameList, 0);
Click.On(childDialog.OkButton);
}, WaitToFinish.YES);
Click.On(dialog.OkButton);
});
Wait.For(this.GetWindow <PrimaryPendingOrigWindow>(), dialog =>
{
Click.On(dialog.Facilities.Header);
Enter.TextInto(dialog.SellAmount, "10");
//Click.On(dialog.AmountsOrDates.Header);
Click.On(dialog.Contacts.Header);
Click.On(dialog.Contacts.AddContactsButton);
Wait.For(this.GetWindow <ContactsCircleWindow>(), childDialog =>
{
Select.By(childDialog.AvailableList, 0);
Click.On(childDialog.OkButton);
});
Wait.For(this.GetWindow <ContactsSelectionWindow>(), childDialog =>
{
Click.On(childDialog.ExitButton);
});
Click.On(dialog.Codes.Header);
//Click.On(dialog.Maintenance);
//Click.On(dialog.PortfolioAllocations); // TODO:
Click.On(dialog.WorkflowTab.Header);
Select.By(dialog.WorkflowTab.WorkflowTree, 0, true);
Wait.For(this.GetWindow <WarningWindow>(), childDialog =>
{
Click.On(childDialog.YesButton);
});
Wait.For(this.GetWindow <PortfolioSetCircledOrLegalTradeDateWindow>(), childDialog =>
{
Click.On(childDialog.OkButton);
});
});
Close.This(this.GetWindow <PrimaryPendingOrigWindow>());
//Click.On(window.ExitButton);
});
Close.This(this.GetWindow <PrimaryListWindow>());
// OPEN DEAL HERE
//Wait.For(this.GetWindow<DealNotebookWindow>(), window =>
//{
// Click.On(window.WorkflowTab.Header);
// Select.By(window.WorkflowTab.WorkflowTree, 0);
//});
}
Read16(
Select(u => u == 0xB7B748B7,
Instr(Mnemonic.srst, InstrClass.Terminates | InstrClass.Privileged),
Read16(
Select(u => u == 0xB5B54AB5,
Instr(Mnemonic.einit, InstrClass.Linear | InstrClass.Privileged),
Read16(
Select(u => u == 0xA7A758A7,
Instr(Mnemonic.srvwdt, InstrClass.Linear | InstrClass.Privileged),
public Any(Field field, SqlOperator sqlOperator, Select select) : base(field, sqlOperator)
{
Select = @select;
}
public static TestInfo GetItem(int Id) => SqlHelper.CacheShell(string.Concat("es_BLL_Test_", Id), itemCacheTimeout, () => Select.WhereId(Id).ToOne());