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(); }