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]);
            }
        }
예제 #2
0
        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));
        }
예제 #3
0
 private void SelectInformationDate_Load(object sender, EventArgs e)
 {
     ParamterrMakeSql1 = new ParamterrMakeSql();
 }