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