<%
' **********************************************************
' 行の削除
' **********************************************************
Function DeleteData(  )

	For Each strKey In MyData
		if Left( strKey, 3 ) = "Del" then
			if MyData( strKey ) = "1" then
				Query = "delete from 商品分類マスタ"
				Query = Query & " where 商品分類 = '"
				Query = Query & Replace( strKey, "Del", "" )
				Query = Query & "'"

				on error resume next		
				Cn.Execute( Query )
				if Err.Number <> 0 then
					ErrMessage = "削除に失敗しました<br>" & _
					vbCrLf & Err.Description
				end if
				on error goto 0
			end if
		end if
	
	Next

End Function

' **********************************************************
' データ読出し
' **********************************************************
Function GetData( )

	Query = "select * from 商品分類マスタ"

	if MyData("In1Meisyo") <> "" then
		Query = Query & " where 名称 like '%" & MyData("In1Meisyo") & "%'"
	end if

	Call DBGet( Cn, Rs, Query, false )

	Do While not Rs.EOF
		Call EditQueryData( )
		Rs.MoveNext
	Loop

End Function

' **********************************************************
' データベースデータの編集
' **********************************************************
Function EditQueryData(  )

	OutData = OutData & "<TR>" & vbCrLf

	OutData = OutData & "   <TD class=MyCell>"
	OutData = OutData &  Rs.Fields("商品分類").Value
	OutData = OutData & "</TD>"

	OutData = OutData & "<TD class=MyCell>"
	OutData = OutData &  Rs.Fields("名称").Value
	OutData = OutData & "</TD>" & vbCrLf

	OutData = OutData & "<TD class=MyCell>"
	OutData = OutData & "<INPUT type=checkbox value=1 name=Del"
	OutData = OutData &  Rs.Fields("商品分類").Value
	if MyData("Del" & Rs.Fields("商品分類").Value) = "1" then
		OutData = OutData & " checked "
	end if
	OutData = OutData & ">"
	OutData = OutData & "</TD>" & vbCrLf

	OutData = OutData & "</TR>" & vbCrLf

End Function

' **********************************************************
' VIEW の編集
' **********************************************************
Function EditDataHead( )


End Function

' **********************************************************
' VIEW2 の編集
' **********************************************************
Function EditDataBody( )


End Function

%>