/// <summary>
///查询某种规则下先有记录最大数 chenbing 2014-03-05
/// </summary>
/// <param name="blnum"></param>
/// <returns></returns>
protected Dictionary<string,int> GetMaxList(string rule,ref string blnum)
{
Dictionary<string, int> dic = new Dictionary<string, int>();
dic.Add("A",0);
dic.Add("B", 0);
dic.Add("C", 0);
dic.Add("A兼B", 0);
dic.Add("B兼C", 0);
System.Data.DataTable dt = da.GetTable("select a.*, c.name as bmlbname from dbo.Enterprise_WorkersMark a join dbo.smn_User b on a.WorkerID=b.ID join BMLB c on b.BMLB=c.[key] where a.cerNo like '" +rule+ "%'");//txtBef.Text.Trim()
//如果dt表有记录说明规则已存在
if (dt != null)
{
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string cerNo = dr["cerNo"].ToString();
cerNo = cerNo.Replace(dr["bmlbname"].ToString(), "");//去掉证书编号中报名类别内容
blnum = cerNo.Replace(rule,"");
switch (dr["bmlbname"].ToString())
{
case "A":
if (int.Parse(blnum) > dic["A"])
dic["A"] = int.Parse(blnum);
break;
case "B":
if (int.Parse(blnum) > dic["B"])
dic["B"] = int.Parse(blnum);
break;
case "C":
if (int.Parse(blnum) > dic["C"])
dic["C"] = int.Parse(blnum);
break;
case "A兼B":
if (int.Parse(blnum) > dic["A兼B"])
dic["A兼B"] = int.Parse(blnum);
break;
case "B兼C":
if (int.Parse(blnum) > dic["B兼C"])
dic["B兼C"] = int.Parse(blnum);
break;
}
}
}
}
return dic;
}