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