/// <summary> /// 根据专业编号获取该专业信息 /// </summary> /// <param name="ProfessionalId">专业编号</param> /// <returns></returns> public sys_ProfessionalModel GetProfessionalByProfessId(int ProfessionalId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ProfessionalId,ProfessionalName,ProfessionalState from sys_Professional"); strSql.Append(" where ProfessionalId=@ProfessionalId "); SqlParameter[] paras = { new SqlParameter("@ProfessionalId", SqlDbType.Int, 4) }; paras[0].Value = ProfessionalId; sys_ProfessionalModel professModel = new sys_ProfessionalModel(); SqlDataReader reader = DBHelper.ExecuteReader(strSql.ToString(), paras); if (reader != null) { while (reader.Read()) { professModel.ProfessionalId = reader.GetInt32(0); professModel.ProfessionalName = reader.GetString(1); professModel.ProfessionalState = reader.GetInt32(2); } } reader.Close(); return(professModel); }
/// <summary> /// 根据专业实体对象修改专业信息 1成功 0 失败 -1出错 /// </summary> /// <param name="professModel">专业实体对象</param> /// <returns></returns> public int UpdateProfessional(sys_ProfessionalModel professModel) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update sys_Professional set ProfessionalName=@ProfessionalName, "); strSql.Append(" ProfessionalState=@ProfessionalState "); strSql.Append(" where ProfessionalId =@ProfessionalId "); SqlParameter[] paras = { new SqlParameter("@ProfessionalName", SqlDbType.VarChar, 50), new SqlParameter("@ProfessionalState", SqlDbType.Int, 4), new SqlParameter("@ProfessionalId", SqlDbType.Int, 4) }; paras[0].Value = professModel.ProfessionalName; paras[1].Value = professModel.ProfessionalState; paras[2].Value = professModel.ProfessionalId; int number = DBHelper.ExecuteNonQuery(strSql.ToString(), paras); return(number); } catch (Exception) { return(-1); throw; } }
public string UpdateProfessional(sys_ProfessionalModel professModel) { JsonMessage json = new JsonMessage(); string strWhere = "ProfessionalId !=" + professModel.ProfessionalId + " and ProfessionalName ='" + professModel.ProfessionalName + "'"; if (professDAL.GetProfessionalByWhere(strWhere).Rows.Count == 0) { int number = professDAL.UpdateProfessional(professModel); if (number > 0) { json.Success = true; json.Msg = "专业修改成功"; } else if (number == 0) { json.Success = false; json.Msg = "专业修改失败"; } else { json.Success = false; json.Msg = "专业修改出错"; } } else { json.Success = false; json.Msg = "该专业已经存在"; } return(JsonHelper.ToJson(json)); }
private string AddProfessional(HttpContext context) { sys_ProfessionalModel professModel = new sys_ProfessionalModel(); professModel.ProfessionalName = context.Request.Form["pname"].ToString(); professModel.ProfessionalState = int.Parse(context.Request.Form["pstate"].ToString()); string result = professBLL.AddProfessional(professModel); return(result); }
public string AddProfessional(sys_ProfessionalModel professModel) { JsonMessage json = new JsonMessage(); int number = professDAL.AddProfessional(professModel); if (number > 0) { json.Success = true; json.Msg = "专业添加成功"; } else if (number == 0) { json.Success = false; json.Msg = "专业添加失败"; } else { json.Success = false; json.Msg = "专业添加出错"; } return(JsonHelper.ToJson(json)); }
/// <summary> /// 根据专业实体对象添加专业信息,1 成功 0 失败 -1 出错 /// </summary> /// <param name="professModel">专业实体对象</param> /// <returns></returns> public int AddProfessional(sys_ProfessionalModel professModel) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into sys_Professional (ProfessionalName,ProfessionalState ) values ( "); strSql.Append("@ProfessionalName,@ProfessionalState ) "); SqlParameter[] paras = { new SqlParameter("@ProfessionalName", SqlDbType.VarChar, 50), new SqlParameter("@ProfessionalState", SqlDbType.Int, 4) }; paras[0].Value = professModel.ProfessionalName; paras[1].Value = professModel.ProfessionalState; int number = DBHelper.ExecuteNonQuery(strSql.ToString(), paras); return(number); } catch (Exception) { return(-1); throw; } }
public string GetProfessionById(int professId) { sys_ProfessionalModel professModel = professDAL.GetProfessionalByProfessId(professId); return(JsonHelper.ToJson(professModel)); }