public void DbUpdate(DbConnection myDbCon)
{
string sqlCommand = "UPDATE MOVIE_SITECONTENTS ";
sqlCommand += "SET SITE_NAME = @pSiteName, NAME = @pName, PARENT_PATH = @pParentPath, MOVIE_NEWDATE = @pMovieNewDate, MOVIE_COUNT = @pMovieCount, PHOTO_COUNT = @pPhotoCount, EXTENSION = @pExtension ";
sqlCommand += "WHERE ID = @pId ";
MovieFileContentsParent parent = new MovieFileContentsParent();
SqlCommand command = new SqlCommand();
command = new SqlCommand(sqlCommand, myDbCon.getSqlConnection());
SqlParameter[] sqlparams = new SqlParameter[8];
// Create and append the parameters for the Update command.
sqlparams[0] = new SqlParameter("@pSiteName", SqlDbType.VarChar);
sqlparams[0].Value = SiteName;
sqlparams[1] = new SqlParameter("@pName", SqlDbType.VarChar);
sqlparams[1].Value = Name;
sqlparams[2] = new SqlParameter("@pParentPath", SqlDbType.VarChar);
sqlparams[2].Value = ParentPath;
sqlparams[3] = new SqlParameter("@pMovieNewDate", SqlDbType.DateTime);
if (MovieNewDate.Year >= 2000)
sqlparams[3].Value = MovieNewDate;
else
sqlparams[3].Value = Convert.DBNull;
sqlparams[4] = new SqlParameter("@pMovieCount", SqlDbType.VarChar);
sqlparams[4].Value = MovieCount;
// sqlparams[4] = new SqlParameter("@pSellDate", SqlDbType.DateTime);
// if (data.SellDate.Year >= 2000)
// sqlparams[4].Value = data.SellDate;
// else
// sqlparams[4].Value = Convert.DBNull;
sqlparams[5] = new SqlParameter("@pPhotoCount", SqlDbType.VarChar);
sqlparams[5].Value = PhotoCount;
sqlparams[6] = new SqlParameter("@pExtension", SqlDbType.VarChar);
sqlparams[6].Value = Extension;
sqlparams[7] = new SqlParameter("@pId", SqlDbType.Int);
sqlparams[7].Value = Id;
myDbCon.SetParameter(sqlparams);
myDbCon.execSqlCommand(sqlCommand);
}
public void DbDelete(DbConnection myDbCon)
{
string sqlCommand = "DELETE FROM MOVIE_SITECONTENTS ";
sqlCommand += "WHERE ID = @pId ";
MovieFileContentsParent parent = new MovieFileContentsParent();
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);
}
/// <summary>
/// MOVIE_ACTRESSのACTIVITY_DATEを更新する
/// </summary>
/// <param name="myDbCon"></param>
/// <returns></returns>
public static List<SiteInfo> UpdateGroupInfoActivityDate(DateTime myUpdateDate, GroupInfo myTargetInfo, DbConnection myDbCon)
{
List<SiteInfo> listSiteInfo = new List<SiteInfo>();
string cmdUpdate = "update MOVIE_ACTRESS set ACTIVITY_DATE = @pActivityDate where ID = @pId";
SqlParameter[] sqlparams = new SqlParameter[2];
sqlparams[0] = new SqlParameter("@pActivityDate", SqlDbType.DateTime);
sqlparams[0].Value = myUpdateDate;
sqlparams[1] = new SqlParameter("@pId", SqlDbType.Int);
sqlparams[1].Value = myTargetInfo.id;
myDbCon.openConnection();
myDbCon.SetParameter(sqlparams);
myDbCon.execSqlCommand(cmdUpdate);
myDbCon.closeConnection();
return listSiteInfo;
}
public void DbExport(DbConnection myDbCon)
{
string sqlCommand = "INSERT MOVIE_SITECONTENTS ";
sqlCommand += "( SITE_NAME, NAME, PARENT_PATH, MOVIE_NEWDATE, MOVIE_COUNT, PHOTO_COUNT, EXTENSION ) ";
sqlCommand += "VALUES( @pSiteName, @pName, @pParentPath, @pMovieNewDate, @pMovieCount, @pPhotoCount, @pExtension )";
SqlCommand command = new SqlCommand();
command = new SqlCommand(sqlCommand, myDbCon.getSqlConnection());
SqlParameter[] sqlparams = new SqlParameter[7];
// Create and append the parameters for the Update command.
sqlparams[0] = new SqlParameter("@pSiteName", SqlDbType.VarChar);
sqlparams[0].Value = SiteName;
sqlparams[1] = new SqlParameter("@pName", SqlDbType.VarChar);
sqlparams[1].Value = Name;
sqlparams[2] = new SqlParameter("@pParentPath", SqlDbType.VarChar);
sqlparams[2].Value = ParentPath;
sqlparams[3] = new SqlParameter("@pMovieNewDate", SqlDbType.DateTime);
if (MovieNewDate.Year >= 2000)
sqlparams[3].Value = MovieNewDate;
else
sqlparams[3].Value = Convert.DBNull;
sqlparams[4] = new SqlParameter("@pMovieCount", SqlDbType.VarChar);
sqlparams[4].Value = MovieCount;
sqlparams[5] = new SqlParameter("@pPhotoCount", SqlDbType.VarChar);
sqlparams[5].Value = PhotoCount;
sqlparams[6] = new SqlParameter("@pExtension", SqlDbType.VarChar);
sqlparams[6].Value = Extension;
myDbCon.SetParameter(sqlparams);
myDbCon.execSqlCommand(sqlCommand);
}
/// <summary>
/// MOVIE_SITESTOREのID一致ROWを削除する
/// </summary>
/// <param name="myDbCon"></param>
/// <returns></returns>
public static void DeleteSiteStore(SiteStore myTargetData, DbConnection myDbCon)
{
List<SiteInfo> listSiteInfo = new List<SiteInfo>();
string cmdUpdate = "DELETE FROM MOVIE_SITESTORE WHERE ID = @pId";
SqlParameter[] sqlparams = new SqlParameter[1];
sqlparams[0] = new SqlParameter("@pId", SqlDbType.Int);
sqlparams[0].Value = myTargetData.Id;
myDbCon.openConnection();
myDbCon.SetParameter(sqlparams);
myDbCon.execSqlCommand(cmdUpdate);
myDbCon.closeConnection();
return;
}
/// <summary>
/// MOVIE_SITESTOREに行の更新をする
/// </summary>
/// <param name="myDbCon"></param>
/// <returns></returns>
public static void UpdateSiteStore(SiteStore myTargetData, DbConnection myDbCon)
{
List<SiteInfo> listSiteInfo = new List<SiteInfo>();
string cmdUpdate = "UPDATE MOVIE_SITESTORE SET NAME = @pName, LABEL = @pLabel, EXPLANATION = @pExplanation, KIND = @pKind WHERE ID = @pId";
SqlParameter[] sqlparams = new SqlParameter[5];
sqlparams[0] = new SqlParameter("@pName", SqlDbType.VarChar);
sqlparams[0].Value = myTargetData.Name;
sqlparams[1] = new SqlParameter("@pLabel", SqlDbType.VarChar);
sqlparams[1].Value = myTargetData.Label;
sqlparams[2] = new SqlParameter("@pExplanation", SqlDbType.VarChar);
sqlparams[2].Value = myTargetData.Explanation;
sqlparams[3] = new SqlParameter("@pKind", SqlDbType.Int);
sqlparams[3].Value = myTargetData.Kind;
sqlparams[4] = new SqlParameter("@pId", SqlDbType.Int);
sqlparams[5].Value = myTargetData.Id;
myDbCon.openConnection();
myDbCon.SetParameter(sqlparams);
myDbCon.execSqlCommand(cmdUpdate);
myDbCon.closeConnection();
return;
}
/// <summary>
/// MOVIE_SITESTOREに行を作成する
/// </summary>
/// <param name="myDbCon"></param>
/// <returns></returns>
public static void InsertSiteStore(SiteStore myTargetData, DbConnection myDbCon)
{
List<SiteInfo> listSiteInfo = new List<SiteInfo>();
string cmdUpdate = "INSERT INTO MOVIE_SITESTORE(NAME, LABEL, EXPLANATION, KIND) VALUES (@pName, @pLabel, @pExplanation, @pKind)";
SqlParameter[] sqlparams = new SqlParameter[4];
sqlparams[0] = new SqlParameter("@pName", SqlDbType.VarChar);
sqlparams[0].Value = myTargetData.Name;
sqlparams[1] = new SqlParameter("@pLabel", SqlDbType.VarChar);
sqlparams[1].Value = myTargetData.Label;
sqlparams[2] = new SqlParameter("@pExplanation", SqlDbType.VarChar);
sqlparams[2].Value = myTargetData.Explanation;
sqlparams[3] = new SqlParameter("@pKind", SqlDbType.Int);
sqlparams[3].Value = myTargetData.Kind;
myDbCon.openConnection();
myDbCon.SetParameter(sqlparams);
myDbCon.execSqlCommand(cmdUpdate);
myDbCon.closeConnection();
return;
}
public void DbDelete(DbConnection myDbCon)
{
string sqlCommand = "DELETE FROM MOVIE_FILES WHERE ID = @pId";
SqlCommand command = new SqlCommand();
command = new SqlCommand(sqlCommand, myDbCon.getSqlConnection());
SqlParameter[] sqlparams = new SqlParameter[1];
// Create and append the parameters for the Update command.
sqlparams[0] = new SqlParameter("@pId", SqlDbType.VarChar);
sqlparams[0].Value = Id;
myDbCon.SetParameter(sqlparams);
myDbCon.execSqlCommand(sqlCommand);
return;
}
public void DbExport(DbConnection myDbCon)
{
string sqlCommand = "INSERT INTO MOVIE_FILES (NAME, SIZE, FILE_DATE, LABEL, SELL_DATE, PRODUCT_NUMBER, FILE_COUNT, EXTENSION) VALUES( @pName, @pSize, @pFileDate, @pLabel, @pSellDate, @pProductNumber, @pFileCount, @pExtension )";
SqlCommand command = new SqlCommand();
command = new SqlCommand(sqlCommand, myDbCon.getSqlConnection());
SqlParameter[] sqlparams = new SqlParameter[8];
// Create and append the parameters for the Update command.
sqlparams[0] = new SqlParameter("@pName", SqlDbType.VarChar);
sqlparams[0].Value = Name;
sqlparams[1] = new SqlParameter("@pSize", SqlDbType.Decimal);
sqlparams[1].Value = Size;
sqlparams[2] = new SqlParameter("@pFileDate", SqlDbType.DateTime);
sqlparams[2].Value = FileDate;
sqlparams[3] = new SqlParameter("@pLabel", SqlDbType.VarChar);
sqlparams[3].Value = Label;
sqlparams[4] = new SqlParameter("@pSellDate", SqlDbType.DateTime);
if (SellDate.Year >= 2000)
sqlparams[4].Value = SellDate;
else
sqlparams[4].Value = Convert.DBNull;
sqlparams[5] = new SqlParameter("@pProductNumber", SqlDbType.VarChar);
sqlparams[5].Value = ProductNumber;
sqlparams[6] = new SqlParameter("@pFileCount", SqlDbType.Int);
sqlparams[6].Value = FileCount;
sqlparams[7] = new SqlParameter("@pExtension", SqlDbType.VarChar);
sqlparams[7].Value = Extension;
myDbCon.SetParameter(sqlparams);
myDbCon.execSqlCommand(sqlCommand);
return;
}