public bool DeleteByID(int clientrequireId)
{
SqlParameter[] cmdParams = new SqlParameter[1];
cmdParams[0] = new SqlParameter("@ID", SqlDbType.Int, 4);
cmdParams[0].Value = clientrequireId;
return(SqlHelper.ExecuteProc("PR_ClientRequire_Delete", cmdParams));
}
public bool Update(ZoomLa.Model.M_ModelField MField)
{
string strSql = "PR_ModelField_Update";
SqlParameter[] cmdParams = GetParameters(MField);
return(SqlHelper.ExecuteProc(strSql, cmdParams));
}
/// <summary>
/// 将管理员信息更新到数据库中
/// </summary>
/// <param name="administratorInfo">M_AdminInfo 管理员信息</param>
/// <returns></returns>
public bool Update(M_AdminInfo administratorInfo)
{
string strSql = "PR_Manage_Update";
SqlParameter[] cmdParams = GetParameters(administratorInfo);
return(SqlHelper.ExecuteProc(strSql, cmdParams));
}
public bool DeleteByID(string keywordId)
{
SqlParameter[] cmdParams = new SqlParameter[1];
cmdParams[0] = new SqlParameter("@KeywordId", SqlDbType.NVarChar, 4000);
cmdParams[0].Value = keywordId;
return(SqlHelper.ExecuteProc("PR_Keywords_Delete", cmdParams));
}
public bool AddSurvey(M_Survey m_Survey)
{
string strSql = "PR_Survey_Add";
SqlParameter[] parameter = GetParameters(m_Survey);
return(SqlHelper.ExecuteProc(strSql, parameter));
}
public bool DelProjectDiscuss(int DiscussID)
{
SqlParameter[] cmdParams = new SqlParameter[1];
cmdParams[0] = new SqlParameter("@ID", SqlDbType.Int, 4);
cmdParams[0].Value = DiscussID;
return(SqlHelper.ExecuteProc("PR_ProjectDiscuss_Delete", cmdParams));
}
/// <summary>
/// 更新模型信息
/// </summary>
/// <param name="ModelInfo">模型的新信息</param>
/// <returns>返回更新状态 成功为true</returns>
bool ID_Model.Update(M_ModelInfo ModelInfo)
{
string strSql = "PR_Model_Add";
SqlParameter[] cmdParams = GetParameters(ModelInfo);
return(SqlHelper.ExecuteProc(strSql, cmdParams));
}
/// <summary>
/// 更新会员模型
/// </summary>
/// <param name="info"></param>
void ID_UserModel.Update(M_UserModel info)
{
string strSql = "PR_UserModel_Update";
SqlParameter[] cmdParams = GetParameters(info);
SqlHelper.ExecuteProc(strSql, cmdParams);
}
public bool UpdateProjectWork(M_ProjectWork m_projwork)
{
string strSql = "PR_ProjectWork_Update";
SqlParameter[] cmdParams = GetParameters(m_projwork);
return(SqlHelper.ExecuteProc(strSql, cmdParams));
}
/// <summary>
/// 增加会员
/// </summary>
/// <param name="UserInfo"></param>
/// <returns></returns>
public bool Add(M_UserInfo UserInfo)
{
string strSql = "PR_User_AddUpdate";
SqlParameter[] parameter = GetParameters(UserInfo);
return(SqlHelper.ExecuteProc(strSql, parameter));
}
bool ID_Group.Update(M_Group info)
{
string strSql = "PR_Group_Update";
SqlParameter[] cmdParams = GetParameters(info);
return(SqlHelper.ExecuteProc(strSql, cmdParams));
}
public bool DeleteByID(string sourceId)
{
SqlParameter[] cmdParams = new SqlParameter[1];
cmdParams[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 100);
cmdParams[0].Value = sourceId;
return(SqlHelper.ExecuteProc("PR_Source_Delete", cmdParams));
}
public bool Add(M_Source SourceInfo)
{
string strSql = "PR_Source_Insert";
SqlParameter[] parameter = GetParameters(SourceInfo);
return(SqlHelper.ExecuteProc(strSql, parameter));
}
bool ID_Node.UpdateNode(M_Node NodeInfo)
{
string strSql = "PR_Nodes_Update";
SqlParameter[] cmdParams = GetParameters(NodeInfo);
return(SqlHelper.ExecuteProc(strSql, cmdParams));
}
public bool DelAnswerByAid(int AnswerID)
{
SqlParameter[] cmdParams = new SqlParameter[1];
cmdParams[0] = new SqlParameter("@ID", SqlDbType.Int, 4);
cmdParams[0].Value = AnswerID;
return(SqlHelper.ExecuteProc("PR_Answer_DeleteAid", cmdParams));
}
public bool Add(M_DownServer DownServerInfo)
{
string strSql = "PR_DownServer_Add";
SqlParameter[] parameter = GetParameters(DownServerInfo);
return(SqlHelper.ExecuteProc(strSql, parameter));
}
public bool AddProjectDiscuss(M_ProjectDiscuss ProjectDiscuss)
{
string strSql = "PR_ProjectDiscuss_Add";
SqlParameter[] parameter = GetParameters(ProjectDiscuss);
return(SqlHelper.ExecuteProc(strSql, parameter));
}
public bool DeleteByID(string downserverId)
{
SqlParameter[] cmdParams = new SqlParameter[1];
cmdParams[0] = new SqlParameter("@ServerID", SqlDbType.NVarChar, 4000);
cmdParams[0].Value = downserverId;
return(SqlHelper.ExecuteProc("PR_DownServer_Delete", cmdParams));
}
public bool UpdateProjectDiscuss(M_ProjectDiscuss ProjectDiscuss)
{
string strSql = "PR_ProjectDiscuss_Update";
SqlParameter[] cmdParams = GetParameters(ProjectDiscuss);
return(SqlHelper.ExecuteProc(strSql, cmdParams));
}
public bool AddQuestiony(M_Question m_Question)
{
string strSql = "PR_Questiony_Add";
SqlParameter[] parameter = GetParameters(m_Question);
return(SqlHelper.ExecuteProc(strSql, parameter));
}
public bool Add(M_KeyWord KeyWordInfo)
{
string strSql = "PR_Keywords_Add";
SqlParameter[] parameter = GetParameters(KeyWordInfo);
return(SqlHelper.ExecuteProc(strSql, parameter));
}
public bool DelQuestionByQid(int QuestionID)
{
SqlParameter[] cmdParams = new SqlParameter[1];
cmdParams[0] = new SqlParameter("@ID", SqlDbType.Int, 4);
cmdParams[0].Value = QuestionID;
return(SqlHelper.ExecuteProc("PR_Question_Delete", cmdParams));
}
void ID_Spec.UpdateSpec(M_Spec Spec)
{
string strSql = "PR_Spec_AddUpdate";
SqlParameter[] cmdParams = GetParameters(Spec);
SqlHelper.ExecuteProc(strSql, cmdParams);
}
void ID_Label.UpdateLabel(M_Label label)
{
string strSql = "PR_Label_Update";
SqlParameter[] cmdParams = GetParameters(label);
SqlHelper.ExecuteProc(strSql, cmdParams);
}
public bool DelSurveyBySid(int SurveyID)
{
SqlParameter[] cmdParams = new SqlParameter[1];
cmdParams[0] = new SqlParameter("@ID", SqlDbType.Int, 4);
cmdParams[0].Value = SurveyID;
return(SqlHelper.ExecuteProc("PR_Survey_Delete", cmdParams));
}
void ID_Favorite.AddFavorite(M_Favorite favorite)
{
string strSql = "PR_Favorite_Add";
SqlParameter[] cmdParams = GetParameters(favorite);
SqlHelper.ExecuteProc(strSql, cmdParams);
}
/// <summary>
/// 发表(增加)评论
/// </summary>
/// <param name=commentInfo"></param>
/// <returns>返回True/False</returns>
bool ID_Comment.Add(M_Comment commentInfo)
{
string sqlStr = "PR_Comments_Add";
SqlParameter[] parameter = GetParameters(commentInfo);
return(SqlHelper.ExecuteProc(sqlStr, parameter));
}
public bool AddAnswer(M_Answer m_Answer)
{
string strSql = "PR_Answer_Add";
SqlParameter[] parameter = GetParameters(m_Answer);
return(SqlHelper.ExecuteProc(strSql, parameter));
}
/// <summary>
/// 增加新的管理员到数据库中
/// </summary>
/// <param name="administratorInfo">管理员数据模型</param>
/// <returns>增加结果状态 成功为true 反之 false</returns>
public bool Add(M_AdminInfo adminInfo)
{
string strSql = "PR_Manage_Add";
SqlParameter[] parameter = new SqlParameter[10];
parameter[0] = new SqlParameter("@AdminName", SqlDbType.NVarChar, 20);
parameter[0].Value = adminInfo.AdminName;
parameter[1] = new SqlParameter("@AdminPassword", SqlDbType.NVarChar, 255);
parameter[1].Value = adminInfo.AdminPassword;
parameter[2] = new SqlParameter("@UserName", SqlDbType.NVarChar, 20);
parameter[2].Value = adminInfo.UserName;
parameter[3] = new SqlParameter("@EnableMultiLogin", SqlDbType.Bit, 1);
parameter[3].Value = adminInfo.EnableMultiLogin;
parameter[4] = new SqlParameter("@LastLoginIp", SqlDbType.NVarChar, 50);
parameter[4].Value = adminInfo.LastLoginIP;
parameter[5] = new SqlParameter("@IsLock", SqlDbType.Bit, 1);
parameter[5].Value = adminInfo.IsLock;
parameter[6] = new SqlParameter("@EnableModifyPassword", SqlDbType.Bit, 1);
parameter[6].Value = adminInfo.EnableModifyPassword;
parameter[7] = new SqlParameter("@AdminRole", SqlDbType.NVarChar, 255);
parameter[7].Value = adminInfo.RoleList;
parameter[8] = new SqlParameter("@Theme", SqlDbType.NVarChar, 50);
parameter[8].Value = adminInfo.Theme;
parameter[9] = new SqlParameter("@RndPassword", SqlDbType.NVarChar, 10);
parameter[9].Value = adminInfo.RandNumber;
return(SqlHelper.ExecuteProc(strSql, parameter));
}
public bool Add(M_ClientRequire ClientRequireinfo)
{
string strSql = "PR_ClientRequire_Add";
SqlParameter[] parameter = GetParameters(ClientRequireinfo);
return(SqlHelper.ExecuteProc(strSql, parameter));
}
