/// <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>更新成功返回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 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 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 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 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>更新成功返回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 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 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 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 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 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>更新成功返回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_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_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 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="Id">自增id的值</param> /// <returns>暂停成功返回ture,否则返回false</returns> public static bool SchoolPause(Entity.School info) { int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.Text, "UPDATE [School] SET IsPause = " + info.IsPause + " WHERE Id = " + info.Id); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 删除一个值 /// </summary> /// <param name="Id">自增id的值</param> /// <returns>删除成功返回ture,否则返回false</returns> public static bool SchoolCampusDel(int Id) { int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.Text, "DELETE [SchoolCampus] WHERE Id = " + Id); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 删除一个值 /// </summary> /// <param name="AnswerId">自增id的值</param> /// <returns>删除成功返回ture,否则返回false</returns> public static bool Join_16PfAnswerDel(int AnswerId) { int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.Text, "DELETE [Join_16PfAnswer] WHERE AnswerId = " + AnswerId); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 删除一个值 /// </summary> /// <param name="HollandResultsId">自增id的值</param> /// <returns>删除成功返回ture,否则返回false</returns> public static bool Join_HollandResultsDel(int HollandResultsId) { int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.Text, "DELETE [Join_HollandResults] WHERE HollandResultsId = " + HollandResultsId); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 删除一个值 /// </summary> /// <param name="SchoolId">自增id的值</param> /// <returns>删除成功返回ture,否则返回false</returns> public static bool SeniorMiddleSchoolDel(int SchoolId) { int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.Text, "DELETE [SeniorMiddleSchool] WHERE SchoolId = " + SchoolId); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 删除一个值 /// </summary> /// <param name="Id">自增id的值</param> /// <returns>删除成功返回ture,否则返回false</returns> public static bool zhishidian2timusuoyinDel(int Id) { int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.Text, "DELETE [zhishidian2timusuoyin] WHERE Id = " + Id); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 删除一个值 /// </summary> /// <param name="TestId">自增id的值</param> /// <returns>删除成功返回ture,否则返回false</returns> public static bool Join_XinLiTestDel(int TestId) { int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.Text, "DELETE [Join_XinLiTest] WHERE TestId = " + TestId); if (intReturnValue == 1) { return(true); } return(false); }
public static bool SchoolDisciplinesProfessionalCount(int ProfessionalCount, int Id) { int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.Text, "UPDATE [SchoolDisciplines] SET ProfessionalCount = " + ProfessionalCount + " WHERE Id = " + Id); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 暂停该值 /// </summary> /// <param name="ProjectId">自增id的值</param> /// <returns>暂停成功返回ture,否则返回false</returns> public static bool Join_ProjectPause(Entity.Join_Project info) { int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.Text, "UPDATE [Join_Project] SET IsPause = " + info.IsPause + " WHERE ProjectId = " + info.ProjectId); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 删除一个值 /// </summary> /// <param name="Id">自增id的值</param> /// <returns>删除成功返回ture,否则返回false</returns> public static bool FenShuXianDel(int Id) { int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.Text, "DELETE [FenShuXian] WHERE Id = " + Id); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 删除一个值 /// </summary> /// <param name="Id">自增id的值</param> /// <returns>删除成功返回ture,否则返回false</returns> public static bool StudentShouCangDel(int Id) { int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.Text, "DELETE [StudentShouCang] WHERE Id = " + Id); if (intReturnValue == 1) { return(true); } return(false); }
/// <summary> /// 删除一个值 /// </summary> /// <param name="ProvinceID">自增id的值</param> /// <returns>删除成功返回ture,否则返回false</returns> public static bool ProvinceDel(int ProvinceID) { int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(CommandType.Text, "DELETE [Province] WHERE ProvinceID = " + ProvinceID); if (intReturnValue == 1) { return(true); } return(false); }