public MainWindow()
{
InitializeComponent();
dbcon = new DbConnection();
Player = new Player();
bgworkerFileDetailCopy = new BackgroundWorker();
bgworkerFileDetailCopy.WorkerSupportsCancellation = true;
bgworkerFileDetailCopy.WorkerReportsProgress = true;
}
/*
public static void DbExport(MovieGroup myMovieGroup, DbConnection myDbCon)
{
if (myDbCon == null)
myDbCon = new DbConnection();
myDbCon.openConnection();
string querySting = "INSERT INTO MOVIE_GROUP( NAME, LABEL, EXPLANATION, KIND ) VALUES ( @pName, @pLabel, @pExplanation, @pKind ) ";
SqlParameter[] sqlparams = new SqlParameter[4];
// Create and append the parameters for the Update command.
sqlparams[0] = new SqlParameter("@pName", SqlDbType.VarChar);
sqlparams[0].Value = myMovieGroup.Name;
sqlparams[1] = new SqlParameter("@pLabel", SqlDbType.VarChar);
sqlparams[1].Value = myMovieGroup.Label;
sqlparams[2] = new SqlParameter("@pExplanation", SqlDbType.VarChar);
sqlparams[2].Value = myMovieGroup.Explanation;
sqlparams[3] = new SqlParameter("@pKind", SqlDbType.Int);
sqlparams[3].Value = myMovieGroup.Kind;
myDbCon.SetParameter(sqlparams);
myDbCon.execSqlCommand(querySting);
}
*/
public static List<MovieActress> GetDbData(DbConnection myDbCon)
{
List<MovieActress> listMovieActress = new List<MovieActress>();
if (myDbCon == null)
myDbCon = new DbConnection();
string queryString
= "SELECT "
+ " ID, NAME, REMARK, ACTIVITY_DATE "
+ " FROM MOVIE_ACTRESS "
+ "";
SqlDataReader reader = null;
try
{
reader = myDbCon.GetExecuteReader(queryString);
do
{
if (reader.IsClosed)
{
_logger.Debug("reader.IsClosed");
throw new Exception("MOVIE_SITESTOREの取得でreaderがクローズされています");
}
while (reader.Read())
{
MovieActress data = new MovieActress();
data.Id = DbExportCommon.GetDbInt(reader, 0);
data.Name = DbExportCommon.GetDbString(reader, 1);
data.Remark = DbExportCommon.GetDbString(reader, 2);
data.ActivityDate = DbExportCommon.GetDbDateTime(reader, 5);
listMovieActress.Add(data);
}
} while (reader.NextResult());
}
finally
{
reader.Close();
}
reader.Close();
myDbCon.closeConnection();
return listMovieActress;
}
public static void DbDelete(MovieGroup myData, DbConnection myDbCon)
{
if (myDbCon == null)
myDbCon = new DbConnection();
myDbCon.openConnection();
string querySting = "DELETE FROM MOVIE_GROUP WHERE ID = @pId ";
SqlParameter[] sqlparams = new SqlParameter[1];
sqlparams[0] = new SqlParameter("@pId", SqlDbType.Int);
sqlparams[0].Value = myData.Id;
myDbCon.SetParameter(sqlparams);
myDbCon.execSqlCommand(querySting);
myDbCon.closeConnection();
}
public void DbDelete(MovieGroup myData, DbConnection myDbCon)
{
ColViewListMovieGroup.Remove(myData);
MovieGroups.DbDelete(myData, myDbCon);
}
public MovieGroupFilterAndSorts()
{
dbcon = new DbConnection();
DataSet();
}
public MovieGroupFilterAndSorts(DbConnection myDbCon)
{
dbcon = myDbCon;
DataSet();
}
public void DbUpdate(DbConnection myDbCon)
{
if (myDbCon == null)
myDbCon = new DbConnection();
myDbCon.openConnection();
string querySting = "UPDATE MOVIE_GROUP SET NAME = @pName, LABEL = @pLabel, EXPLANATION = @pExplanation, KIND = @pKind WHERE ID = @pId ";
// + " NAME ", LABEL, EXPLANATION, KIND ) VALUES ( @pName, @pLabel, @pExplanation, @pKind ) ";
SqlParameter[] sqlparams = new SqlParameter[5];
sqlparams[0] = new SqlParameter("@pName", SqlDbType.VarChar);
sqlparams[0].Value = Name;
sqlparams[1] = new SqlParameter("@pLabel", SqlDbType.VarChar);
sqlparams[1].Value = Label;
sqlparams[2] = new SqlParameter("@pExplanation", SqlDbType.VarChar);
sqlparams[2].Value = Explanation;
sqlparams[3] = new SqlParameter("@pKind", SqlDbType.Int);
sqlparams[3].Value = Kind;
sqlparams[4] = new SqlParameter("@pId", SqlDbType.Int);
sqlparams[4].Value = Id;
myDbCon.SetParameter(sqlparams);
myDbCon.execSqlCommand(querySting);
}
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);
}
public MovieContentsFilterAndSort(DbConnection myDbCon)
{
dbcon = myDbCon;
DataSet();
}
public void RefrectFileInfoAndDbUpdate(detail.FileDetail myFileDetail, DbConnection myDbCon)
{
Size = myFileDetail.Size;
FileDate = myFileDetail.FileDate;
Extension = myFileDetail.Extension;
FileCount = myFileDetail.FileCount;
DbUpdate(myDbCon);
return;
}
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 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 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 static MovieGroup DbExport(MovieGroup myMovieGroup, DbConnection myDbCon)
{
if (myDbCon == null)
myDbCon = new DbConnection();
myDbCon.openConnection();
string querySting = "INSERT INTO MOVIE_GROUP( NAME, LABEL, EXPLANATION, KIND ) VALUES ( @pName, @pLabel, @pExplanation, @pKind ) ";
SqlParameter[] sqlparams = new SqlParameter[4];
// Create and append the parameters for the Update command.
sqlparams[0] = new SqlParameter("@pName", SqlDbType.VarChar);
sqlparams[0].Value = myMovieGroup.Name;
sqlparams[1] = new SqlParameter("@pLabel", SqlDbType.VarChar);
sqlparams[1].Value = myMovieGroup.Label;
sqlparams[2] = new SqlParameter("@pExplanation", SqlDbType.VarChar);
sqlparams[2].Value = myMovieGroup.Explanation;
sqlparams[3] = new SqlParameter("@pKind", SqlDbType.Int);
sqlparams[3].Value = myMovieGroup.Kind;
myDbCon.SetParameter(sqlparams);
myDbCon.execSqlCommand(querySting);
string queryString
= "SELECT "
+ " ID, NAME, LABEL, EXPLANATION, KIND, CREATE_DATE, UPDATE_DATE "
+ " FROM MOVIE_GROUP WHERE ID IN (SELECT MAX(ID) FROM MOVIE_GROUP) "
+ ""
+ "";
SqlDataReader reader = null;
MovieGroup data = null;
try
{
reader = myDbCon.GetExecuteReader(queryString);
do
{
if (reader.IsClosed)
{
_logger.Debug("reader.IsClosed");
throw new Exception("MOVIE_SITESTOREの取得でreaderがクローズされています");
}
while (reader.Read())
{
data = new MovieGroup();
data.Id = DbExportCommon.GetDbInt(reader, 0);
data.Name = DbExportCommon.GetDbString(reader, 1);
data.Label = DbExportCommon.GetDbString(reader, 2);
data.Explanation = DbExportCommon.GetDbString(reader, 3);
data.Kind = DbExportCommon.GetDbInt(reader, 4);
data.CreateDate = DbExportCommon.GetDbDateTime(reader, 5);
data.UpdateDate = DbExportCommon.GetDbDateTime(reader, 6);
}
} while (reader.NextResult());
}
finally
{
reader.Close();
}
return data;
}
public static List<MovieGroup> GetDbData(DbConnection myDbCon)
{
List<MovieGroup> listMovieGroup = new List<MovieGroup>();
if (myDbCon == null)
myDbCon = new DbConnection();
string queryString
= "SELECT "
+ " ID, NAME, LABEL, EXPLANATION, KIND, CREATE_DATE, UPDATE_DATE "
+ " FROM MOVIE_GROUP "
+ ""
+ "";
SqlDataReader reader = null;
try
{
reader = myDbCon.GetExecuteReader(queryString);
do
{
if (reader.IsClosed)
{
_logger.Debug("reader.IsClosed");
throw new Exception("MOVIE_SITESTOREの取得でreaderがクローズされています");
}
while (reader.Read())
{
MovieGroup data = new MovieGroup();
data.Id = DbExportCommon.GetDbInt(reader, 0);
data.Name = DbExportCommon.GetDbString(reader, 1);
data.Label = DbExportCommon.GetDbString(reader, 2);
data.Explanation = DbExportCommon.GetDbString(reader, 3);
data.Kind = DbExportCommon.GetDbInt(reader, 4);
data.CreateDate = DbExportCommon.GetDbDateTime(reader, 5);
data.UpdateDate = DbExportCommon.GetDbDateTime(reader, 6);
listMovieGroup.Add(data);
}
} while (reader.NextResult());
}
finally
{
reader.Close();
}
reader.Close();
myDbCon.closeConnection();
return listMovieGroup;
}
public static List<MovieContents> GetDbViewContents(DbConnection myDbCon)
{
List<MovieContents> listMContents = new List<MovieContents>();
if (myDbCon == null)
myDbCon = new DbConnection();
string queryString
= "SELECT KIND "
+ " , ID, NAME, SIZE "
+ " , FILE_DATE, MOVIE_NEWDATE, SELL_DATE "
+ " , RATING, LABEL, COMMENT, REMARK "
+ " , SITE_NAME "
+ " , PRODUCT_NUMBER "
+ " , FILE_COUNT, MOVIE_COUNT, PHOTO_COUNT "
+ " , EXTENSION, CREATE_DATE, UPDATE_DATE "
+ " , TAG "
+ " FROM V_MOVIE_CONTENTS "
+ ""
+ "";
SqlDataReader reader = null;
try
{
reader = myDbCon.GetExecuteReader(queryString);
do
{
if (reader.IsClosed)
{
_logger.Debug("V_MOVIE_CONTENTS reader.IsClosed");
throw new Exception("COMPANY_ARREARS_DETAILの残高の取得でreaderがクローズされています");
}
while (reader.Read())
{
MovieContents data = new MovieContents();
data.Kind = DbExportCommon.GetDbInt(reader, 0);
data.Id = DbExportCommon.GetDbInt(reader, 1);
data.Name = DbExportCommon.GetDbString(reader, 2);
data.Size = DbExportCommon.GetLong(reader, 3);
data.FileDate = DbExportCommon.GetDbDateTime(reader, 4);
data.MovieNewDate = DbExportCommon.GetDbDateTime(reader, 5);
data.SellDate = DbExportCommon.GetDbDateTime(reader, 6);
data.Rating = DbExportCommon.GetDbInt(reader, 7);
data.Label = DbExportCommon.GetDbString(reader, 8);
data.Comment = DbExportCommon.GetDbString(reader, 9);
data.Remark = DbExportCommon.GetDbString(reader, 10);
data.SiteName = DbExportCommon.GetDbString(reader, 11);
data.ProductNumber = DbExportCommon.GetDbString(reader, 12);
data.FileCount = DbExportCommon.GetDbInt(reader, 13);
data.MovieCount = DbExportCommon.GetDbString(reader, 14);
data.PhotoCount = DbExportCommon.GetDbString(reader, 15);
data.Extension = DbExportCommon.GetDbString(reader, 16);
data.CreateDate = DbExportCommon.GetDbDateTime(reader, 17);
data.UpdateDate = DbExportCommon.GetDbDateTime(reader, 18);
data.Tag = DbExportCommon.GetDbString(reader, 19);
//data.ChildTableName = MovieContents.TABLE_KIND_MOVIE_FILESCONTENTS;
listMContents.Add(data);
}
} while (reader.NextResult());
}
finally
{
if (reader != null ) reader.Close();
}
myDbCon.closeConnection();
return listMContents;
}
public MovieContentsFilterAndSort()
{
dbcon = new DbConnection();
DataSet();
}
public void DbExport(DbConnection myDbCon)
{
if (myDbCon == null)
myDbCon = new DbConnection();
myDbCon.openConnection();
string querySting = "INSERT INTO MOVIE_GROUP (NAME, LABEL, EXPLANATION, KIND) VALUES( @pName, @pLabel, @pExplanation, @pKind)";
SqlParameter[] sqlparams = new SqlParameter[4];
sqlparams[0] = new SqlParameter("@pName", SqlDbType.VarChar);
sqlparams[0].Value = Name;
sqlparams[1] = new SqlParameter("@pLabel", SqlDbType.VarChar);
sqlparams[1].Value = Label;
sqlparams[2] = new SqlParameter("@pExplanation", SqlDbType.VarChar);
sqlparams[2].Value = Explanation;
sqlparams[3] = new SqlParameter("@pKind", SqlDbType.Int);
sqlparams[3].Value = Kind;
myDbCon.SetParameter(sqlparams);
myDbCon.execSqlCommand(querySting);
}
