ludy

GetMaxID 获取列表中的最大值

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////   
/// <summary>
  /// 获得数据列表
  /// </summary>
  public DataSet GetList(string strWhere)
  {
   StringBuilder strSql=new StringBuilder();
   strSql.Append("select ID,StuID,StuName,StuSex,StuBir,StuNation,MajorID,ClassID,StuRegisterID,StuPropertyID,StuNative,StuBirthPlace,StuIDCard,StuEnterTime,StuHealthState,StuFamilyPost,StuFamilyAddress,StuFamilyPhone1,StuFamilyPhone2,StuFamilyPhone3,StuPhone,StuAddr,StuFather,StuMather,StuOtherGuardian,Email,StuForeignLevel,StuPolity,StuComputerLevel,StuCultureWay,StuSkillLevel,StuPhoto,PracticeOrNot,PracticePlace,GraduateOrNot,GraduatePlace,InsureOrNot,Degree2,Up ");
   strSql.Append(" FROM T_StudentInfo ")
   if(strWhere.Trim()!="")//string string .Trim()(+1重载)从此实例的开始位置和末尾移除空白字符的所有空白项
   {
    strSql.Append(" where 1=1 "+strWhere);
   }
   return DbHelperSQL.Query(strSql.ToString());
  }


////////////////////////////////////////////////////////////////////////////////////////////////////////////
DataSet ds_Stu = dStu.GetList(" and stuID like '%" + stuID + "%'");
stuID += GetMaxID(ds_Stu);
////////////////////////////////////////////////////////////////////////////////////////////////////////////

private string GetMaxID(DataSet ds_Stu)
    {
        bool flag = false;
        string jj = "01";
        for (int i = 1; i <= ds_Stu.Tables[0].Rows.Count; i++)
        {
            for (int j = 0; j < ds_Stu.Tables[0].Rows.Count; j++)
            {
                string ii = i.ToString();
                if (i.ToString().Length == 1)
                {
                    ii = "0" + i.ToString();
                }
                if (ii == ds_Stu.Tables[0].Rows[j]["stuID"].ToString().Substring(9, 2))
                    break;
                else if (j == ds_Stu.Tables[0].Rows.Count - 1)
                {
                    jj = ii;
                    return jj;
                }
            }
        }
        return jj;
    }

posted on 2008-07-11 11:44  ludy  阅读(1226)  评论(0编辑  收藏  举报

导航