/// <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>正常返回大于 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>正常返回大于 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="strWhere">条件,可以为空</param> /// <returns>如果没有就返回0</returns> public static int Join_ProjectCountForDaiLiFenPei(int Did, int PCid) { String strSQL = "SELECT count(*) FROM [Join_Project] AS P,[Join_ProjectRelated] AS PR,[Join_JiaMengDianProject] AS JMDP WHERE P.ProjectId = PR.Pid AND PR.IsValid = 1 AND P.IsValid = 1 AND P.IsPause = 0 AND P.PCid = " + PCid + "AND P.ProjectId = JMDP.Pid AND JMDP.Did = " + Did; //strSQL = strSQL + " AND PR.Pid NOT IN (SELECT * FROM [Join_JiaMengDianProject] WHERE Did = " + Did + ")"; //strSQL = strSQL + " ORDER BY PR.Pid DESC"; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.Text, strSQL).ToString(), 0)); }
public static int ShiJuanCount(string TablePre) { string strSql = "select count(*) from " + TablePre + "_exam_examination,edu_subject,edu_grade,area_province where subject_id = edu_subject.id and grade_id = edu_grade.id and province_id = area_province.id"; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.Text, strSql).ToString(), 0)); //strSql = "select * from dl_exam_examination,edu_subject,edu_grade,area_province where subject_id = edu_subject.id and grade_id = edu_grade.id and province_id = area_province.id"; }
/// <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 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 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 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 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 SchoolCategoryAdd(Entity.SchoolCategory info) { SqlParameter[] prams = { SqlDB.MakeInParam("@CategoryName", SqlDbType.NVarChar, 200, info.CategoryName), SqlDB.MakeInParam("@Sort", SqlDbType.Int, 4, info.Sort), SqlDB.MakeInParam("@IsPause", SqlDbType.Int, 4, info.IsPause), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "SchoolCategoryAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int Join_ResultsAdd(Entity.Join_Results info) { SqlParameter[] prams = { SqlDB.MakeInParam("@UserId", SqlDbType.Int, 4, info.UserId), SqlDB.MakeInParam("@ResultsContent", SqlDbType.Int, 4, info.ResultsContent), SqlDB.MakeInParam("@AddTime", SqlDbType.Int, 4, info.AddTime), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "Join_ResultsAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int Join_TestWLResultsAdd(Entity.Join_TestWLResults info) { SqlParameter[] prams = { SqlDB.MakeInParam("@UserId", SqlDbType.Int, 4, info.UserId), SqlDB.MakeInParam("@WK", SqlDbType.Int, 4, info.WK), SqlDB.MakeInParam("@LK", SqlDbType.Int, 4, info.LK) }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "Join_TestWLResultsAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int edu_subjectAdd(Entity.edu_subject info) { SqlParameter[] prams = { SqlDB.MakeInParam("@name", SqlDbType.NVarChar, 64, info.name), SqlDB.MakeInParam("@subject_code", SqlDbType.Char, 2, info.subject_code), SqlDB.MakeInParam("@subject_index", SqlDbType.Int, 4, info.subject_index), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "edu_subjectAdd", 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)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int Join_AbilityTestAdd(Entity.Join_AbilityTest info) { SqlParameter[] prams = { SqlDB.MakeInParam("@AbilityNumber", SqlDbType.Int, 4, info.AbilityNumber), SqlDB.MakeInParam("@AbilityTitle", SqlDbType.NVarChar, 500, info.AbilityTitle), SqlDB.MakeInParam("@GroupNumber", SqlDbType.Int, 4, info.GroupNumber), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "Join_AbilityTestAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int Join_MbitAnswerAdd(Entity.Join_MbitAnswer info) { SqlParameter[] prams = { SqlDB.MakeInParam("@TestId", SqlDbType.Int, 4, info.TestId), SqlDB.MakeInParam("@AnswerContent", SqlDbType.NVarChar, 50, info.AnswerContent), SqlDB.MakeInParam("@Opetion", SqlDbType.NVarChar, 50, info.Opetion), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "Join_MbitAnswerAdd", prams).ToString(), -1)); }
/// <summary> /// 获取该条件下的总的数量 /// </summary> /// <param name="strWhere">条件,可以为空</param> /// <returns>如果没有就返回0</returns> public static int Join_ProjectCount(string strWhere) { StringBuilder sbSql = new StringBuilder(); sbSql.Append("SELECT count(*) FROM Join_Project as p left join Join_ProjectCategory as pc on p.PCid = pc.ProjectCategoryId left join Join_ProjectRelated as pr on p.ProjectId = pr.Pid WHERE pr.PPid > 0 and pr.IsValid = 1 "); if (!string.IsNullOrEmpty(strWhere.Trim())) { sbSql.Append(" AND " + strWhere); } return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.Text, sbSql.ToString()).ToString(), 0)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int NoticeAdd(Entity.Notice info) { SqlParameter[] prams = { SqlDB.MakeInParam("@ProvinceId", SqlDbType.Int, 4, info.ProvinceId), SqlDB.MakeInParam("@Content", SqlDbType.NVarChar, 200, info.Content), SqlDB.MakeInParam("@AddWid", SqlDbType.Int, 4, info.AddWid), SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "NoticeAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int Join_ProjectAdd(Entity.Join_Project info) { SqlParameter[] prams = { SqlDB.MakeInParam("@ProjectName", SqlDbType.NVarChar, 1000, info.ProjectName), SqlDB.MakeInParam("@Content", SqlDbType.NText, 0, info.Content), SqlDB.MakeInParam("@PCid", SqlDbType.Int, 4, info.PCid), SqlDB.MakeInParam("@ApplicantFile", SqlDbType.NVarChar, 500, info.ApplicantFile), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "Join_ProjectAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int ProvinceAdd(Entity.Province info) { SqlParameter[] prams = { SqlDB.MakeInParam("@ProvinceName", SqlDbType.NVarChar, 50, info.ProvinceName), SqlDB.MakeInParam("@ProvincePinYin", SqlDbType.NVarChar, 50, info.ProvincePinYin), SqlDB.MakeInParam("@ProvinceCode", SqlDbType.NVarChar, 50, info.ProvinceCode), SqlDB.MakeInParam("@AdminCode", SqlDbType.NVarChar, 50, info.AdminCode), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "ProvinceAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int ProfessionalZhiYeRelationAdd(Entity.ProfessionalZhiYeRelation info) { SqlParameter[] prams = { SqlDB.MakeInParam("@ZhiYeId", SqlDbType.Int, 4, info.ZhiYeId), SqlDB.MakeInParam("@ProfessionalId", SqlDbType.Int, 4, info.ProfessionalId), SqlDB.MakeInParam("@ProfessionalCode", SqlDbType.NVarChar, 50, info.ProfessionalCode), SqlDB.MakeInParam("@ProfessionalName", SqlDbType.NVarChar, 150, info.ProfessionalName), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "ProfessionalZhiYeRelationAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int SchoolDisciplinesAdd(Entity.SchoolDisciplines info) { SqlParameter[] prams = { SqlDB.MakeInParam("@SchoolId", SqlDbType.Int, 4, info.SchoolId), SqlDB.MakeInParam("@DisciplinesId", SqlDbType.Int, 4, info.DisciplinesId), SqlDB.MakeInParam("@ProfessionalCount", SqlDbType.Int, 4, info.ProfessionalCount), SqlDB.MakeInParam("@IsPause", SqlDbType.Int, 4, info.IsPause), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "SchoolDisciplinesAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int Join_ZhongKeTestAdd(Entity.Join_ZhongKeTest info) { SqlParameter[] prams = { SqlDB.MakeInParam("@TestNumber", SqlDbType.Int, 4, info.TestNumber), SqlDB.MakeInParam("@TestTitle", SqlDbType.NVarChar, 100, info.TestTitle), SqlDB.MakeInParam("@TestType", SqlDbType.NVarChar, 1, info.TestType), SqlDB.MakeInParam("@TestGroup", SqlDbType.VarChar, 100, info.TestGroup), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "Join_ZhongKeTestAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int cuotibenAdd(Entity.cuotiben info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Wid", SqlDbType.Int, 4, info.Wid), SqlDB.MakeInParam("@TiMuId", SqlDbType.Int, 4, info.TiMuId), SqlDB.MakeInParam("@Answer", SqlDbType.NVarChar, 50, info.Answer), SqlDB.MakeInParam("@RightAnswer", SqlDbType.NVarChar, 50, info.RightAnswer), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "cuotibenAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int SchoolAdd(Entity.School info) { SqlParameter[] prams = { SqlDB.MakeInParam("@SchoolName", SqlDbType.NVarChar, 100, info.SchoolName), SqlDB.MakeInParam("@SchoolEnName", SqlDbType.NVarChar, 200, info.SchoolEnName), SqlDB.MakeInParam("@Logo", SqlDbType.NVarChar, 100, info.Logo), SqlDB.MakeInParam("@CengYongMing", SqlDbType.NVarChar, 500, info.CengYongMing), SqlDB.MakeInParam("@SchoolWebSite", SqlDbType.NVarChar, 200, info.SchoolWebSite), SqlDB.MakeInParam("@ZhaoShengWebSite", SqlDbType.NVarChar, 200, info.ZhaoShengWebSite), SqlDB.MakeInParam("@ZhaoShengTel", SqlDbType.NVarChar, 200, info.ZhaoShengTel), SqlDB.MakeInParam("@ProvinceId", SqlDbType.Int, 4, info.ProvinceId), SqlDB.MakeInParam("@ProvinceName", SqlDbType.NVarChar, 100, info.ProvinceName), SqlDB.MakeInParam("@CityName", SqlDbType.NVarChar, 100, info.CityName), SqlDB.MakeInParam("@Address", SqlDbType.NVarChar, 400, info.Address), SqlDB.MakeInParam("@FoundingTime", SqlDbType.NVarChar, 50, info.FoundingTime), SqlDB.MakeInParam("@YuanShi", SqlDbType.NVarChar, 50, info.YuanShi), SqlDB.MakeInParam("@ZhongDianXueKe", SqlDbType.NVarChar, 50, info.ZhongDianXueKe), SqlDB.MakeInParam("@BoShiDian", SqlDbType.NVarChar, 50, info.BoShiDian), SqlDB.MakeInParam("@ShuoShiDian", SqlDbType.NVarChar, 50, info.ShuoShiDian), SqlDB.MakeInParam("@SchoolIntro", SqlDbType.NText, 0, info.SchoolIntro), SqlDB.MakeInParam("@SchoolCengCi", SqlDbType.Int, 4, info.SchoolCengCi), SqlDB.MakeInParam("@SchoolNature", SqlDbType.Int, 4, info.SchoolNature), SqlDB.MakeInParam("@YuanXiaoLeiXingId", SqlDbType.Int, 4, info.YuanXiaoLeiXingId), SqlDB.MakeInParam("@YuanXiaoLeiXing", SqlDbType.NVarChar, 40, info.YuanXiaoLeiXing), SqlDB.MakeInParam("@Belong", SqlDbType.Int, 4, info.Belong), SqlDB.MakeInParam("@BeLongName", SqlDbType.NVarChar, 100, info.BeLongName), SqlDB.MakeInParam("@Is211", SqlDbType.Int, 4, info.Is211), SqlDB.MakeInParam("@Is985", SqlDbType.Int, 4, info.Is985), SqlDB.MakeInParam("@IsGraduateSchool", SqlDbType.Int, 4, info.IsGraduateSchool), SqlDB.MakeInParam("@IsIndependentRecruitment", SqlDbType.Int, 4, info.IsIndependentRecruitment), SqlDB.MakeInParam("@IsNationalDefense", SqlDbType.Int, 4, info.IsNationalDefense), SqlDB.MakeInParam("@IsExcellent", SqlDbType.Int, 4, info.IsExcellent), SqlDB.MakeInParam("@IsMiNi211", SqlDbType.Int, 4, info.IsMiNi211), SqlDB.MakeInParam("@IsRuralSpecial", SqlDbType.Int, 4, info.IsRuralSpecial), SqlDB.MakeInParam("@IsArtSpecialty", SqlDbType.Int, 4, info.IsArtSpecialty), SqlDB.MakeInParam("@IsHighLevelAthletes", SqlDbType.Int, 4, info.IsHighLevelAthletes), SqlDB.MakeInParam("@IsShiDian", SqlDbType.Int, 4, info.IsShiDian), SqlDB.MakeInParam("@WuShuLianRanking", SqlDbType.Int, 4, info.WuShuLianRanking), SqlDB.MakeInParam("@XiaoYouHuiRanking", SqlDbType.Int, 4, info.XiaoYouHuiRanking), SqlDB.MakeInParam("@MinBanRanking", SqlDbType.Int, 4, info.MinBanRanking), SqlDB.MakeInParam("@DuLiXueYuanRanking", SqlDbType.Int, 4, info.DuLiXueYuanRanking), SqlDB.MakeInParam("@ClickNum", SqlDbType.Int, 4, info.ClickNum), SqlDB.MakeInParam("@IsPause", SqlDbType.Int, 4, info.IsPause), SqlDB.MakeInParam("@BanXueLeiXing", SqlDbType.Int, 4, info.BanXueLeiXing), SqlDB.MakeInParam("@Email", SqlDbType.NVarChar, 50, info.Email), SqlDB.MakeInParam("@ZipCode", SqlDbType.NVarChar, 20, info.ZipCode), SqlDB.MakeInParam("@CollectionBooks", SqlDbType.NVarChar, 200, info.CollectionBooks), SqlDB.MakeInParam("@Pic", SqlDbType.NVarChar, 100, info.Pic), SqlDB.MakeInParam("@StudentCount", SqlDbType.NVarChar, 100, info.StudentCount), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "SchoolAdd", prams).ToString(), -1)); }
/// <summary> /// 调用存储过程增加一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns> public static int YKStudentXinXiAdd(Entity.YKStudentXinXi info) { SqlParameter[] prams = { SqlDB.MakeInParam("@StudentName", SqlDbType.NVarChar, 50, info.StudentName), SqlDB.MakeInParam("@SshengId", SqlDbType.Int, 4, info.SshengId), SqlDB.MakeInParam("@Ssheng", SqlDbType.NVarChar, 50, info.Ssheng), SqlDB.MakeInParam("@SshiId", SqlDbType.Int, 4, info.SshiId), SqlDB.MakeInParam("@Sshi", SqlDbType.NVarChar, 50, info.Sshi), SqlDB.MakeInParam("@SQuId", SqlDbType.Int, 4, info.SQuId), SqlDB.MakeInParam("@SQu", SqlDbType.NVarChar, 50, info.SQu), SqlDB.MakeInParam("@Sex", SqlDbType.Int, 4, info.Sex), SqlDB.MakeInParam("@KaoShengPhone", SqlDbType.NVarChar, 50, info.KaoShengPhone), SqlDB.MakeInParam("@ChuShengRiQi", SqlDbType.NVarChar, 50, info.ChuShengRiQi), SqlDB.MakeInParam("@JiaZhangPhone", SqlDbType.NVarChar, 50, info.JiaZhangPhone), SqlDB.MakeInParam("@BiYeXueXiao", SqlDbType.NVarChar, 50, info.BiYeXueXiao), SqlDB.MakeInParam("@Email", SqlDbType.NVarChar, 50, info.Email), SqlDB.MakeInParam("@Sqq", SqlDbType.NVarChar, 50, info.Sqq), SqlDB.MakeInParam("@BaoKaoType", SqlDbType.Int, 4, info.BaoKaoType), SqlDB.MakeInParam("@JiaFenFW", SqlDbType.Int, 4, info.JiaFenFW), SqlDB.MakeInParam("@FenZhi", SqlDbType.NVarChar, 50, info.FenZhi), SqlDB.MakeInParam("@IsJBWL", SqlDbType.Int, 4, info.IsJBWL), SqlDB.MakeInParam("@TJZYSXQK", SqlDbType.NVarChar, 500, info.TJZYSXQK), SqlDB.MakeInParam("@GRChengJiYouShi", SqlDbType.Int, 4, info.GRChengJiYouShi), SqlDB.MakeInParam("@YiKaoChengShiId", SqlDbType.Int, 4, info.YiKaoChengShiId), SqlDB.MakeInParam("@YiKaoChengShi", SqlDbType.NVarChar, 50, info.YiKaoChengShi), SqlDB.MakeInParam("@YiKaoTypeId", SqlDbType.Int, 4, info.YiKaoTypeId), SqlDB.MakeInParam("@YiKaoType", SqlDbType.NVarChar, 50, info.YiKaoType), SqlDB.MakeInParam("@KaoShengType", SqlDbType.Int, 4, info.KaoShengType), SqlDB.MakeInParam("@YiXiangDiQu", SqlDbType.NVarChar, 100, info.YiXiangDiQu), SqlDB.MakeInParam("@YiXiangZhuanYe", SqlDbType.NVarChar, 100, info.YiXiangZhuanYe), SqlDB.MakeInParam("@YuanXiaoType", SqlDbType.Int, 4, info.YuanXiaoType), SqlDB.MakeInParam("@YiXiangYuanXiao", SqlDbType.NVarChar, 100, info.YiXiangYuanXiao), SqlDB.MakeInParam("@LianKaoChengJi", SqlDbType.NVarChar, 50, info.LianKaoChengJi), SqlDB.MakeInParam("@BanXueType", SqlDbType.Int, 4, info.BanXueType), SqlDB.MakeInParam("@XiaoKaoQingKuang", SqlDbType.NVarChar, 0, info.XiaoKaoQingKuang), SqlDB.MakeInParam("@Meto", SqlDbType.NVarChar, 0, info.Meto), SqlDB.MakeInParam("@YGYuWen", SqlDbType.NVarChar, 50, info.YGYuWen), SqlDB.MakeInParam("@YGShuXue", SqlDbType.NVarChar, 50, info.YGShuXue), SqlDB.MakeInParam("@YGYingYu", SqlDbType.NVarChar, 50, info.YGYingYu), SqlDB.MakeInParam("@YGZongHe", SqlDbType.NVarChar, 50, info.YGZongHe), SqlDB.MakeInParam("@YGZongFen", SqlDbType.NVarChar, 50, info.YGZongFen), SqlDB.MakeInParam("@GKYuWen", SqlDbType.NVarChar, 50, info.GKYuWen), SqlDB.MakeInParam("@GKShuXue", SqlDbType.NVarChar, 50, info.GKShuXue), SqlDB.MakeInParam("@GKYingYu", SqlDbType.NVarChar, 50, info.GKYingYu), SqlDB.MakeInParam("@GKZhongHe", SqlDbType.NVarChar, 50, info.GKZhongHe), SqlDB.MakeInParam("@GKZongFen", SqlDbType.NVarChar, 50, info.GKZongFen), SqlDB.MakeInParam("@DianId", SqlDbType.Int, 4, info.DianId), SqlDB.MakeInParam("@IsPause", SqlDbType.Int, 4, info.IsPause), SqlDB.MakeInParam("@GaoKaoKaHao", SqlDbType.NVarChar, 50, info.GaoKaoKaHao), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "YKStudentXinXiAdd", prams).ToString(), -1)); }