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;
}
/// <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;
}