/// <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;
}
/// <summary>
/// 存在するコンテンツ内のパス名をサイト内のパス群から取得する
/// </summary>
/// <param name="myDbCon"></param>
/// <returns></returns>
public static DateTime GetContentsDateOld(GroupInfo myTargetInfo, DbConnection myDbCon)
{
List<SiteInfo> listSiteInfo = new List<SiteInfo>();
string queryString = "SELECT CONTENTS_DATE FROM MOVIE_CONTENTS WHERE ACTRESS_NAME = @pName AND CONTENTS_DATE IS NOT NULL ORDER BY CONTENTS_DATE ";
SqlCommand command = new SqlCommand(queryString, myDbCon.getSqlConnection());
myDbCon.openConnection();
SqlParameter sqlparam = new SqlParameter();
sqlparam = new SqlParameter("@pName", SqlDbType.VarChar);
sqlparam.Value = myTargetInfo.name;
command.Parameters.Add(sqlparam);
SqlDataReader reader = command.ExecuteReader();
DateTime dt = new DateTime();
if (reader.Read())
{
dt = DbExportCommon.GetDbDateTime(reader, 0);
}
reader.Close();
myDbCon.closeConnection();
return dt;
}
