public void Join(ParamterrMakeSql ParamterrMakeSql)
{
for (int i = 0; i < ParamterrMakeSql.ListObject.Count; i++)
{
this.ListEnum.Add(ParamterrMakeSql.ListEnum[i]);
ListObject.Add(ParamterrMakeSql.ListObject[i]);
listCommandOutDataObject.Add(ParamterrMakeSql.listCommandOutDataObject[i]);
ListCondetion.Add(ParamterrMakeSql.ListCondetion[i]);
ListProssesEnum.Add(ParamterrMakeSql.ListProssesEnum[i]);
ListCondetionBetwen.Add(ParamterrMakeSql.ListCondetionBetwen[i]);
}
for (int i = 0; i < ParamterrMakeSql.ListOutPut.Count; i++)
{
ListOutPut.Add(ParamterrMakeSql.ListOutPut[i]);
ListProssessOutput.Add(ParamterrMakeSql.ListOutPut[i], ListProssessOutput[ParamterrMakeSql.ListOutPut[i]]);
ListoutPutNameTab.Add(ParamterrMakeSql.ListoutPutNameTab[i]);
}
for (int i = 0; i < ParamterrMakeSql.ListOfInner.Count; i++)
{
ListOfInner.Add(ParamterrMakeSql.ListOfInner[i]);
}
}
private async void Test_Load(object sender, EventArgs e)
{
ParamterrMakeSql Parm = new ParamterrMakeSql();
Parm.AdderParmtaer(Vitl.vitl.data_barthday, new DateTime(2000, 1, 1), ParamterrMakeSql.Condtion.lessThen, ParamterrMakeSql.Between.And);
Parm.AdderinnerJoin(new EnumInnder(Sqldatabasethrding.DataBaseTabName.Couress_ta, Sqldatabasethrding.DataBaseTabName.Information_Ta, Vitl.vitl.id, Sqldatabasethrding.DataBaseTabName.Couress_ta, Couress.EnumCouress.Id_Information));
Parm.AdderinnerJoin(new EnumInnder(Sqldatabasethrding.DataBaseTabName.Team_ta, Sqldatabasethrding.DataBaseTabName.Information_Ta, Vitl.vitl.id, Sqldatabasethrding.DataBaseTabName.Team_ta, Team.EnumTeam.ID_informtion));
Parm.AdderOutPut(Vitl.vitl.id, Sqldatabasethrding.DataBaseTabName.Information_Ta);
Parm.AdderOutPut(Vitl.vitl.Gender);
Parm.AdderOutPut(Vitl.vitl.first_name);
Parm.AdderOutPut(Vitl.vitl.Last_name);
// List<List<object>> list = await Sqldatabasethrding.GetSql( Vitl.SqlFildRetunFormList(Parm));
}
private void SelectInformationDate_Load(object sender, EventArgs e)
{
ParamterrMakeSql1 = new ParamterrMakeSql();
}
