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