/// <summary>
/// 添加指定领域到指定专家
/// </summary>
/// <returns></returns>
public static int AddFieldExpert(Field field, UserExpert userExpert)
{
ExpertField ThisExpertField = new ExpertField();
//封装一个专家和领域实体
ThisExpertField.ExpertId = userExpert.Id;
ThisExpertField.FieldId = field.Id;
ThisExpertField.IsDefine = false;
ThisExpertField.DefineName = "";
//调用添加函数
return(ExpertFieldService.InsertExpertField(ThisExpertField));
}
/// <summary>
/// 新建专家--领域关系对象
/// </summary>
/// <param name="expertField"></param>
/// <returns></returns>
public static int InsertExpertField(ExpertField expertField)
{
string sql = "Insert into expertField(ExpertField_ExpertID, ExpertField_FieldID, ExpertField_IsUserDefine, ExpertField_UserDefineName) "
+ " Values(@ExpertField_ExpertID, @ExpertField_FieldID, @ExpertField_IsUserDefine, @ExpertField_UserDefineName)";
//连接数据库，执行SQL语句
DBVisit.ObjDBAccess.CommandStr = sql;
DBVisit.ObjDBAccess.CmdParas.Add("@ExpertField_ExpertID", SqlDbType.Int).Value = expertField.ExpertId;
DBVisit.ObjDBAccess.CmdParas.Add("@ExpertField_FieldID", SqlDbType.Int).Value = expertField.FieldId;
DBVisit.ObjDBAccess.CmdParas.Add("@ExpertField_IsUserDefine", SqlDbType.Bit).Value = expertField.IsDefine;
DBVisit.ObjDBAccess.CmdParas.Add("@ExpertField_UserDefineName", SqlDbType.VarChar, 50).Value = expertField.DefineName;
return(DBVisit.ObjDBAccess.ExecuteUnSelectSqlCommand());
}
/// <summary>
/// 更新专家--领域关系对象
/// </summary>
/// <param name="expertField"></param>
/// <returns></returns>
public static int UpdateExpertField(ExpertField expertField)
{
//SQL语句
string sql = "Update expertField set [ExpertField_ExpertID] = @ExpertField_ExpertID, [ExpertField_FieldID] = @ExpertField_FieldID, [ExpertField_IsUserDefine] = @ExpertField_IsUserDefine,"
+ " [ExpertField_UserDefineName] = @ExpertField_UserDefineName where [ExpertField_ID] = @ExpertField_ID";
//连接数据库，执行SQL语句
DBVisit.ObjDBAccess.CommandStr = sql;
DBVisit.ObjDBAccess.CmdParas.Add("@ExpertField_ID", SqlDbType.Int).Value = expertField.ID;
DBVisit.ObjDBAccess.CmdParas.Add("@ExpertField_ExpertID", SqlDbType.Int).Value = expertField.ExpertId;
DBVisit.ObjDBAccess.CmdParas.Add("@ExpertField_FieldID", SqlDbType.Int).Value = expertField.FieldId;
DBVisit.ObjDBAccess.CmdParas.Add("@ExpertField_IsUserDefine", SqlDbType.Bit).Value = expertField.IsDefine;
DBVisit.ObjDBAccess.CmdParas.Add("@ExpertField_UserDefineName", SqlDbType.VarChar, 50).Value = expertField.DefineName;
return(DBVisit.ObjDBAccess.ExecuteUnSelectSqlCommand());
}
/// <summary>
/// 根据id返回专家--领域关系对象
/// </summary>
/// <returns></returns>
public static ExpertField GetExpertFieldById(int id)
{
//SQL语句
string sql = "select [ExpertField_ID], [ExpertField_ExpertID], [ExpertField_FieldID], [ExpertField_IsUserDefine], [ExpertField_UserDefineName] "
+ " from ExpertField where [ExpertField_ID] = @ExpertField_ID";
//连接数据库，执行SQL语句
DBVisit.ObjDBAccess.CommandStr = sql;
DBVisit.ObjDBAccess.CmdParas.Add("@ExpertField_ID", SqlDbType.Int).Value = id;
DataSet ds = DBVisit.ObjDBAccess.ExecuteSelectSqlCommand();
//实例化专家--领域关系对象
ExpertField expertField = new ExpertField();
expertField.ID = int.Parse(ds.Tables[0].Rows[0]["ExpertField_ID"].ToString());
expertField.ExpertId = int.Parse(ds.Tables[0].Rows[0]["ExpertField_ExpertID"].ToString());
expertField.FieldId = int.Parse(ds.Tables[0].Rows[0]["ExpertField_FieldID"].ToString());
expertField.IsDefine = bool.Parse(ds.Tables[0].Rows[0]["ExpertField_IsUserDefine"].ToString());
expertField.DefineName = ds.Tables[0].Rows[0]["ExpertField_UserDefineName"].ToString();
return(expertField);
}
public IActionResult Create(ExpertField row, string ReturnUrl)
{
row.ExpertID = this.Repository.ExpertID;
return(this.CreateBase(row, ReturnUrl));
}
public IActionResult Edit(ExpertField row, string returnURL)
{
row.ExpertID = this.Repository.ExpertID;
return(this.EditBase(row, returnURL));
}
