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