public async Task ListT_Enum_Test()
{
/*******************************************************************************************************************/
var xx1 = "";
var enums = new List <AgentLevel>
{
AgentLevel.CityAgent,
AgentLevel.DistiAgent
};
// where in -- variable List<enum>
var res1 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => enums.Contains(it.AgentLevel))
.QueryListAsync();
var tuple1 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx2 = "";
// where in -- obj.prop List<enum>
var res2 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => WhereTest.In_List_枚举.Contains(it.AgentLevel))
.QueryListAsync();
var tuple2 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx3 = "";
EnumList = enums;
// where in -- this.prop List<enum>
var res3 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => EnumList.Contains(it.AgentLevel))
.QueryListAsync();
var tuple3 = (XDebug.SQL, XDebug.Parameters);
Assert.True(res1.Count == res2.Count);
Assert.True(res2.Count == res3.Count);
Assert.True(res1.Count == 555);
/*******************************************************************************************************************/
var xx4 = "";
var names = new List <string>
{
"黄银凤",
"刘建芬"
};
// where in -- variable List<string>
var res4 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => names.Contains(it.Name))
.QueryListAsync();
var tuple4 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx5 = "";
// where in -- obj.prop List<string>
var res5 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => WhereTest.In_List_String.Contains(it.Name))
.QueryListAsync();
var tuple5 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx6 = "";
StringList = names;
// where in -- this.prop List<string>
var res6 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => StringList.Contains(it.Name))
.QueryListAsync();
var tuple6 = (XDebug.SQL, XDebug.Parameters);
Assert.True(res4.Count == res5.Count);
Assert.True(res5.Count == res6.Count);
Assert.True(res4.Count == 2);
/*******************************************************************************************************************/
await PereValue();
/*******************************************************************************************************************/
var xx7 = "";
// where in -- List<int> init
var res7 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => new List <int> {
5, 10
}.Contains(it.DirectorStarCount))
.QueryListAsync();
var tuple7 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx8 = "";
// where in -- List<long> init
var res8 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => new List <long> {
5, 10
}.Contains(it.DirectorStarCount))
.QueryListAsync();
var tuple8 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx9 = "";
// where in -- List<short> init
var res9 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => new List <short> {
5, 10
}.Contains((short)(it.DirectorStarCount)))
.QueryListAsync();
var tuple9 = (XDebug.SQL, XDebug.Parameters);
Assert.True(res7.Count == res8.Count);
Assert.True(res8.Count == res9.Count);
Assert.True(res7.Count == 2);
/*******************************************************************************************************************/
var xx10 = "";
// where in -- List<string> init
var res10 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => new List <string> {
"黄银凤", "刘建芬"
}.Contains(it.Name))
.QueryListAsync();
Assert.True(res10.Count == 2);
var tuple10 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx11 = "";
// where in -- List<enum> init
var res11 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => new List <AgentLevel> {
AgentLevel.CityAgent, AgentLevel.DistiAgent
}.Contains(it.AgentLevel))
.QueryListAsync();
Assert.True(res11.Count == 555);
var tuple11 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx12 = "";
var enumArray = new AgentLevel[]
{
AgentLevel.CityAgent,
AgentLevel.DistiAgent
};
// where in -- variable enum[]
var res12 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => enumArray.Contains(it.AgentLevel))
.QueryListAsync();
var tuple12 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx13 = "";
// where in -- obj.prop enum[]
var res13 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => WhereTest.In_Array_枚举.Contains(it.AgentLevel))
.QueryListAsync();
var tuple13 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx14 = "";
EnumArray = enumArray;
// where in -- this.prop enum[]
var res14 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => EnumArray.Contains(it.AgentLevel))
.QueryListAsync();
var tuple14 = (XDebug.SQL, XDebug.Parameters);
Assert.True(res12.Count == res13.Count);
Assert.True(res13.Count == res14.Count);
Assert.True(res12.Count == 555);
/*******************************************************************************************************************/
var xx15 = "";
var nameArray = new string[]
{
"黄银凤",
"刘建芬"
};
// where in -- variable string[]
var res15 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => nameArray.Contains(it.Name))
.QueryListAsync();
var tuple15 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx16 = "";
// where in -- obj.prop string[]
var res16 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => WhereTest.In_Array_String.Contains(it.Name))
.QueryListAsync();
var tuple16 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx17 = "";
StringArray = nameArray;
// where in -- this.prop string[]
var res17 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => StringArray.Contains(it.Name))
.QueryListAsync();
var tuple17 = (XDebug.SQL, XDebug.Parameters);
Assert.True(res15.Count == res16.Count);
Assert.True(res16.Count == res17.Count);
Assert.True(res15.Count == 2);
/*******************************************************************************************************************/
await PereValue();
/*******************************************************************************************************************/
var xx18 = "";
// where in -- int[] init
var res18 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => new int[] { 5, 10 }.Contains(it.DirectorStarCount))
.QueryListAsync();
var tuple18 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx19 = "";
// where in -- long[] init
var res19 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => new long[] { 5L, 10L }.Contains(it.DirectorStarCount))
.QueryListAsync();
var tuple19 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx20 = "";
// where in -- short[] init
var res20 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => new short[] { 5, 10 }.Contains((short)(it.DirectorStarCount)))
.QueryListAsync();
var tuple20 = (XDebug.SQL, XDebug.Parameters);
Assert.True(res18.Count == res19.Count);
Assert.True(res19.Count == res20.Count);
Assert.True(res18.Count == 2);
/*******************************************************************************************************************/
var xx21 = "";
// where in -- string[] init
var res21 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => new string[] { "黄银凤", "刘建芬" }.Contains(it.Name))
.QueryListAsync();
Assert.True(res21.Count == 2);
var tuple21 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx22 = "";
// where in -- enum[] init
var res22 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(it => new AgentLevel[] { AgentLevel.CityAgent, AgentLevel.DistiAgent }.Contains(it.AgentLevel))
.QueryListAsync();
Assert.True(res22.Count == 555);
var tuple22 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx23 = "";
// where in -- enum[] init
var res23 = await Conn.OpenDebug()
.Joiner <Agent, AgentInventoryRecord>(out var agent, out var record)
.From(() => agent)
.InnerJoin(() => record)
.On(() => agent.Id == record.AgentId)
.Where(() => new AgentLevel[] { AgentLevel.CityAgent, AgentLevel.DistiAgent }.Contains(agent.AgentLevel))
.QueryListAsync <Agent>();
Assert.True(res23.Count == 574);
var tuple23 = (XDebug.SQL, XDebug.Parameters);
/*******************************************************************************************************************/
var xx = "";
}
private void btnSave_Click(object sender, EventArgs e)
{
AgentLevel al = new AgentLevel();
if (String.IsNullOrEmpty(txtAgentLevelName.Text.Trim()))
{
MessageBox.Show("级别名称不许为空！", "软件提示");
txtAgentLevelName.Focus();
return;
}
if (String.IsNullOrEmpty(txtLeastMoney.Text))
{
MessageBox.Show("销售任务不许为空！", "软件提示");
txtLeastMoney.Focus();
return;
}
else
{
if (Convert.ToDecimal(txtLeastMoney.Text) == 0)
{
MessageBox.Show("销售任务不许为零！", "软件提示");
txtLeastMoney.Focus();
return;
}
}
if (String.IsNullOrEmpty(txtDiscount.Text.Trim()))
{
MessageBox.Show("代理折扣不许为空！", "软件提示");
txtDiscount.Focus();
return;
}
else
{
if (Convert.ToDecimal(txtDiscount.Text) == 0)
{
MessageBox.Show("代理折扣不许为零！", "软件提示");
txtDiscount.Focus();
return;
}
if (Convert.ToDecimal(txtDiscount.Text) > 1)
{
MessageBox.Show("代理折扣不许大于“1”！", "软件提示");
txtDiscount.Focus();
return;
}
}
if (this.Tag.ToString() == "Add")
{
DataGridViewRow dgvr = al.AddDataGridViewRow(formAgentLevel.dgvAgentLevel, formAgentLevel.bsAgentLevel);
dgvr.Cells["AgentLevelCode"].Value = txtAgentLevelCode.Text;
dgvr.Cells["AgentLevelName"].Value = txtAgentLevelName.Text.Trim();
dgvr.Cells["LeastMoney"].Value = Convert.ToDecimal(txtLeastMoney.Text);
dgvr.Cells["Discount"].Value = Convert.ToDecimal(txtDiscount.Text);
if (al.Insert(formAgentLevel.bsAgentLevel))
{
if (MessageBox.Show("保存成功，是否继续添加？", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
txtAgentLevelCode.Text = useful.BuildCode("AgentLevel", "", "AgentLevelCode", "", 2);
txtAgentLevelName.Text = "";
txtLeastMoney.Text = "";
txtDiscount.Text = "";
txtAgentLevelName.Focus();
}
else
{
this.Close();
}
}
else
{
MessageBox.Show("保存失败！", "软件提示");
}
}
if (this.Tag.ToString() == "Edit")
{
DataGridViewRow dgvr = formAgentLevel.dgvAgentLevel.CurrentRow;
dgvr.Cells["AgentLevelName"].Value = txtAgentLevelName.Text.Trim();
dgvr.Cells["LeastMoney"].Value = Convert.ToDecimal(txtLeastMoney.Text);
dgvr.Cells["Discount"].Value = Convert.ToDecimal(txtDiscount.Text);
if (al.Update(formAgentLevel.dgvAgentLevel, formAgentLevel.bsAgentLevel))
{
MessageBox.Show("保存成功！", "软件提示");
this.Close();
}
else
{
MessageBox.Show("保存失败！", "软件提示");
}
}
}
