public void DbUpdateTag(string myTag, DbConnection myDbCon) { string sqlCommand = "UPDATE " + GetTableName() + " "; sqlCommand += "SET TAG = @pTag "; sqlCommand += "WHERE ID = @pId "; SqlCommand command = new SqlCommand(); command = new SqlCommand(sqlCommand, myDbCon.getSqlConnection()); SqlParameter[] sqlparams = new SqlParameter[2]; sqlparams[0] = new SqlParameter("@pTag", SqlDbType.VarChar); sqlparams[0].Value = myTag; sqlparams[1] = new SqlParameter("@pId", SqlDbType.Int); sqlparams[1].Value = Id; myDbCon.SetParameter(sqlparams); myDbCon.execSqlCommand(sqlCommand); this.Tag = myTag; }
public void DbUpdateRating(int myRating, DbConnection myDbCon) { string sqlCommand = "UPDATE " + GetTableName() + " "; sqlCommand += "SET RATING = @pRating "; sqlCommand += "WHERE ID = @pId "; SqlCommand command = new SqlCommand(); command = new SqlCommand(sqlCommand, myDbCon.getSqlConnection()); SqlParameter[] sqlparams = new SqlParameter[2]; sqlparams[0] = new SqlParameter("@pRating", SqlDbType.Int); sqlparams[0].Value = myRating; sqlparams[1] = new SqlParameter("@pId", SqlDbType.Int); sqlparams[1].Value = Id; myDbCon.SetParameter(sqlparams); int cnt = myDbCon.execSqlCommand(sqlCommand); if (cnt <= 0) throw new Exception("更新行が0件でした " + GetTableName() + " Id " + Id); Rating = myRating; }
public void DbUpdate(DbConnection myDbCon) { int paramCnt = 0; int paramMax = 0; string sqlCommand = "UPDATE " + GetTableName() + " "; sqlCommand += "SET NAME = @pName "; sqlCommand += " , LABEL = @pLabel "; sqlCommand += " , TAG = @pTag "; sqlCommand += " , EXTENSION = @pExtension "; if (this.Kind == MovieContents.KIND_FILE) { sqlCommand += " , PRODUCT_NUMBER = @pProductNumber "; sqlCommand += " , SELL_DATE = @pSellDate "; sqlCommand += " , FILE_DATE = @pFileDate "; paramMax = 8; } else paramMax = 5; sqlCommand += "WHERE ID = @pId "; SqlCommand command = new SqlCommand(); command = new SqlCommand(sqlCommand, myDbCon.getSqlConnection()); SqlParameter[] sqlparams = new SqlParameter[paramMax]; paramCnt = 0; sqlparams[paramCnt] = new SqlParameter("@pName", SqlDbType.VarChar); sqlparams[paramCnt].Value = Name; paramCnt++; sqlparams[paramCnt] = new SqlParameter("@pLabel", SqlDbType.VarChar); sqlparams[paramCnt].Value = Label; paramCnt++; sqlparams[paramCnt] = new SqlParameter("@pTag", SqlDbType.VarChar); if (Tag == null || Tag.Length <= 0) sqlparams[paramCnt].Value = DBNull.Value; else sqlparams[paramCnt].Value = Tag; paramCnt++; sqlparams[paramCnt] = new SqlParameter("@pExtension", SqlDbType.VarChar); sqlparams[paramCnt].Value = Extension; paramCnt++; if (this.Kind == MovieContents.KIND_FILE) { sqlparams[paramCnt] = new SqlParameter("@pProductNumber", SqlDbType.VarChar); sqlparams[paramCnt].Value = ProductNumber; paramCnt++; sqlparams[paramCnt] = new SqlParameter("@pSellDate", SqlDbType.Date); sqlparams[paramCnt].Value = SellDate; paramCnt++; sqlparams[paramCnt] = new SqlParameter("@pFileDate", SqlDbType.Date); sqlparams[paramCnt].Value = FileDate; paramCnt++; } sqlparams[paramCnt] = new SqlParameter("@pId", SqlDbType.Int); sqlparams[paramCnt].Value = Id; myDbCon.SetParameter(sqlparams); myDbCon.execSqlCommand(sqlCommand); return; }
public void DbUpdateName(string myName, DbConnection myDbCon) { string sqlCommand = "UPDATE " + GetTableName() + " "; sqlCommand += "SET NAME = @pName "; sqlCommand += "WHERE ID = @pId "; SqlCommand command = new SqlCommand(); command = new SqlCommand(sqlCommand, myDbCon.getSqlConnection()); SqlParameter[] sqlparams = new SqlParameter[2]; sqlparams[0] = new SqlParameter("@pName", SqlDbType.VarChar); sqlparams[0].Value = myName; sqlparams[1] = new SqlParameter("@pId", SqlDbType.Int); sqlparams[1].Value = Id; myDbCon.SetParameter(sqlparams); int cnt = myDbCon.execSqlCommand(sqlCommand); if (cnt <= 0) throw new Exception("Name更新行が0件でした " + GetTableName() + " Id " + Id); }
public void DbDelete(DbConnection myDbCon) { string sqlCommand = "DELETE FROM " + GetTableName() + " "; sqlCommand += "WHERE ID = @pId "; SqlCommand command = new SqlCommand(); command = new SqlCommand(sqlCommand, myDbCon.getSqlConnection()); SqlParameter[] sqlparams = new SqlParameter[1]; sqlparams[0] = new SqlParameter("@pId", SqlDbType.Int); sqlparams[0].Value = Id; myDbCon.SetParameter(sqlparams); myDbCon.execSqlCommand(sqlCommand); }