//删除成绩 //输入: // XUserID - 用户编号; //输出: // 删除成功:返回True; // 删除失败:返回False; public bool DeleteByStr(int SID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); string strsql = "DELETE FROM Scoretb WHERE ID = @ID"; Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, SID); //成绩编号 int Count = -1; Count = DB.ProcStr(strsql, Params); if (Count > 0) return true; else return false; }
//我是周浩----我是周浩 //更新试卷是否评阅的状态 public bool UpdateByProc(string XUserID, int XPaperID, string Xstate) { SqlParameter[] Params = new SqlParameter[3]; DataBase DB = new DataBase(); string strsql = "UPDATE UserAnswertb SET state= @state WHERE UserID = @UserID and PaperID= @PaperID"; Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, XUserID); Params[1] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, XPaperID); Params[2] = DB.MakeInParam("@state", SqlDbType.VarChar, 50, Xstate); int Count = -1; Count = DB.ProcStr(strsql, Params); if (Count > 0) return true; else return false; }