/// <summary>
/// 调用存储过程修改一个
/// </summary>
/// <param name="info">实体对象</param>
/// <returns>更新成功返回ture，否则返回false</returns>
public static bool FenShengYuanXiaoLuQuEdit(Entity.FenShengYuanXiaoLuQu info)
{
SqlParameter[] prams =
{
SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id),
SqlDB.MakeInParam("@DataYear", SqlDbType.Int, 4, info.DataYear),
SqlDB.MakeInParam("@ProvinceId", SqlDbType.Int, 4, info.ProvinceId),
SqlDB.MakeInParam("@ShengShi", SqlDbType.NVarChar, 15, info.ShengShi),
SqlDB.MakeInParam("@CengCi", SqlDbType.Int, 4, info.CengCi),
SqlDB.MakeInParam("@PiCi", SqlDbType.Int, 4, info.PiCi),
SqlDB.MakeInParam("@PcLeiBie", SqlDbType.Int, 4, info.PcLeiBie),
SqlDB.MakeInParam("@KeLei", SqlDbType.Int, 4, info.KeLei),
SqlDB.MakeInParam("@KeLeiMingCheng", SqlDbType.NVarChar, 50, info.KeLeiMingCheng),
SqlDB.MakeInParam("@SchoolId", SqlDbType.Int, 4, info.SchoolId),
SqlDB.MakeInParam("@SchoolProvinceId", SqlDbType.Int, 4, info.SchoolProvinceId),
SqlDB.MakeInParam("@YuanXiaoDaiMa", SqlDbType.Char, 5, info.YuanXiaoDaiMa),
SqlDB.MakeInParam("@YuanXiaoMingCheng", SqlDbType.NVarChar, 64, info.YuanXiaoMingCheng),
SqlDB.MakeInParam("@ZuiGaoFen", SqlDbType.Int, 4, info.ZuiGaoFen),
SqlDB.MakeInParam("@PingJunFen", SqlDbType.Int, 4, info.PingJunFen),
SqlDB.MakeInParam("@ZuiDiFen", SqlDbType.Int, 4, info.ZuiDiFen),
SqlDB.MakeInParam("@ZuiDaWeiCi", SqlDbType.Int, 4, info.ZuiDaWeiCi),
SqlDB.MakeInParam("@PingJunWeiCi", SqlDbType.Int, 4, info.PingJunWeiCi),
SqlDB.MakeInParam("@ZuiXiaoWeiCi", SqlDbType.Int, 4, info.ZuiXiaoWeiCi),
SqlDB.MakeInParam("@PiCiXian", SqlDbType.Int, 4, info.PiCiXian),
SqlDB.MakeInParam("@PingJunXianCha", SqlDbType.Int, 4, info.PingJunXianCha),
SqlDB.MakeInParam("@JiHuaShu", SqlDbType.Int, 4, info.JiHuaShu),
SqlDB.MakeInParam("@TouDangBiLi", SqlDbType.Int, 4, info.TouDangBiLi),
SqlDB.MakeInParam("@TouChuShu", SqlDbType.Int, 4, info.TouChuShu),
SqlDB.MakeInParam("@LuQuShu", SqlDbType.Int, 4, info.LuQuShu),
SqlDB.MakeInParam("@TouChuZuiDiFen", SqlDbType.Int, 4, info.TouChuZuiDiFen),
SqlDB.MakeInParam("@TouChuZuiGaoFen", SqlDbType.Int, 4, info.TouChuZuiGaoFen),
SqlDB.MakeInParam("@TouChuZuiXiaoWeiCi", SqlDbType.Int, 4, info.TouChuZuiXiaoWeiCi),
SqlDB.MakeInParam("@TouChuZuiDaWeiCi", SqlDbType.Int, 4, info.TouChuZuiDaWeiCi),
SqlDB.MakeInParam("@IsBuLu", SqlDbType.Int, 4, info.IsBuLu),
};
int intReturnValue = 0;
intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "FenShengYuanXiaoLuQuEdit", prams);
if (intReturnValue == 1)
{
return(true);
}
return(false);
}
public static Entity.FenShengYuanXiaoLuQu FenShengYuanXiaoLuQuAllEntityGet(int ProvinceId, int PiCi, int KeLei, int SchoolId, string strDataYear)
{
Entity.FenShengYuanXiaoLuQu info = new Entity.FenShengYuanXiaoLuQu();
DataTable dt = SqlDB.ExecuteDataset(CommandType.Text, "SELECT * FROM [" + DAL.Common.GetYearTableName("FenShengYuanXiaoLuQu", "All") + "] WHERE DataYear = " + strDataYear + " AND ProvinceId = " + ProvinceId + " AND PiCi = " + PiCi + " AND KeLei = " + KeLei + " AND SchoolId = " + SchoolId).Tables[0];
if (dt.Rows.Count > 0)
{
info.Id = Basic.Utils.StrToInt(dt.Rows[0]["Id"].ToString(), 0);
info.DataYear = Basic.Utils.StrToInt(dt.Rows[0]["DataYear"].ToString(), 0);
info.ProvinceId = Basic.Utils.StrToInt(dt.Rows[0]["ProvinceId"].ToString(), 0);
info.ShengShi = dt.Rows[0]["ShengShi"].ToString();
info.CengCi = Basic.Utils.StrToInt(dt.Rows[0]["CengCi"].ToString(), 0);
info.PiCi = Basic.Utils.StrToInt(dt.Rows[0]["PiCi"].ToString(), 0);
info.PcLeiBie = Basic.Utils.StrToInt(dt.Rows[0]["PcLeiBie"].ToString(), 0);
info.KeLei = Basic.Utils.StrToInt(dt.Rows[0]["KeLei"].ToString(), 0);
info.KeLeiMingCheng = dt.Rows[0]["KeLeiMingCheng"].ToString();
info.SchoolId = Basic.Utils.StrToInt(dt.Rows[0]["SchoolId"].ToString(), 0);
info.SchoolProvinceId = Basic.Utils.StrToInt(dt.Rows[0]["SchoolProvinceId"].ToString(), 0);
info.YuanXiaoDaiMa = dt.Rows[0]["YuanXiaoDaiMa"].ToString();
info.YuanXiaoMingCheng = dt.Rows[0]["YuanXiaoMingCheng"].ToString();
info.ZuiGaoFen = Basic.Utils.StrToInt(dt.Rows[0]["ZuiGaoFen"].ToString(), 0);
info.PingJunFen = Basic.Utils.StrToInt(dt.Rows[0]["PingJunFen"].ToString(), 0);
info.ZuiDiFen = Basic.Utils.StrToInt(dt.Rows[0]["ZuiDiFen"].ToString(), 0);
info.ZuiDaWeiCi = Basic.Utils.StrToInt(dt.Rows[0]["ZuiDaWeiCi"].ToString(), 0);
info.PingJunWeiCi = Basic.Utils.StrToInt(dt.Rows[0]["PingJunWeiCi"].ToString(), 0);
info.ZuiXiaoWeiCi = Basic.Utils.StrToInt(dt.Rows[0]["ZuiXiaoWeiCi"].ToString(), 0);
info.PiCiXian = Basic.Utils.StrToInt(dt.Rows[0]["PiCiXian"].ToString(), 0);
info.PingJunXianCha = Basic.Utils.StrToInt(dt.Rows[0]["PingJunXianCha"].ToString(), 0);
info.JiHuaShu = Basic.Utils.StrToInt(dt.Rows[0]["JiHuaShu"].ToString(), 0);
info.TouDangBiLi = Basic.Utils.StrToInt(dt.Rows[0]["TouDangBiLi"].ToString(), 0);
info.TouChuShu = Basic.Utils.StrToInt(dt.Rows[0]["TouChuShu"].ToString(), 0);
info.LuQuShu = Basic.Utils.StrToInt(dt.Rows[0]["LuQuShu"].ToString(), 0);
info.TouChuZuiDiFen = Basic.Utils.StrToInt(dt.Rows[0]["TouChuZuiDiFen"].ToString(), 0);
info.TouChuZuiGaoFen = Basic.Utils.StrToInt(dt.Rows[0]["TouChuZuiGaoFen"].ToString(), 0);
info.TouChuZuiXiaoWeiCi = Basic.Utils.StrToInt(dt.Rows[0]["TouChuZuiXiaoWeiCi"].ToString(), 0);
info.TouChuZuiDaWeiCi = Basic.Utils.StrToInt(dt.Rows[0]["TouChuZuiDaWeiCi"].ToString(), 0);
info.IsBuLu = Basic.Utils.StrToInt(dt.Rows[0]["IsBuLu"].ToString(), 0);
}
return(info);
}
/// <summary>
/// 调用存储过程增加一个
/// </summary>
/// <param name="info">实体对象</param>
/// <returns>正常返回大于 0 的自增id, 0代表重复，否则返回-1</returns>
public static int FenShengYuanXiaoLuQuAdd(Entity.FenShengYuanXiaoLuQu info)
{
SqlParameter[] prams =
{
SqlDB.MakeInParam("@DataYear", SqlDbType.Int, 4, info.DataYear),
SqlDB.MakeInParam("@ProvinceId", SqlDbType.Int, 4, info.ProvinceId),
SqlDB.MakeInParam("@ShengShi", SqlDbType.NVarChar, 15, info.ShengShi),
SqlDB.MakeInParam("@CengCi", SqlDbType.Int, 4, info.CengCi),
SqlDB.MakeInParam("@PiCi", SqlDbType.Int, 4, info.PiCi),
SqlDB.MakeInParam("@PcLeiBie", SqlDbType.Int, 4, info.PcLeiBie),
SqlDB.MakeInParam("@KeLei", SqlDbType.Int, 4, info.KeLei),
SqlDB.MakeInParam("@KeLeiMingCheng", SqlDbType.NVarChar, 50, info.KeLeiMingCheng),
SqlDB.MakeInParam("@SchoolId", SqlDbType.Int, 4, info.SchoolId),
SqlDB.MakeInParam("@SchoolProvinceId", SqlDbType.Int, 4, info.SchoolProvinceId),
SqlDB.MakeInParam("@YuanXiaoDaiMa", SqlDbType.Char, 5, info.YuanXiaoDaiMa),
SqlDB.MakeInParam("@YuanXiaoMingCheng", SqlDbType.NVarChar, 64, info.YuanXiaoMingCheng),
SqlDB.MakeInParam("@ZuiGaoFen", SqlDbType.Int, 4, info.ZuiGaoFen),
SqlDB.MakeInParam("@PingJunFen", SqlDbType.Int, 4, info.PingJunFen),
SqlDB.MakeInParam("@ZuiDiFen", SqlDbType.Int, 4, info.ZuiDiFen),
SqlDB.MakeInParam("@ZuiDaWeiCi", SqlDbType.Int, 4, info.ZuiDaWeiCi),
SqlDB.MakeInParam("@PingJunWeiCi", SqlDbType.Int, 4, info.PingJunWeiCi),
SqlDB.MakeInParam("@ZuiXiaoWeiCi", SqlDbType.Int, 4, info.ZuiXiaoWeiCi),
SqlDB.MakeInParam("@PiCiXian", SqlDbType.Int, 4, info.PiCiXian),
SqlDB.MakeInParam("@PingJunXianCha", SqlDbType.Int, 4, info.PingJunXianCha),
SqlDB.MakeInParam("@JiHuaShu", SqlDbType.Int, 4, info.JiHuaShu),
SqlDB.MakeInParam("@TouDangBiLi", SqlDbType.Int, 4, info.TouDangBiLi),
SqlDB.MakeInParam("@TouChuShu", SqlDbType.Int, 4, info.TouChuShu),
SqlDB.MakeInParam("@LuQuShu", SqlDbType.Int, 4, info.LuQuShu),
SqlDB.MakeInParam("@TouChuZuiDiFen", SqlDbType.Int, 4, info.TouChuZuiDiFen),
SqlDB.MakeInParam("@TouChuZuiGaoFen", SqlDbType.Int, 4, info.TouChuZuiGaoFen),
SqlDB.MakeInParam("@TouChuZuiXiaoWeiCi", SqlDbType.Int, 4, info.TouChuZuiXiaoWeiCi),
SqlDB.MakeInParam("@TouChuZuiDaWeiCi", SqlDbType.Int, 4, info.TouChuZuiDaWeiCi),
SqlDB.MakeInParam("@IsBuLu", SqlDbType.Int, 4, info.IsBuLu),
};
return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "FenShengYuanXiaoLuQuAdd", prams).ToString(), -1));
}