public static Entity.ProvinceWeiCi ProvinceWeiCiEntityGetByFenShu(int FenShu, int DataYear, int ProvinceId, int KeLei, int PiCi) { Entity.ProvinceWeiCi info = new Entity.ProvinceWeiCi(); string strSql = "SELECT TOP 1 * FROM [ProvinceWeiCi] WHERE ProvinceId = " + ProvinceId + " AND KeLei = " + KeLei + " AND FenShu <= " + FenShu + " AND [DataYear]=" + DataYear + " AND PiCi = " + PiCi + " ORDER BY IsKaoshiyuan DESC,WeiCi ASC,PiCi asc "; DataTable dt = SqlDB.ExecuteDataset(CommandType.Text, strSql).Tables[0]; if (dt.Rows.Count > 0) { info.Id = Basic.Utils.StrToInt(dt.Rows[0]["Id"].ToString(), 0); info.ProvinceName = dt.Rows[0]["ProvinceName"].ToString(); info.ProvinceId = Basic.Utils.StrToInt(dt.Rows[0]["ProvinceId"].ToString(), 0); info.KeLeiMingCheng = dt.Rows[0]["KeLeiMingCheng"].ToString(); info.KeLei = Basic.Utils.StrToInt(dt.Rows[0]["KeLei"].ToString(), 0); info.DataYear = Basic.Utils.StrToInt(dt.Rows[0]["DataYear"].ToString(), 0); info.FenShu = Basic.Utils.StrToInt(dt.Rows[0]["FenShu"].ToString(), 0); info.RenShu = Basic.Utils.StrToInt(dt.Rows[0]["RenShu"].ToString(), 0); info.LeiJiRenShu = Basic.Utils.StrToInt(dt.Rows[0]["LeiJiRenShu"].ToString(), 0); info.WeiCi = Basic.Utils.StrToInt(dt.Rows[0]["WeiCi"].ToString(), 0); info.IsKaoShiYuan = Basic.Utils.StrToInt(dt.Rows[0]["IsKaoShiYuan"].ToString(), 0); info.FenGe = Basic.Utils.StrToInt(dt.Rows[0]["FenGe"].ToString(), 0); } else { return(null); } return(info); }
public static Entity.StudentChengJi GetZheJiangUserPiCi(Entity.FenShuXian fenshuxian, int FenShu, int DataYear, int ProvinceId, int KeLei) { Entity.StudentChengJi studentChengJi = new Entity.StudentChengJi(); int PcFirst = fenshuxian.PcFirst; int PcSecond = fenshuxian.PcSecond; int PcThird = fenshuxian.PcThird; int ZkFirst = fenshuxian.ZkFirst; int ZkSecond = fenshuxian.ZkSecond; if (FenShu >= PcFirst) { studentChengJi.PiCi = 1; studentChengJi.XianChaShang = 0; //上一批次的线差 studentChengJi.XianCha = FenShu - PcFirst; //批次线差 studentChengJi.PiCiXian = PcFirst; } else if (FenShu >= PcSecond) { studentChengJi.PiCi = 2; studentChengJi.XianChaShang = PcFirst - FenShu; //上一批次的线差 studentChengJi.XianCha = FenShu - PcSecond; //批次线差 studentChengJi.PiCiXian = PcSecond; } else if (PcThird != 0 && FenShu >= PcThird) { studentChengJi.PiCi = 3; studentChengJi.XianChaShang = PcSecond - FenShu; //上一批次的线差 studentChengJi.XianCha = FenShu - PcThird; //批次线差 studentChengJi.PiCiXian = PcThird; } else if (ZkFirst != 0 && FenShu >= ZkFirst) { studentChengJi.PiCi = 4; studentChengJi.XianChaShang = (PcThird == 0 ? PcSecond : PcThird) - FenShu; //上一批次的线差 studentChengJi.XianCha = FenShu - ZkFirst; //批次线差 studentChengJi.PiCiXian = ZkFirst; } else if (ZkSecond != 0 && FenShu >= ZkSecond) { studentChengJi.PiCi = 5; studentChengJi.XianChaShang = ZkFirst - FenShu; //上一批次的线差 studentChengJi.XianCha = FenShu - ZkSecond; //批次线差 studentChengJi.PiCiXian = ZkSecond; } else { studentChengJi.PiCi = 0; studentChengJi.XianChaShang = 0; //上一批次的线差 studentChengJi.XianCha = 0; //批次线差 studentChengJi.PiCiXian = 0; } //下面根据成绩来取位次等信息 Entity.ProvinceWeiCi provinceWeiCi = DAL.ProvinceWeiCi.ProvinceWeiCiEntityGetByFenShu(FenShu, DataYear, ProvinceId, KeLei); if (provinceWeiCi == null) { studentChengJi.WeiCi = 0; studentChengJi.RenShu = 0; studentChengJi.LeiJiRenShu = 0; } else { studentChengJi.WeiCi = provinceWeiCi.WeiCi; studentChengJi.RenShu = provinceWeiCi.RenShu; studentChengJi.LeiJiRenShu = provinceWeiCi.LeiJiRenShu; } studentChengJi.FenShu = FenShu; return(studentChengJi); }