/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool Join_ZhongKeResultsEdit(Entity.Join_ZhongKeResults info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@UserId", SqlDbType.Int, 4, info.UserId), SqlDB.MakeInParam("@BeiDong", SqlDbType.Int, 4, info.BeiDong), SqlDB.MakeInParam("@YanXue", SqlDbType.Int, 4, info.YanXue), SqlDB.MakeInParam("@XinXiCaiJi", SqlDbType.Int, 4, info.XinXiCaiJi), SqlDB.MakeInParam("@FangFa", SqlDbType.Int, 4, info.FangFa), SqlDB.MakeInParam("@BiJiao", SqlDbType.Int, 4, info.BiJiao), SqlDB.MakeInParam("@ZiJian", SqlDbType.Int, 4, info.ZiJian), SqlDB.MakeInParam("@QuDao", SqlDbType.Int, 4, info.QuDao), SqlDB.MakeInParam("@FenXi", SqlDbType.Int, 4, info.FenXi), SqlDB.MakeInParam("@ZiKong", SqlDbType.Int, 4, info.ZiKong), SqlDB.MakeInParam("@GouTong", SqlDbType.Int, 4, info.GouTong), SqlDB.MakeInParam("@SiWei", SqlDbType.Int, 4, info.SiWei), SqlDB.MakeInParam("@ChengDan", SqlDbType.Int, 4, info.ChengDan), SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "Join_ZhongKeResultsEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool StudentGaoKaoHistory_ZheJiangEdit(Entity.StudentGaoKaoHistory_ZheJiang info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@StudentId", SqlDbType.Int, 4, info.StudentId), SqlDB.MakeInParam("@YuWen", SqlDbType.Int, 4, info.YuWen), SqlDB.MakeInParam("@ShuXue", SqlDbType.Int, 4, info.ShuXue), SqlDB.MakeInParam("@YingYu", SqlDbType.Int, 4, info.YingYu), SqlDB.MakeInParam("@ZongHe", SqlDbType.Int, 4, info.ZongHe), SqlDB.MakeInParam("@ZiXuan", SqlDbType.Int, 4, info.ZiXuan), SqlDB.MakeInParam("@JiShu", SqlDbType.Int, 4, info.JiShu), SqlDB.MakeInParam("@ZongFen1", SqlDbType.Int, 4, info.ZongFen1), SqlDB.MakeInParam("@ZongFen2", SqlDbType.Int, 4, info.ZongFen2), SqlDB.MakeInParam("@ZongFen3", SqlDbType.Int, 4, info.ZongFen3), SqlDB.MakeInParam("@IsGaoKao", SqlDbType.Int, 4, info.IsGaoKao), SqlDB.MakeInParam("@IsLatest", SqlDbType.Int, 4, info.IsLatest), SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "StudentGaoKaoHistory_ZheJiangEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int BenKeFenShuAdd(Entity.BenKeFenShu info) { SqlParameter[] prams = { SqlDB.MakeInParam("@DataYear", SqlDbType.Int, 4, info.DataYear), SqlDB.MakeInParam("@KaoShengHao", SqlDbType.VarChar, 50, info.KaoShengHao), SqlDB.MakeInParam("@ccdm", SqlDbType.VarChar, 50, info.Ccdm), SqlDB.MakeInParam("@KeLei", SqlDbType.Int, 4, info.KeLei), SqlDB.MakeInParam("@KeLeiDaiMa", SqlDbType.VarChar, 50, info.KeLeiDaiMa), SqlDB.MakeInParam("@SchoolId", SqlDbType.Int, 4, info.SchoolId), SqlDB.MakeInParam("@YuanXiaoDaiMa", SqlDbType.VarChar, 50, info.YuanXiaoDaiMa), SqlDB.MakeInParam("@YuanXiaoMingCheng", SqlDbType.VarChar, 500, info.YuanXiaoMingCheng), SqlDB.MakeInParam("@ZyId", SqlDbType.Int, 4, info.ZyId), SqlDB.MakeInParam("@ZhuanYeDaiMa", SqlDbType.VarChar, 50, info.ZhuanYeDaiMa), SqlDB.MakeInParam("@ZhuanYeMingCheng", SqlDbType.VarChar, 500, info.ZhuanYeMingCheng), SqlDB.MakeInParam("@LuQuPiCi", SqlDbType.VarChar, 50, info.LuQuPiCi), SqlDB.MakeInParam("@PiCi", SqlDbType.Int, 4, info.PiCi), SqlDB.MakeInParam("@PcLeiBie", SqlDbType.Int, 4, info.PcLeiBie), SqlDB.MakeInParam("@FenShu", SqlDbType.Int, 4, info.FenShu), SqlDB.MakeInParam("@WeiCi", SqlDbType.Int, 4, info.WeiCi), SqlDB.MakeInParam("@PiCiXian", SqlDbType.Int, 4, info.PiCiXian), SqlDB.MakeInParam("@IsAbove", SqlDbType.Int, 4, info.IsAbove), SqlDB.MakeInParam("@ShengShi", SqlDbType.VarChar, 10, info.ShengShi), SqlDB.MakeInParam("@ShengShiDaiMa", SqlDbType.VarChar, 10, info.ShengShiDaiMa), SqlDB.MakeInParam("@ProvinceId", SqlDbType.Int, 4, info.ProvinceId), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "BenKeFenShuAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int FenShengZhuanYeLuQuAdd(Entity.FenShengZhuanYeLuQu 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("@KeLeiDaiMa", SqlDbType.Char, 1, info.KeLeiDaiMa), 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("@ZyId", SqlDbType.Int, 4, info.ZyId), SqlDB.MakeInParam("@ZhuanYeDaiMa", SqlDbType.Char, 50, info.ZhuanYeDaiMa), SqlDB.MakeInParam("@ZhuanYeMingCheng", SqlDbType.NVarChar, 50, info.ZhuanYeMingCheng), SqlDB.MakeInParam("@ZyZuiGaoFen", SqlDbType.Int, 4, info.ZyZuiGaoFen), SqlDB.MakeInParam("@ZyPingJunFen", SqlDbType.Int, 4, info.ZyPingJunFen), SqlDB.MakeInParam("@ZyPiCiXian", SqlDbType.Int, 4, info.ZyPiCiXian), SqlDB.MakeInParam("@ZyPingJunXianCha", SqlDbType.Int, 4, info.ZyPingJunXianCha), SqlDB.MakeInParam("@ZyZuiDiFen", SqlDbType.Int, 4, info.ZyZuiDiFen), SqlDB.MakeInParam("@ZyZuiDaWeiCi", SqlDbType.Int, 4, info.ZyZuiDaWeiCi), SqlDB.MakeInParam("@ZyPingJunWeiCi", SqlDbType.Int, 4, info.ZyPingJunWeiCi), SqlDB.MakeInParam("@ZyZuiXiaoWeiCi", SqlDbType.Int, 4, info.ZyZuiXiaoWeiCi), SqlDB.MakeInParam("@ZYLuQuShu", SqlDbType.Int, 4, info.ZYLuQuShu), SqlDB.MakeInParam("@ZyProvinceCount", SqlDbType.Int, 4, info.ZyProvinceCount), SqlDB.MakeInParam("@ZyCountryCount", SqlDbType.Int, 4, info.ZyCountryCount), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "FenShengZhuanYeLuQuAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool ProvincePiCiEdit(Entity.ProvincePiCi info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@ProvinceId", SqlDbType.Int, 4, info.ProvinceId), SqlDB.MakeInParam("@LeiBie", SqlDbType.Int, 4, info.LeiBie), 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("@PcName", SqlDbType.NVarChar, 50, info.PcName), SqlDB.MakeInParam("@PcIntro", SqlDbType.NVarChar, 500, info.PcIntro), SqlDB.MakeInParam("@CkFsx", SqlDbType.Int, 4, info.CkFsx), SqlDB.MakeInParam("@MajorCount", SqlDbType.Int, 4, info.MajorCount), SqlDB.MakeInParam("@IsPause", SqlDbType.Int, 4, info.IsPause), SqlDB.MakeInParam("@ShowOrder", SqlDbType.Int, 4, info.ShowOrder), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "ProvincePiCiEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool StudentZhiYuanEdit(Entity.StudentZhiYuan info) { SqlParameter[] prams = { SqlDB.MakeInParam("@id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@ProvincePcId", SqlDbType.Int, 4, info.ProvincePcId), SqlDB.MakeInParam("@ProvinceZhiYuanId", SqlDbType.Int, 4, info.ProvinceZhiYuanId), SqlDB.MakeInParam("@SchoolId", SqlDbType.Int, 4, info.SchoolId), SqlDB.MakeInParam("@SchoolName", SqlDbType.NVarChar, 100, info.SchoolName), SqlDB.MakeInParam("@MajorList", SqlDbType.NVarChar, 1000, info.MajorList), SqlDB.MakeInParam("@MajorCount", SqlDbType.Int, 4, info.MajorCount), SqlDB.MakeInParam("@IsTiaoJi", SqlDbType.Int, 4, info.IsTiaoJi), SqlDB.MakeInParam("@IsAllMajor", SqlDbType.Int, 4, info.IsAllMajor), SqlDB.MakeInParam("@StudentId", SqlDbType.Int, 4, info.StudentId), SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime), SqlDB.MakeInParam("@Memo", SqlDbType.NVarChar, 500, info.Memo), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "StudentZhiYuanEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool GaoKaoCardEdit(Entity.GaoKaoCard info) { SqlParameter[] prams = { SqlDB.MakeInParam("@ID", SqlDbType.Int, 4, info.ID), SqlDB.MakeInParam("@KaHao", SqlDbType.NVarChar, 50, info.KaHao), SqlDB.MakeInParam("@MiMa", SqlDbType.NVarChar, 50, info.MiMa), SqlDB.MakeInParam("@StudentId", SqlDbType.Int, 4, info.StudentId), SqlDB.MakeInParam("@ProvinceId", SqlDbType.Int, 4, info.ProvinceId), SqlDB.MakeInParam("@Belong", SqlDbType.Int, 4, info.Belong), SqlDB.MakeInParam("@DianId", SqlDbType.Int, 4, info.DianId), SqlDB.MakeInParam("@CardLevel", SqlDbType.Int, 4, info.CardLevel), SqlDB.MakeInParam("@IsPause", SqlDbType.Int, 4, info.IsPause), SqlDB.MakeInParam("@RegisterDate", SqlDbType.DateTime, 8, info.RegisterDate), SqlDB.MakeInParam("@AllowChangeCount", SqlDbType.Int, 4, info.AllowChangeCount), SqlDB.MakeInParam("@HaveChangeCount", SqlDbType.Int, 4, info.HaveChangeCount), SqlDB.MakeInParam("@EndTime", SqlDbType.DateTime, 8, info.EndTime), SqlDB.MakeInParam("@Memo", SqlDbType.NVarChar, 500, info.Memo), SqlDB.MakeInParam("@DingDanHao", SqlDbType.NVarChar, 100, info.DingDanHao), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "GaoKaoCardEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool shijuanEdit(Entity.shijuan info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@OldId", SqlDbType.Int, 4, info.OldId), SqlDB.MakeInParam("@name", SqlDbType.NVarChar, 128, info.name), SqlDB.MakeInParam("@exam_type", SqlDbType.Int, 4, info.exam_type), SqlDB.MakeInParam("@subject_id", SqlDbType.Int, 4, info.subject_id), SqlDB.MakeInParam("@section_id", SqlDbType.Int, 4, info.section_id), SqlDB.MakeInParam("@grade_id", SqlDbType.Int, 4, info.grade_id), SqlDB.MakeInParam("@province_id", SqlDbType.VarChar, 6, info.province_id), SqlDB.MakeInParam("@content", SqlDbType.NVarChar, 4000, info.content), SqlDB.MakeInParam("@year", SqlDbType.NVarChar, 50, info.year), SqlDB.MakeInParam("@score", SqlDbType.Int, 4, info.score), SqlDB.MakeInParam("@source", SqlDbType.NVarChar, 200, info.source), SqlDB.MakeInParam("@exam_time", SqlDbType.Int, 4, info.exam_time), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "shijuanEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool Join_ProfessionResultsEdit(Entity.Join_ProfessionResults info) { SqlParameter[] prams = { SqlDB.MakeInParam("@ProfessionResultsId", SqlDbType.Int, 4, info.ProfessionResultsId), SqlDB.MakeInParam("@UserId", SqlDbType.Int, 4, info.UserId), SqlDB.MakeInParam("@Group1", SqlDbType.Int, 4, info.Group1), SqlDB.MakeInParam("@Group2", SqlDbType.Int, 4, info.Group2), SqlDB.MakeInParam("@Group3", SqlDbType.Int, 4, info.Group3), SqlDB.MakeInParam("@Group4", SqlDbType.Int, 4, info.Group4), SqlDB.MakeInParam("@Group5", SqlDbType.Int, 4, info.Group5), SqlDB.MakeInParam("@Group6", SqlDbType.Int, 4, info.Group6), SqlDB.MakeInParam("@Group7", SqlDbType.Int, 4, info.Group7), SqlDB.MakeInParam("@Group8", SqlDbType.Int, 4, info.Group8), SqlDB.MakeInParam("@Group9", SqlDbType.Int, 4, info.Group9), SqlDB.MakeInParam("@Group10", SqlDbType.Int, 4, info.Group10), SqlDB.MakeInParam("@Group11", SqlDbType.Int, 4, info.Group11), SqlDB.MakeInParam("@Group12", SqlDbType.Int, 4, info.Group12), SqlDB.MakeInParam("@Group13", SqlDbType.Int, 4, info.Group13), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "Join_ProfessionResultsEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool Join_CardEdit(Entity.Join_Card info) { SqlParameter[] prams = { SqlDB.MakeInParam("@CardId", SqlDbType.Int, 4, info.CardId), SqlDB.MakeInParam("@CardBank", SqlDbType.VarChar, 50, info.CardBank), SqlDB.MakeInParam("@CardPass", SqlDbType.VarChar, 16, info.CardPass), SqlDB.MakeInParam("@IsValid", SqlDbType.Int, 4, info.IsValid), SqlDB.MakeInParam("@UseState", SqlDbType.Int, 4, info.UseState), SqlDB.MakeInParam("@DianId", SqlDbType.Int, 4, info.DianId), SqlDB.MakeInParam("@ProvinceId", SqlDbType.Int, 4, info.ProvinceId), SqlDB.MakeInParam("@OpenCardTime", SqlDbType.DateTime, 8, info.OpenCardTime), SqlDB.MakeInParam("@StudentId", SqlDbType.Int, 4, info.StudentId), SqlDB.MakeInParam("@UseTime", SqlDbType.DateTime, 8, info.UseTime), SqlDB.MakeInParam("@UseIp", SqlDbType.VarChar, 20, info.UseIp), SqlDB.MakeInParam("@IsTest", SqlDbType.Int, 4, info.IsTest), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "Join_CardEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool Join_MbtiResultsEdit(Entity.Join_MbtiResults info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@StudentId", SqlDbType.Int, 4, info.StudentId), SqlDB.MakeInParam("@E", SqlDbType.Int, 4, info.E), SqlDB.MakeInParam("@I", SqlDbType.Int, 4, info.I), SqlDB.MakeInParam("@S", SqlDbType.Int, 4, info.S), SqlDB.MakeInParam("@N", SqlDbType.Int, 4, info.N), SqlDB.MakeInParam("@T", SqlDbType.Int, 4, info.T), SqlDB.MakeInParam("@F", SqlDbType.Int, 4, info.F), SqlDB.MakeInParam("@J", SqlDbType.Int, 4, info.J), SqlDB.MakeInParam("@P", SqlDbType.Int, 4, info.P), SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "Join_MbtiResultsEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool Join_AbilityResultsEdit(Entity.Join_AbilityResults info) { SqlParameter[] prams = { SqlDB.MakeInParam("@AbilityResultsId", SqlDbType.Int, 4, info.AbilityResultsId), SqlDB.MakeInParam("@UserId", SqlDbType.Int, 4, info.UserId), SqlDB.MakeInParam("@Language", SqlDbType.Float, 8, info.Language), SqlDB.MakeInParam("@Tissue", SqlDbType.Float, 8, info.Tissue), SqlDB.MakeInParam("@Among", SqlDbType.Float, 8, info.Among), SqlDB.MakeInParam("@Mathematics", SqlDbType.Float, 8, info.Mathematics), SqlDB.MakeInParam("@Motion", SqlDbType.Float, 8, info.Motion), SqlDB.MakeInParam("@Writing", SqlDbType.Float, 8, info.Writing), SqlDB.MakeInParam("@Watch", SqlDbType.Float, 8, info.Watch), SqlDB.MakeInParam("@Space", SqlDbType.Float, 8, info.Space), SqlDB.MakeInParam("@Art", SqlDbType.Float, 8, info.Art), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "Join_AbilityResultsEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool TiMuSuoYinEdit(Entity.TiMuSuoYin info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@gid", SqlDbType.VarChar, 50, info.gid), SqlDB.MakeInParam("@zh_knowledge", SqlDbType.NVarChar, 128, info.zh_knowledge), SqlDB.MakeInParam("@difficulty", SqlDbType.Int, 4, info.difficulty), SqlDB.MakeInParam("@score", SqlDbType.Int, 4, info.score), SqlDB.MakeInParam("@objective_flag", SqlDbType.Int, 4, info.objective_flag), SqlDB.MakeInParam("@option_count", SqlDbType.Int, 4, info.option_count), SqlDB.MakeInParam("@group_count", SqlDbType.Int, 4, info.group_count), SqlDB.MakeInParam("@question_type", SqlDbType.NVarChar, 50, info.question_type), SqlDB.MakeInParam("@subject_id", SqlDbType.Int, 4, info.subject_id), SqlDB.MakeInParam("@grade_id", SqlDbType.Int, 4, info.grade_id), SqlDB.MakeInParam("@section_id", SqlDbType.Int, 4, info.section_id), SqlDB.MakeInParam("@edu_question_type_Id", SqlDbType.Int, 4, info.edu_question_type_Id), SqlDB.MakeInParam("@zhishidian_id", SqlDbType.Int, 4, info.zhishidian_id), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "TiMuSuoYinEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool JiuYeLvEdit(Entity.GKJiuYeLv info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@Year", SqlDbType.Int, 4, info.Year), SqlDB.MakeInParam("@IsBen", SqlDbType.Int, 4, info.IsBen), SqlDB.MakeInParam("@ZhuanYeId", SqlDbType.Int, 4, info.ZhuanYeId), SqlDB.MakeInParam("@ZhuanYeName", SqlDbType.NVarChar, 200, info.ZhuanYeName), SqlDB.MakeInParam("@JiuYeLv", SqlDbType.Int, 4, info.JiuYeLv), SqlDB.MakeInParam("@JiuYeLvA", SqlDbType.NVarChar, 20, info.JiuYeLvA), SqlDB.MakeInParam("@JiuYeLv211", SqlDbType.Int, 4, info.JiuYeLv211), SqlDB.MakeInParam("@JiuYeLvA211", SqlDbType.NVarChar, 20, info.JiuYeLvA211), SqlDB.MakeInParam("@CentralCollegeJiuYeLv", SqlDbType.Int, 4, info.CentralCollegeJiuYeLv), SqlDB.MakeInParam("@CentralCollegeJiuYeLvA", SqlDbType.NVarChar, 20, info.CentralCollegeJiuYeLvA), SqlDB.MakeInParam("@LocalCollegeJiuYeLv", SqlDbType.Int, 4, info.LocalCollegeJiuYeLv), SqlDB.MakeInParam("@LocalCollegeJiuYeLvA", SqlDbType.NVarChar, 20, info.LocalCollegeJiuYeLvA), SqlDB.MakeInParam("@BiYeShengGuiMo", SqlDbType.NVarChar, 200, info.BiYeShengGuiMo), SqlDB.MakeInParam("@XueKeMenLei", SqlDbType.Int, 4, info.XueKeMenLei), SqlDB.MakeInParam("@XueKeMenLeiName", SqlDbType.NVarChar, 50, info.XueKeMenLeiName), SqlDB.MakeInParam("@ZhuanYeLei", SqlDbType.Int, 4, info.ZhuanYeLei), SqlDB.MakeInParam("@ZhuanYeLeiName", SqlDbType.NVarChar, 50, info.ZhuanYeLeiName), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "JiuYeLvEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool SchoolProfessionalEdit(Entity.SchoolProfessional info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@SchoolDisciplinesId", SqlDbType.Int, 4, info.SchoolDisciplinesId), SqlDB.MakeInParam("@ProfessionalId", SqlDbType.Int, 4, info.ProfessionalId), SqlDB.MakeInParam("@ProfessionalName", SqlDbType.NVarChar, 100, info.ProfessionalName), SqlDB.MakeInParam("@ProfessionalIntro", SqlDbType.NText, 0, info.ProfessionalIntro), SqlDB.MakeInParam("@IsTeSe", SqlDbType.Int, 4, info.IsTeSe), SqlDB.MakeInParam("@IsXueKePaiMing", SqlDbType.Int, 4, info.IsXueKePaiMing), SqlDB.MakeInParam("@IsYiJiZhongDian", SqlDbType.Int, 4, info.IsYiJiZhongDian), SqlDB.MakeInParam("@IsErJiZhongDian", SqlDbType.Int, 4, info.IsErJiZhongDian), SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime), SqlDB.MakeInParam("@AddWid", SqlDbType.Int, 4, info.AddWid), SqlDB.MakeInParam("@ClickNum", SqlDbType.Int, 4, info.ClickNum), SqlDB.MakeInParam("@IsPause", SqlDbType.Int, 4, info.IsPause), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "SchoolProfessionalEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool DingDanEdit(Entity.DingDan info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@State", SqlDbType.Int, 4, info.State), SqlDB.MakeInParam("@DingDanHao", SqlDbType.NVarChar, 100, info.DingDanHao), SqlDB.MakeInParam("@Subject", SqlDbType.NVarChar, 200, info.Subject), SqlDB.MakeInParam("@Body", SqlDbType.NText, 0, info.Body), SqlDB.MakeInParam("@Count", SqlDbType.Int, 4, info.Count), SqlDB.MakeInParam("@DanJia", SqlDbType.Decimal, 0, info.DanJia), SqlDB.MakeInParam("@DingDanJinE", SqlDbType.Decimal, 0, info.DingDanJinE), SqlDB.MakeInParam("@CellName", SqlDbType.NVarChar, 100, info.CellName), SqlDB.MakeInParam("@CellMobile", SqlDbType.NVarChar, 50, info.CellMobile), SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime), SqlDB.MakeInParam("@Memo", SqlDbType.NText, 0, info.Memo), SqlDB.MakeInParam("@ProvinceId", SqlDbType.Int, 4, info.ProvinceId), SqlDB.MakeInParam("@WenLi", SqlDbType.Int, 4, info.WenLi), SqlDB.MakeInParam("@Address", SqlDbType.NVarChar, 200, info.Address), SqlDB.MakeInParam("@Category", SqlDbType.Int, 4, info.Category), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "DingDanEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int SchoolArticleAdd(Entity.SchoolArticle info) { SqlParameter[] prams = { SqlDB.MakeInParam("@SchoolId", SqlDbType.Int, 4, info.SchoolId), SqlDB.MakeInParam("@CategoryId", SqlDbType.Int, 4, info.CategoryId), SqlDB.MakeInParam("@Icon", SqlDbType.NVarChar, 500, info.Icon), SqlDB.MakeInParam("@Title", SqlDbType.NVarChar, 200, info.Title), SqlDB.MakeInParam("@ShortTitle", SqlDbType.NVarChar, 200, info.ShortTitle), SqlDB.MakeInParam("@MetaTitle", SqlDbType.NVarChar, 200, info.MetaTitle), SqlDB.MakeInParam("@MetaKeyWords", SqlDbType.NVarChar, 200, info.MetaKeyWords), SqlDB.MakeInParam("@MetaDescription", SqlDbType.NVarChar, 300, info.MetaDescription), SqlDB.MakeInParam("@Summary", SqlDbType.NVarChar, 2000, info.Summary), SqlDB.MakeInParam("@Content", SqlDbType.NVarChar, 0, info.Content), SqlDB.MakeInParam("@PublishTime", SqlDbType.DateTime, 8, info.PublishTime), SqlDB.MakeInParam("@IsTuiJian", SqlDbType.Int, 4, info.IsTuiJian), SqlDB.MakeInParam("@IsNew", SqlDbType.Int, 4, info.IsNew), SqlDB.MakeInParam("@IsZhiDing", SqlDbType.Int, 4, info.IsZhiDing), SqlDB.MakeInParam("@ZhiDingTime", SqlDbType.DateTime, 8, info.ZhiDingTime), SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime), SqlDB.MakeInParam("@AddWid", SqlDbType.Int, 4, info.AddWid), SqlDB.MakeInParam("@IsCheck", SqlDbType.Int, 4, info.IsCheck), SqlDB.MakeInParam("@CheckTime", SqlDbType.DateTime, 8, info.CheckTime), SqlDB.MakeInParam("@CheckWid", SqlDbType.Int, 4, info.CheckWid), SqlDB.MakeInParam("@ClickNum", SqlDbType.Int, 4, info.ClickNum), SqlDB.MakeInParam("@IsPause", SqlDbType.Int, 4, info.IsPause), SqlDB.MakeInParam("@Year", SqlDbType.Int, 4, info.Year), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "SchoolArticleAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool ProvinceConfigEdit(Entity.ProvinceConfig info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@ProvinceId", SqlDbType.Int, 4, info.ProvinceId), SqlDB.MakeInParam("@HasTiQianPi", SqlDbType.Int, 4, info.HasTiQianPi), SqlDB.MakeInParam("@HasZhuanKe", SqlDbType.Int, 4, info.HasZhuanKe), SqlDB.MakeInParam("@HasZhuanKeZhuanYe", SqlDbType.Int, 4, info.HasZhuanKeZhuanYe), SqlDB.MakeInParam("@OwnTable", SqlDbType.Int, 4, info.OwnTable), SqlDB.MakeInParam("@ChangeEndTime", SqlDbType.DateTime, 8, info.ChangeEndTime), SqlDB.MakeInParam("@ReStartTime", SqlDbType.DateTime, 8, info.ReStartTime), SqlDB.MakeInParam("@LatestProvinceWeiCiYear", SqlDbType.Int, 4, info.LatestProvinceWeiCiYear), SqlDB.MakeInParam("@LatestBenKeYear", SqlDbType.Int, 4, info.LatestBenKeYear), SqlDB.MakeInParam("@LatestBenKeZhuanYeYear", SqlDbType.Int, 4, info.LatestBenKeZhuanYeYear), SqlDB.MakeInParam("@LatestZhuanKeYear", SqlDbType.Int, 4, info.LatestZhuanKeYear), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "ProvinceConfigEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool Join_16PfResultsEdit(Entity.Join_16PfResults info) { SqlParameter[] prams = { SqlDB.MakeInParam("@PfResultsId", SqlDbType.Int, 4, info.PfResultsId), SqlDB.MakeInParam("@UserId", SqlDbType.Int, 4, info.UserId), SqlDB.MakeInParam("@A_type", SqlDbType.Int, 4, info.A_type), SqlDB.MakeInParam("@B_type", SqlDbType.Int, 4, info.B_type), SqlDB.MakeInParam("@C_type", SqlDbType.Int, 4, info.C_type), SqlDB.MakeInParam("@E_type", SqlDbType.Int, 4, info.E_type), SqlDB.MakeInParam("@F_type", SqlDbType.Int, 4, info.F_type), SqlDB.MakeInParam("@G_type", SqlDbType.Int, 4, info.G_type), SqlDB.MakeInParam("@H_type", SqlDbType.Int, 4, info.H_type), SqlDB.MakeInParam("@I_type", SqlDbType.Int, 4, info.I_type), SqlDB.MakeInParam("@L_type", SqlDbType.Int, 4, info.L_type), SqlDB.MakeInParam("@M_type", SqlDbType.Int, 4, info.M_type), SqlDB.MakeInParam("@N_type", SqlDbType.Int, 4, info.N_type), SqlDB.MakeInParam("@O_type", SqlDbType.Int, 4, info.O_type), SqlDB.MakeInParam("@Q1_type", SqlDbType.Int, 4, info.Q1_type), SqlDB.MakeInParam("@Q2_type", SqlDbType.Int, 4, info.Q2_type), SqlDB.MakeInParam("@Q3_type", SqlDbType.Int, 4, info.Q3_type), SqlDB.MakeInParam("@Q4_type", SqlDbType.Int, 4, info.Q4_type), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "Join_16PfResultsEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool Join_ProjectEditNew(Entity.Join_Project info) { SqlParameter[] prams = { SqlDB.MakeInParam("@ProjectId", SqlDbType.Int, 4, info.ProjectId), SqlDB.MakeInParam("@ProjectName", SqlDbType.NVarChar, 500, info.ProjectName), SqlDB.MakeInParam("@Content", SqlDbType.NText, 0, info.Content), SqlDB.MakeInParam("@TopPCid", SqlDbType.Int, 4, info.TopPCid), SqlDB.MakeInParam("@PCidList", SqlDbType.NVarChar, 100, info.PCidList), SqlDB.MakeInParam("@PCid", SqlDbType.Int, 4, info.PCid), SqlDB.MakeInParam("@ApplicantFile", SqlDbType.NVarChar, 500, info.ApplicantFile), SqlDB.MakeInParam("@IsValid", SqlDbType.Int, 4, info.IsValid), SqlDB.MakeInParam("@IsPause", SqlDbType.Int, 4, info.IsPause), SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime), SqlDB.MakeInParam("@IsCheck", SqlDbType.Int, 4, info.IsCheck), SqlDB.MakeInParam("@IsHot", SqlDbType.Int, 4, info.IsHot), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "Join_ProjectEditNew", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool StudentGaoKaoHistoryEdit(Entity.StudentGaoKaoHistory info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@StudentId", SqlDbType.Int, 4, info.StudentId), SqlDB.MakeInParam("@FenShu", SqlDbType.Int, 4, info.FenShu), SqlDB.MakeInParam("@FirstLevel", SqlDbType.Int, 4, info.FirstLevel), SqlDB.MakeInParam("@SecondLevel", SqlDbType.Int, 4, info.SecondLevel), SqlDB.MakeInParam("@PcFirst", SqlDbType.Int, 4, info.PcFirst), SqlDB.MakeInParam("@PcSecond", SqlDbType.Int, 4, info.PcSecond), SqlDB.MakeInParam("@PcThird", SqlDbType.Int, 4, info.PcThird), SqlDB.MakeInParam("@PcZhuanKeFirst", SqlDbType.Int, 4, info.PcZhuanKeFirst), SqlDB.MakeInParam("@PcZhuanKeSecond", SqlDbType.Int, 4, info.PcZhuanKeSecond), SqlDB.MakeInParam("@IsSetUpFenShuXian", SqlDbType.Int, 4, info.IsSetUpFenShuXian), SqlDB.MakeInParam("@WeiCi", SqlDbType.Int, 4, info.WeiCi), SqlDB.MakeInParam("@IsSetUpWeiCi", SqlDbType.Int, 4, info.IsSetUpWeiCi), SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime), SqlDB.MakeInParam("@IsGaoKao", SqlDbType.Int, 4, info.IsGaoKao), SqlDB.MakeInParam("@IsLatest", SqlDbType.Int, 4, info.IsLatest), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "StudentGaoKaoHistoryEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int Join_TestAdd(Entity.Join_Test info) { SqlParameter[] prams = { SqlDB.MakeInParam("@TestTitle", SqlDbType.Int, 4, info.TestTitle), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "Join_TestAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int zhishidianAdd(Entity.zhishidian info) { SqlParameter[] prams = { SqlDB.MakeInParam("@subject_id", SqlDbType.Int, 4, info.subject_id), SqlDB.MakeInParam("@name", SqlDbType.NVarChar, 200, info.name), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "zhishidianAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int area_provinceAdd(Entity.area_province info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Name", SqlDbType.NVarChar, 32, info.Name), SqlDB.MakeInParam("@country_id", SqlDbType.VarChar, 6, info.country_id), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "area_provinceAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int edu_question_typeAdd(Entity.edu_question_type info) { SqlParameter[] prams = { SqlDB.MakeInParam("@subject_id", SqlDbType.Int, 4, info.subject_id), SqlDB.MakeInParam("@type_name", SqlDbType.NVarChar, 64, info.type_name), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "edu_question_typeAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int XiangQingAdd(Entity.XiangQing info) { SqlParameter[] prams = { SqlDB.MakeInParam("@LoginId", SqlDbType.Int, 4, info.LoginId), SqlDB.MakeInParam("@YKStudentXinXiId", SqlDbType.Int, 4, info.YKStudentXinXiId), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "XiangQingAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int ZhiShiDianRelationAdd(Entity.ZhiShiDianRelation info) { SqlParameter[] prams = { SqlDB.MakeInParam("@ZhenTiZSDId", SqlDbType.Int, 4, info.ZhenTiZSDId), SqlDB.MakeInParam("@KMZSDId", SqlDbType.Int, 4, info.KMZSDId), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "ZhiShiDianRelationAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int Join_Ability_MajorAdd(Entity.Join_Ability_Major info) { SqlParameter[] prams = { SqlDB.MakeInParam("@MajorName", SqlDbType.Int, 4, info.MajorName), SqlDB.MakeInParam("@GradeList", SqlDbType.Int, 4, info.GradeList), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "Join_Ability_MajorAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int ZhiYeZhuanYeAdd(Entity.ZhiYeZhuanYe info) { SqlParameter[] prams = { SqlDB.MakeInParam("@ZhiYeId", SqlDbType.Int, 4, info.ZhiYeId), SqlDB.MakeInParam("@ProfessionalId", SqlDbType.Int, 4, info.ProfessionalId), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "ZhiYeZhuanYeAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int zhishidian2timusuoyinAdd(Entity.zhishidian2timusuoyin info) { SqlParameter[] prams = { SqlDB.MakeInParam("@ZhiShiDianId", SqlDbType.Int, 4, info.ZhiShiDianId), SqlDB.MakeInParam("@TiMuSuoYinId", SqlDbType.Int, 4, info.TiMuSuoYinId), SqlDB.MakeInParam("@gid", SqlDbType.NVarChar, 50, info.gid), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "zhishidian2timusuoyinAdd", prams).ToString(), -1)); }