dtToSList = sqlAccess.ExecuteTable(CommandText);

   ToSNo = Convert.ToString(dtToSList.Rows[i].ItemArray[1]);

      if (Convert.ToInt32(sqlAccess.ExecuteScalar(CommandText)) > 0)

            {

                string LastToSID;

                CommandText = "SELECT ToSNo FROM OverSystems_ToSInfo where ToSNo like '" + NewToSID + "%' order by ToSNo desc";

                LastToSID = Convert.ToString(sqlAccess.ExecuteScalar(CommandText)).Substring(4);

                if (LastToSID.IndexOf("-") >= 0)

                    LastToSID = LastToSID.Substring(0, LastToSID.IndexOf("-"));

                NewToSID += (Convert.ToInt32(LastToSID) + 1).ToString("000");

            }

			//所选合同中都没有子项。因此注释寻找最大值代码。

                //dtPom = pc.GetPoMaster(" where ToSNO like '" + Ponum + "%' order by PoID desc ");

                int max = 0;

                //for (int v = 0; v < dtPom.Rows.Count; v++)

                //{

                //    //编号'-'后的最大值

                //    int[] num = new int[1000];

                //    for (int c = 0; c < dtPom.Rows.Count; c++)

                //    {

                //        string Pono = Convert.ToString(dtPom.Rows[c]["ToSNO"]);

                //        if (Pono.Contains("-"))

                //        {

                //            string pn = Pono.Split('-')[1];

                //            num[c] = Convert.ToInt32(pn);

                //        }

                //    }

                //     max = num.Max();

                //}