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