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