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