Exemple #1
0
 public int sendMessage(String myID, String otherID, String content)
 {
     if (DatabaseTool.ExecSql(String.Format(addMessage, myID, otherID, DateTime.Now, content, 0)))
     {
         return(1);
     }
     else
     {
         return(-1);
     }
 }
Exemple #2
0
 public int updateRead(String myID, String otherID)
 {
     if (DatabaseTool.ExecSql(String.Format(setRead, myID, otherID)))
     {
         return(1);
     }
     else
     {
         return(-1);
     }
 }
Exemple #3
0
 public int deleteGood(int goodID)
 {
     if (DatabaseTool.ExecSql(String.Format(deleteSql, goodID)))
     {
         return(1);
     }
     else
     {
         return(-1);
     }
 }
Exemple #4
0
 public int insertUser(String phoneNum, String name, String school, String campus, String college, String password, String userID)
 {
     if (DatabaseTool.ExecSql(String.Format(insertSql, phoneNum, name, school, campus, college, password, userID)))
     {
         return(1);
     }
     else
     {
         return(-1);
     }
 }
Exemple #5
0
 public int insertRelease(String goodName, String goodImg, Double price, String address, String category, int bargin, String contact, String newLevel, String detail, String userID)
 {
     if (DatabaseTool.ExecSql(String.Format(insertSql, category, price, bargin, contact, goodImg, detail, newLevel, userID, goodName, address)))
     {
         return(1);
     }
     else
     {
         return(-1);
     }
 }
Exemple #6
0
 public int updateGoodNotPic(String category, Double prize, int bargin, String contact, String description, String new_level, String goodsName, String address, int goodID)
 {
     //调用数据库语句,更新商品信息,没写呢
     if (DatabaseTool.ExecSql(String.Format(updateSql1, category, prize, bargin, contact, description, new_level, goodsName, address, goodID)))
     {
         return(1);
     }
     else
     {
         return(-1);
     }
 }
Exemple #7
0
 public int insertColl(String userID, String goodID)
 {
     if (DatabaseTool.ExcelSelectResult(String.Format(selectCollection, userID, goodID)))
     {
         return(-1);
     }
     else if (DatabaseTool.ExecSql(String.Format(insertCollection, userID, goodID)))
     {
         return(1);
     }
     else
     {
         return(-1);
     }
 }